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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Coats, Jack
Sent: Thursday, January 22, 2004 6:14 AM
To: ADSM-L AT VM.MARIST DOT EDU
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?