ADSM-L

DB2 backup : show versions doesn't find any file ...

2003-04-14 09:36:16
Subject: DB2 backup : show versions doesn't find any file ...
From: PAC Brion Arnaud <Arnaud.Brion AT PANALPINA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 14 Apr 2003 15:35:42 +0200
Hi *SM'ers

I'm having a bad feeling about this one, and would like some explanations ....
The problem : we're doing backups from a DB2 system, using TSM API. The backups 
are done, I can restore the files without problems, but when trying to use 
"show versions" command, TSM server doesn't return anything. I'm sure files are 
existing, as a "q con" on the volume where those files are copied returns 
(snippet of it) :

Node Name        Type  Filespace   FSID  Client's Name for File                
                       Name              
---------------  ----  ----------  ----  --------------------------------------
PACRS310         Bkup  /LDAPDB2      15  /NODE0000/ FULL_BACKUP.20030411000002-
                                          .1                                   
PACRS310         Bkup  /LDAPDB2      15  /NODE0000/ FULL_BACKUP.20030412000002-
                                          .1                                   
PACRS310         Bkup  /GFX          16  /NODE0000/ FULL_BACKUP.20030411040002-
                                          .1                                   
PACRS310         Bkup  /WAS35        17  /NODE0000/ FULL_BACKUP.20030411044001-
                                          .1                                   
PACRS310         Bkup  /OPN          18  /NODE0000/ FULL_BACKUP.20030411052002-
                                          .1                                   

On db2 server, inclexcl looks like : 

include         /LDAPDB2/NODE0000/FULL*.*         MGMT-DB2-L0 
include         /GFX/NODE0000/S*.LOG              MGMT-DB2-L1
include         /GFX/NODE0000/FULL*.*             MGMT-DB2-L0 
include         /WAS35/NODE0000/S*.LOG            MGMT-DB2-L1
include         /WAS35/NODE0000/FULL*.*           MGMT-DB2-L0 
include         /OPN/NODE0000/S*.LOG              MGMT-DB2-L1
include         /OPN/NODE0000/FULL*.*             MGMT-DB2-L0 
include         /LDAP/NODE0000/S*.LOG             MGMT-DB2-L1
include         /LDAP/NODE0000/FULL*.*            MGMT-DB2-L0 

On tsm server, q fi for this node looks like :

PACRS310        /LDAPDB2      15 DB2/6000 API:DB2/-    No     27.829,9 100,0
                                           6000                             
PACRS310        /GFX          16 DB2/6000 API:DB2/-    No      1.437,9 100,0
                                           6000                             
PACRS310        /WAS35        17 DB2/6000 API:DB2/-    No      3.541,5 100,0
                                           6000                             
PACRS310        /OPN          18 DB2/6000 API:DB2/-    No      1.687,4 100,0
                                           6000                             
PACRS310        /LPAD         19 DB2/6000 API:DB2/-    No      1.796,1 100,0
                                           6000                             
PACRS310        /fsinst1      20 DB2/6000 JFS          No      4.480,0  84,5

But either "show versions pacrs310 /LDAPDB2" or "show versions pacrs310 
/LDAPDB2/NODE0000" returns :

ANR0852E SHOW: No matching file spaces found for node PACRS310.
I also tried with other filespaces /GFX, /WAS35 etc ... without result
Could you shed some light on me ?

TIA.
Regards.

Arnaud


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group     |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01       | 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

<Prev in Thread] Current Thread [Next in Thread>
  • DB2 backup : show versions doesn't find any file ..., PAC Brion Arnaud <=