We are having trouble finding some logs on TSM for db2.  I can show that it was 
archived successfully but when dba goes to restore, it is not there.  A 
db2adutl query does not show the file but it does show in the history.  Where 
did the file go?

Any help would be appreciated!  I am not a dba and not sure what activity may 
have occurred on the client server itself that would have been reason for the 
logs to disappear.


AIX - 5.3
TSM Server 5.4.0.2
TSM Client  5.4.0.0
DB2 - Ver. 9



Db2diag.log shows file archive successfully.

2007-12-01-06.33.32.557980+000 I1273312A372       LEVEL: Warning
PID     : 630788               TID  : 1           PROC : db2logmgr (IR2) 0
INSTANCE: db2ir2               NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0322766.LOG to TSM chain 1 from
          /db2/IR2/log_dir/NODE0000/.

Db2adutl query

Retrieving LOG ARCHIVE information.
   Log file: S0323352.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 
2007-12-01-12.20.27
   Log file: S0323353.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 
2007-12-01-12.20.42
   Log file: S0323354.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 
2007-12-01-12.21.24
   Log file: S0323355.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 
2007-12-03-07.15.17
   Log file: S0323356.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 
2007-12-03-18.33.39
   Log file: S0323357.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 
2007-12-03-18.40.52
   Log file: S0323358.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 
2007-12-03-18.41.40
   Log file: S0323359.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 
2007-12-03-23.02.02
   Log file: S0323360.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 
2007-12-04-00.09.32


 db2 list history archive log since 20071201 for ir2 | grep -i S0322772.LOG
  X  D  20071201064845      1    A  S0322772.LOG C0000001


Thank you!
------------------------------------------
Medtronic
Collins, Brenda
Sr. Principle Systems Technologist
[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
tel: 763-514-4969
mobile: 763-218-9596
------------------------------------------
Always have my latest 
info<https://www.plaxo.com/add_me?u=60130810166&v0=1860631&k0=2093372666&src=client_sig_212_1_card_join&invite=1>
 Want a signature like this? 
<http://www.plaxo.com/signature?src=client_sig_212_1_card_sig>


___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is 
intended for use only by the individual or entity to which it is addressed, and 
may contain information that is private, privileged, confidential or exempt 
from disclosure under applicable law. If you are not the intended recipient or 
it appears that this mail has been forwarded to you without proper authority, 
you are notified that any use or dissemination of this information in any 
manner is strictly prohibited. In such cases, please delete this mail from your 
records.

To view this notice in other languages you can either select the following link 
or manually copy and paste the link into the address bar of a web browser: 
http://emaildisclaimer.medtronic.com

Reply via email to