Use dsmserv utility to change TSM DB and log directories


You can move or change the TSM database, active log, and archive logs that are on the same file system to various directories on different file systems if you require. Follow the below steps to change the TSM Database and Log directories. This process involves risk and need to planned properly before implementing. Always take full TSM DB backup before making any changes
  • Back up the database by issuing the following command:
backup db type=full devclass=files
  • Halt the server.
  • Create directories for the database, active logs, and archive logs. The directories must be accessible to the user ID of the database manager. For example in UNIX:

mkdir /tsmdb005
mkdir /activelog2
mkdir /archivelog2


In Windows

mkdir l:\tsm\db005
mkdir p:\tsm\activelog
  • Create a file that lists the locations of the database directories. This file will be used if the database must be restored. Enter each location on a separate line. For example, here are the contents of the dbdirs.txt file.
/tsmdb005
/tsmdb006
/tsmdb007
/tsmdb008


On Windows


l:\tsm\db005
m:\tsm\db006
n:\tsm\db007
o:\tsm\db008
  • Remove the database instance by issuing the following command:
dsmserv removedb TSMDB1
  • Issue the DSMSERV RESTORE DB utility to move the database and create the new active log. For example:
dsmserv restore db todate=today on=dbdirs.txt activelogdirectory=/activelog2

On Windows


dsmserv restore db todate=today on=dbdirs.txt activelogdirectory=p:\tsm\activelog 
  • Restart the server.
  • Now, move the archive logs from the old directory to the new directory. Ensure that you preserve any subdirectory structure. Use and verify a recursive copy directory command:

cp -r /archivelog/* /archivelog2
 

xcopy /s k:\tsm\archivelog\*   q:\tsm\archivelog 




What Others are Reading Now...

0 Comment to "Use dsmserv utility to change TSM DB and log directories"

Post a Comment