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