It is more complex than a select.

The BACKUPS table contains the entry information you want and for each
active version file there is a object id.  That object id is used against an
internal bit file object table to determine the tape volumes that the object
is on for all copy pools.

The key here is the bit file object table is not externalized and no select
can do what you want.  What I have done to find the volume of an object is
create a file with a select of show bfo commands and use it as a macro to
pipe the output into a file and post process with a perl script to gather
the information that I need.

SHOW BFO is not supported.  The select of the active versions is going to
run forever unless you do it a filespace at a time and then if you have a
lot of them it will take a while.

So, this may be useful for say database backups where you only have 100
objects to deal with.  But, it is not practical for a file server that
hundreds of thousands of files.



Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Mark Stapleton [mailto:stapleto AT BERBEE DOT COM]
Sent: Thursday, September 26, 2002 5:18 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: select for active versions


From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Joseph Dawes
> Does anyone have a sql to see which tapes contain only the active data
> from an offsite pool? anyone ideas would be helpful. I'm trying to
> limit the amount of tapes I bring to D.R.

If the number of tapes you take to DR is important, make backupsets and
bring them.

--
Mark Stapleton (stapleton AT berbee DOT com)
Certified TSM consultant
Certified AIX system engineer
MCSE