Re: select for active versions

2002-09-27 Thread William Rosette
Joseph Dawes [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: ADSM: Subject: select for active versions Dist Stor

select for active versions

2002-09-26 Thread 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. Joseph Dawes I/T Infrasctructure - Unix Technical Support Chubb Son, a Division of Federal Insurance Company

Re: select for active versions

2002-09-26 Thread Mark Stapleton
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

Re: select for active versions

2002-09-26 Thread Seay, Paul
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