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


Now restore the database with ‘use adsm’ on the target server.


  • 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,