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" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
22.06.2003 00:28
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
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
