ADSM-L

Re: archive or backup date on the tape conetents

2006-10-31 11:15:57
Subject: Re: archive or backup date on the tape conetents
From: Moulay rachid BOUSSETA <bousseta_rachid AT HOTMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 31 Oct 2006 16:14:21 +0000
Tnks 4 your replay Mztt.
but i have one problem is the same files are taken every mounth, so i have
the same name in the tape content,
q content tape 1
URANUS              Arch     /u13             10     /backup/WSF_PROD/
control01.ctl.Z
URANUS              Arch     /u13             10     /backup/WSF_PROD/
gestion01.dbf.Z
URANUS              Arch     /u13             10     /backup/WSF_PROD/
gestion02.dbf.Z
URANUS              Arch     /u13             10     /backup/WSF_PROD/
rbs01.dbf.Z
URANUS              Arch     /u13             10     /backup/WSF_PROD/
usr01.dbf.Z

q content tape 2
URANUS              Arch     /u13             10     /backup/WSF_PROD/
control01.ctl.Z
URANUS              Arch     /u13             10     /backup/WSF_PROD/
gestion01.dbf.Z
URANUS              Arch     /u13             10     /backup/WSF_PROD/
gestion02.dbf.Z
URANUS              Arch     /u13             10     /backup/WSF_PROD/
rbs01.dbf.Z
URANUS              Arch     /u13             10     /backup/WSF_PROD/
usr01.dbf.Z


how can i supparate between the two conetnts??
_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
Moulay Rachid BOUSSETA
Database & system administrator
WAFASALAF Morocco
Til: +212 22 545128
_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-





From: Matthew Warren <Matthew.Warren AT DIGICA DOT COM>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] archive or backup date on the tape conetents
Date: Tue, 31 Oct 2006 16:01:52 -0000

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

_________________________________________________________________
MSN Messenger : appels gratuits de PC ` PC !
http://www.msn.fr/newhotmail/Default.asp?Ath=f

<Prev in Thread] Current Thread [Next in Thread>