restore backupset from tape ... DB2 BACKUP

[chris28]

Hello ...



I have "big" problem with restore backpset with db2 backup from tape.



My configuration:

SUSE SLES 9.0 SP3

DB2 8.2

TSM 5.3.2.3

HP STORAGEWORKS 460



I'd like to simulate disaster recovery server configuration from tape.

So my backup scenario (NODE CLIENT):

- DB2 online backup on DISK POOL - OK

- TSM DB, VOLHISTORY, DEVCFG and backup (on FILE POOL) - OK

- backup TSM CFG (dsm.opt, dsm.sys, profiles) and files from FILEPOOL on DISK POOL - OK

- generate backupset from NODE CLIENT:



tsm> GENERATE BACKUPSET CLIENT tsm_backupset DEVCLASS=LTO_CLASS SCRATCH=yes RETENTION=2 DESCRIPTION="BACKUPSET for TSMDB AND DB2"



tsm> q volhistory type=backupset

Date/Time: 03/21/06 15:25:49

Volume Type: BACKUPSET

Backup Series:

Backup Operation:

Volume Seq: 1

Device Class: LTO_CLASS

Volume Name: VOLUME01

Volume Location:



tsm>q backupsetcontents client tsm_backupset.3193

Node Name Filespace Client's Name for File

Name

------------------------ ---------- ------------------------------------------

CLIENT /CEWIUPBK /NODE0000/FULL_BACKUP.20060321151254.1

...

CLIENT /opt /tivoli/backupset/42939631.dbb

CLIENT /opt /tivoli/backupset/devconfig.dat

CLIENT /opt /tivoli/backupset/volhistory.dat

CLIENT /opt /tivoli/tsm/client/ba/bin/dsm.opt

CLIENT /opt /tivoli/tsm/client/ba/bin/dsm.sys

...





#dsmc restore backupset tsm_backupset.* -loc=server {/CEWIUPBK}/NODE0000/FULL_BACKUP.20060321151254.1 /tmp/NODE0000/FULL_BACKUP.20060321151254.1 - OK



#dsmc restore backupset /dev/st0 -loc=tape {/CEWIUPBK}/NODE0000/FULL_BACKUP.20060321151254.1 /tmp/NODE0000/FULL_BACKUP.20060321151254.1 - ERROR



IBM Tivoli Storage Manager

Command Line Backup/Archive Client Interface

Client Version 5, Release 3, Level 2.2

Client date/time: 03/22/06 12:06:29

(c) Copyright by IBM Corporation and other(s) 1990, 2005. All Rights Reserved.



Restore function invoked.



Node Name: CLIENT



>>>>>> Restore Processing Interrupted!! <<<<<<

ANS1944E Error accessing file or device.



I try many options and I do not know where is a problem. so i please for help.



Thanks



Chris

Email: [email protected]

 

[stanleyb]

I'm not 100% sure what the deal is with your DB2 backups, but be careful - *if* your DB2 backups are done direct to TSM via the DB2 TDP, I don't believe you can restore them from a backupset. Tsm will let you create the backupset without erroring but I don't think you can use the TDP to restore them.



Having said that, the problem you are getting looks like a seperate issue. Has the client system got access to that /dev/st0 tape device?