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: arnaud.brion AT panalpina DOT com
***********************************************************************




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Salak Juraj
Sent: Wednesday, 10 March, 2004 15:19
To: ADSM-L AT VM.MARIST DOT EDU
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:Arnaud.Brion AT PANALPINA DOT COM]
Gesendet: Mittwoch, 10. März 2004 14:20
An: ADSM-L AT VM.MARIST DOT EDU
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: arnaud.brion AT panalpina DOT com
***********************************************************************