What does DB2 logs show during the restore
------Original Message------
From: Collins, Brenda
Sender: ADSM: Dist Stor Manager
To: ADSM-L AT VM.MARIST DOT EDU
ReplyTo: ADSM: Dist Stor Manager
Subject: [ADSM-L] Client in SENDW state
Sent: Feb 2, 2009 15:57
Hi everyone!
I have a client that can not resore a DB2 database. It does backup fine but
when restoring, it restores a certain amount of data and then goes into a
'sendw' state. After about 9 - 10 min., the client terminates the session with
TSM.
TSM Server - 5.5.1.1
Client 5.4.0.0
DB2 Backups using API
AIX 5.3 (both TSM server and client)
We have done the following.
Network traces
Check for firewall and/or load balancer timeouts.
Checked for ports being blocked.
Restore from virtual tape, same timeout issue.
Restore from physical tape, timeout issue.
Restored db to a different client server, using both virtual tape and physcial
tape,it restored fine.
Built duplicate filesystem on different client server and was able to restore
db fine and bring it up.
The fact that we have proved TSM can restore the data on the tape and that the
database can be brought up successfully on a different server seems to point to
an AIX problem but I am not sure what. Backups on the client going to TSM
work fine, it is just the restore process that terminates.
If anyone has run across this problem and can provide some assistance, it would
be greatly appreciated.
Brenda Collins,
Sr. Principal Systems Admin
Medtronic, Inc.
Ph: 763-505-6057
Mobile: 763-218-9596
[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
Sent via BlackBerry by AT&T
|