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:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 5:18 PM To: [EMAIL PROTECTED] Subject: Re: select for active versions From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]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 ([EMAIL PROTECTED]) Certified TSM consultant Certified AIX system engineer MCSE
