Re: Select for finding if a file on tape already has a copy in a copypool

On Thursday 11 March 2004 01:35, PAC Brion Arnaud wrote: > Hi Juraj, > > Thanks for the tip, I could probably use it, case I would not succeed in > building a proper SQL statement. But so far, I really need that precise > info to build a sub-query in my main query ... Cheers. I don't think the "co

Re: Select for finding if a file on tape already has a copy in a copypool

Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Salak Juraj Sent: Wednesday, 10 March, 2004 15:19 To: [EMAIL PROTECTED] Subject: AW: Select for finding if a file on tape already has a copy in a copypool Hi, would not "backup stg from-pool to-pool PREVIE

AW: Select for finding if a file on tape already has a copy in a copypool

Hi, would not "backup stg from-pool to-pool PREVIEW=YES do? Juraj -Ursprüngliche Nachricht- Von: PAC Brion Arnaud [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 10. März 2004 14:20 An: [EMAIL PROTECTED] Betreff: Select for finding if a file on tape already has a copy

Select for finding if a file on tape already has a copy in a copypool

Hi all, I'm trying to build a query which could estimate the remaining time before my copy stgpool jobs ends. A first step would be to find out which files still have no copy in copypools. Therefore I would like to know in which table and field name I could find this information. Must be existing