Jack, you can do a "backup stg <primarypool> <copypool> maxpr=1 preview=yes wait=yes" and it will give you that information.
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Coats, Jack Sent: Thursday, January 22, 2004 6:14 AM To: [EMAIL PROTECTED] Subject: SQL Query for amount to copy from tape pool to copy pool It is possible to get a feel for how much needs to be migrated from a disk pool to a tape pool by using a 'q stg' command. Is there something that would give a similar number to know how much needs to be put in a copy pool from either a disk or tape pool? I was guessing some SQL query might work, but don't know for sure. (basically, how many gig needs to be put into the copy pool from each of the primary storage pools) Suggestions?