Brenda,
i agree with Eduardo; another possibility is, your dba is using a db2
instance with a configuration looking on another tsm server instance (do
you have more than on?); each db2 instance should have her own dsm.opt.
This is where my dba sometimes failes.
kind regards
Dierk
Eduardo Esteban <eesteban AT US.IBM DOT COM>
Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04.12.2007 22:52
Bitte antworten an
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
An
ADSM-L AT VM.MARIST DOT EDU
Kopie
Thema
Re: [ADSM-L] DB2 / TSM Question <Virus checked>
Maybe the logs were archived to directory specified by the DB2 database
FAILARCHPATH configuration option.
If an error occurs archiving the logs to the TSM server, the logs are
archived to the directory specified by this option.
Eduardo
"Collins, Brenda" <brenda.s.collins AT MEDTRONIC DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
12/04/2007 12:44 PM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT EDU
cc
Subject
DB2 / TSM Question
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
brenda.s.collins AT medtronic DOT com<mailto:brenda.s.collins AT medtronic DOT
com>
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
Bürgel Wirtschaftsinformationen GmbH & Co. KG
Gasstraße 18
22761 Hamburg
Geschäftsführer: Rolf Pries, Hans-Werner Scherer, Dr. Norbert Sellin
Registergericht: Hamburg HRA 85212, USt-IdNr. DE 117 981 371, Steuer-Nr.
27/541/00020, Sitz der Gesellschaft: Hamburg
Geschäftsführende Gesellschafterin: Bürgel Wirtschaftsinformationen
Verwaltungs-GmbH, Registergericht: Hamburg HRB 45 704
|
