Not sure what your asking, but Select * from stgpools
will give you stgpool data in total. >>> [EMAIL PROTECTED] 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
