It depends on your definition of "qualifying storage pool" but it might be
worth to look at STGPOOLS table and select from it.

Zlatko Krastev
IT Consultant






"Steve, Taylor" <steve_taylor AT SYMPATICO DOT CA>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
22.06.2003 00:28
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        How to query if there is data to migrate for a primary 
storage pool??


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