Tuesday, December 7, 2010

Cross-node TSM Restore

Cross-node TSM restore is all about restoring a database TSM backups from some other server on to another server while accessing TSM directly from the new server. If you don't want to deal with all this you can extract the files locally and copy them over to other server.

On your original instance open and check the contents of the following file "/usr/tivoli/tsm/client/api/bin64/dsm.sys" and list your TSM node names

After identifying the node name grant appropriate previlages to the user that you will mostly like use for db restore/recover purposes.

Assuming your node name is "db2inst2x-db2", your instance name owner name is "xyzp01" and your dbname is "DB001P01" - following are are the sample commands

db2adutl revoke user xyzp01 on nodename db2inst2x for db DB001P01
db2adutl grant user xyzp01 on nodename db2inst2x-db2 for db DB001P01
db2adutl query db DB001P01 nodename db21p1x-db2 owner xyzp01

db2 restore db DB001P01 use tsm options "'-fromnode=db21p1x-db2 -fromowner=xyzp01'" TAKEN AT 20101112080432 INTO DB001P01 REDIRECT

About Me

By profession I am a Database Administrator (DBA) with total 13 yrs. of experience in the field of Information Technology, out of that 9 yrs as SQL DBA and last 3 years in IBM System i/iSeries and DB2 LUW 9. I have handled Developer, plus production support roles, and I like both the roles. I love and live information technology hence the name "Techonologyyogi" Apart from that I am a small, retail investor, with small investments in India and United States in the form of Equity holdings via common stocks. Don't ask me if I have made money, I have been loosing money in stocks.