Re: archive or backup date on the tape conetents

Hi,

query content will not show you the date an object was inserted to the
library no matter how you ask it.  You could do something similar to;

tsm: SOFASAP30_SERVER1>q content S00810L1

Node Name        Type  Filespace   FSID  Client's Name for File
                       Name
---------------  ----  ----------  ----
--------------------------------------
SOFASAP04_TDP    Arch  tdpmux         2  \ DB2P01A0ETLXG4NS_1368
SOFASAP04_TDP    Arch  tdpmux         2  \ DB2P01A0ETNCW0BD_1378
SOFASAP04_TDP    Arch  tdpmux         2  \ DB2P01A0ETOSBUUL_1384
SOFASAP04_TDP    Arch  tdpmux         2  \ DB2P01A0ETQ7RP0T_1387
SOFASAP04_TDP    Arch  tdpmux         2  \ DB2P01A0ETRN7RRL_1393
SOFASAP04_TDP    Arch  tdpmux         2  \ DB2P01A0ETUI4TJJ_1404
SOFASAP04_TDP    Arch  tdpmux         2  \ DB2P01A0ETVZPVNV_1411

tsm: SOFASAP30_SERVER1>select * from archives where ll_name like
'%DB2P01A0ETVZPVNV_1411%'

     NODE_NAME: SOFASAP04_TDP
FILESPACE_NAME: tdpmux
  FILESPACE_ID: 2
          TYPE: FILE
       HL_NAME: \
       LL_NAME: DB2P01A0ETVZPVNV_1411
     OBJECT_ID: 929762
  ARCHIVE_DATE: 2006-10-29 22:00:48.000000
         OWNER:
   DESCRIPTION:
DB2P01A0ETVZPVNV_10.134.0.230:SOFASAP30@SAPMC#550141100204
    CLASS_NAME: SAPMC
 

Beware making such open ended queries against the archives or backps
table. It's much better to narrow things down by node_name if possible.

Matt.



> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of Moulay rachid BOUSSETA
> Sent: 31 October 2006 14:51
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] archive or backup date on the tape conetents
> 
> hi all,
> how can i display the date of archiving or backup when i list the tape
> content.
> 
> tnks in advance
> 
> 
> 
> _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
> Moulay Rachid BOUSSETA
> Database & system administrator
> WAFASALAF Morocco
> Til: +212 22 545128
> _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
> 
> _________________________________________________________________
> MSN Messenger: appels gratuits de PC ` PC !
> http://www.msn.fr/newhotmail/Default.asp?Ath=f
> 
> 
>  
> 


This email is confidential and may be privileged. If you are not the intended 
recipient please notify the sender immediately and delete the email from your 
computer. 

You should not copy the email, use it for any purpose or disclose its contents 
to any other person.
Please note that any views or opinions presented in this email may be personal 
to the author and do not necessarily represent the views or opinions of Digica.
It is the responsibility of the recipient to check this email for the presence 
of viruses. Digica accepts no liability for any damage caused by any virus 
transmitted by this email.

UK: Phoenix House, Colliers Way, Nottingham, NG8 6AT UK
Reception Tel: + 44 (0) 115 977 1177
Support Centre: 0845 607 7070
Fax: + 44 (0) 115 977 7000
http://www.digica.com

SOUTH AFRICA: Building 3, Parc du Cap, Mispel Road, Bellville, 7535, South 
Africa
Tel: + 27 (0) 21 957 4900
Fax: + 27 (0) 21 948 3135
http://www.digica.com