Cross-node recovery - TSM

To recover/access the backup image of the database that was backed up from a different server. Typically to access production database from dev/qa

Comment out "PASSWORDACCESS = generate" in file "/usr/tivoli/tsm/client/ba/bin/dsm.sys" by adding a '*' in the beginning of the line.

Now we should be able to query any backup image, provided you have the required details.

db2adutl query db <dbname> nodename <nodename> owner <owner> password <passwd>


Update the following db parameters in the target db with source db values from dsm.sys to restore the db backed-up from a different server

• TSM_NODENAME
  
• TSM_OWNER
  
• TSM_PASSWORD
  

Now restore the database with 'use adsm' on the target server.

NOTE:

• Revert back the dsm.sys & db params after the refresh. Else local backups to TSM will fail.

Other References: IBM Documentation