One command that will get you similar information is
'query content', which has an argument "copied" to indicate if
the file has a copy in a copy pool.

For example, issuing the command 'q con MBCO01 copied=no' will
give you a list of any files on the volume MBCO01 that do *not*
exist in a copy storage pool.

Another command that can help give you the warm fuzzies is
'query occupancy' which breaks down the amount of storage a node
uses in different storage pools. Assuming all of your primary
pools are backed up to copy storage pools, the sum of the space
occupied in the primary pools should be equal to the sum of the
space occupied in the copy pools.

Neither of these will allow you to pick a specific file and find
out whether it has a copy in a copy pool (unless you know the
volume in the primary storage pool which holds the original
backup/archive file), but I think they might give you something
close to what you would like.

 -- Tom

Thomas A. La Porte
DreamWorks Feature Animation
tlaporte AT anim.dreamworks DOT com

On Fri, 14 Aug 1998, Lynch, Rich wrote:

>Anybody know a good query command I can use to check the status of my
>files that I believe are being copied to offsite copypools. Im going to
>Sunguard to test DR and I want to make sure I have all my files on my
>tapes that are in the vault (well, I wont check for all my files, that
>would take a couple of years, but I want to get the warm fuzzies that If
>I pick a file at random, like /oracle/PRD/bin/svrmgrl - that copies of
>that file reside on a copy pool tape. How do I do this?
>