Cross-node recovery – TSM

November 3, 2005

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

tags: , ,
posted in DB2 by Visu

Follow comments via the RSS Feed | Leave a comment | Trackback URL

Leave Your Comment

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org