Use dsmserv utility to change TSM DB and log directories

• 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

mkdir q:\tsm\archivelog



Also Read: How to increase or decrease TSM DB, active log and archive log size ?

• 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

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