Moving TSM V6 database to new directories

TSM Server Version: 6.1

OS Platform: AIX 6.1

You can move TSM DB from one location to alternate location using following method:

• Create new directories where you want to move DB.
• Make sure DB instance user is the owner of these directories.
• List these directories inside a file. List each directory on a single line.For  example below are the contents of file dbvol.txt

/tsmdb/db001

/tsmdb/db002

/tsmdb/db003

/tsmdb/db004

• Halt TSM server
• Remove tsm db using following command:

dsmserv  removedb TSMDB1 -i /home/tsminst1/tsminst1

• Restore tsm db using following command:

dsmserv -i /home/tsminst1/tsminst1 restore db todate=today on=/home/tsminst1/dbvol.txt

where todate option can be used to restore database to any point in date and dbvol.txt is the file which contains db direcories location.Version 6 onwards require volume history file to restore tsm db.

Commands need to run by db instance owner id.

At last when restore db finishes following message comes.This means db restore is completed.
ANR0369I Stopping the database manager because of a server shutdown.

You may receive waning messages like below during db restore.These can be ignored.

ANR0498W Session < session no.>  refused for <node name> because restore DB is in progress.