Not sure what your asking, but

Select * from stgpools

will give you stgpool data in total.

>>> steve_taylor AT SYMPATICO DOT CA 06/21/03 05:28PM >>>
Hi,

Is there a SQL query example, that shows how we can determine if a
storagepool has qualifying data that can migrate ....

We have a shell script the lowers the thresholds (higmig=1, and
lowmig=0) to force a migration..... and waits... eventually timing out,
or finding a completion message...

I was hoping there was a way to determine if we should even try to do a
migration, to save lots of looping and sleeps in our shell scripts..

Any suggestions would be appreciated..

Thanks,

Steve Taylor