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.
Arnaud *********************************************************************** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] *********************************************************************** -----Original 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 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 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 somewhere, because command "q con xxx copied=no" gives the result .... Table named "contents" has following fields: VOLUME_NAME NODE_NAME TYPE FILESPACE_NAME FILE_NAME AGGREGATED FILE_SIZE SEGMENT CACHED FILESPACE_ID FILESPACE_HEXNAME FILE_HEXNAME But which one means "has a copy" ? Or is it anywhere else ? Thanks for your help ! Arnaud Brion *********************************************************************** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ***********************************************************************