ADSM-L

[ADSM-L] Can query but not extract DB2 API log archives

2013-03-20 16:33:05
Subject: [ADSM-L] Can query but not extract DB2 API log archives
From: Rick Adamson <RickAdamson AT WINN-DIXIE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 20 Mar 2013 20:30:57 +0000
Hi,
Not being a DB2 expert I am hoping that someone can advise me on a strange 
situation with a AIX/DB2 client.
The client OS is AIX 7.1 and BA client level is 6.3.0.15.
In addition to file-level backups it also uses the BA API to perform DB2 
database backups and archive logs.
DB2 is version 9.7
It can backup the DB's and archive the logs. You can successfully query the TSM 
Server for a list of the log and DB objects in TSM storage, but when you 
attempt to perform an extract you receive an error that the object does not 
exist.
Can anyone point me in the direction of the cause?

Below is a sample of the query process and attempted extract.


.. db2adutl query logs for db spmsp01 ..

   Log file: S0171368.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.00.55
   Log file: S0171369.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.05.03
   Log file: S0171370.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.09.44
   Log file: S0171371.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.15.20
   Log file: S0171372.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.20.57
   Log file: S0171373.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.25.24
   Log file: S0171374.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.28.53
   Log file: S0171375.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.32.45
   Log file: S0171376.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.36.49
   Log file: S0171377.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.40.53
   Log file: S0171378.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.44.18
   Log file: S0171379.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.48.37
   Log file: S0171380.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.53.18
   Log file: S0171381.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-13.57.08
   Log file: S0171382.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-14.03.52
   Log file: S0171383.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-14.11.06
   Log file: S0171384.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-14.17.10
   Log file: S0171385.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-14.22.25
   Log file: S0171386.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-14.26.26
   Log file: S0171387.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 
2013-03-20-14.30.19

... db2adutl extract logs between S0171369.LOG and S0171376.LOG db spmsp01

Query for database SPMSP01


Retrieving LOG ARCHIVE information.
  No LOG ARCHIVE images found for SPMSP01

Any feedback is greatly appreciated.
~Rick

<Prev in Thread] Current Thread [Next in Thread>
  • [ADSM-L] Can query but not extract DB2 API log archives, Rick Adamson <=