Start with 128GB and keep 20% extra space in the filesystem in cas of trouble Up to 512GB in version 8.1.8
Start with minumum 3x the size of active log
TSM v6 database is self expanding, as long as there is enough space into filesystems or drives (Windows). Then to extend the DB, expand the LUNs, or add new disks or filesystems, and add it to the dbspace:
TSM:SERVER1> extend dbspace /tsmdb005,/tsmdb006
If a significant amount of data has been deleted from the database, consider reducing the database size.
TSM:SERVER1> backup db devclass=tapeclass type=full
TSM:SERVER1> dsmserv removedb TSMDB1
TSM:SERVER1> dsmserv restore db todate=today on=dbdirs.txt
For tape libraries, you need to add one line per K7, with element number on the VTL
/* LIBRARYINVENTORY SCSI TS3100 885BCML5 4097 101*/
/* Device Configuration */ SET SERVERNAME TSM_OPECGDY DEFINE LIBRARY TS3100 LIBTYPE=SCSI SERIAL="00L2U78V8326_LL0" SHARED=NO AUTOLABEL=NO RESETDRIVE=YES DEFINE DRIVE TS3100 DRIVE1 ELEMENT=256 ONLINE=Yes WWN="2001000E1114975E" SERIAL="1068045826" DEFINE DRIVE TS3100 DRIVE2 ELEMENT=257 ONLINE=Yes WWN="2004000E1114975E" SERIAL="1068069878" /* LIBRARYINVENTORY SCSI TS3100 885BCML5 4097 101*/ /* LIBRARYINVENTORY SCSI TS3100 886BCML5 4104 101*/ /* LIBRARYINVENTORY SCSI TS3100 887BCML5 4100 101*/ /* LIBRARYINVENTORY SCSI TS3100 888BCML5 4096 101*/ /* LIBRARYINVENTORY SCSI TS3100 889BCML5 4103 101*/ /* LIBRARYINVENTORY SCSI TS3100 895BCML5 4107 101*/ /* LIBRARYINVENTORY SCSI TS3100 896BCML5 4111 101*/ /* LIBRARYINVENTORY SCSI TS3100 897BCML5 4115 101*/ /* LIBRARYINVENTORY SCSI TS3100 898BCML5 4106 101*/ /* LIBRARYINVENTORY SCSI TS3100 899BCML5 4112 101*/ /* LIBRARYINVENTORY SCSI TS3100 915BCML5 4116 101*/ /* LIBRARYINVENTORY SCSI TS3100 916BCML5 4102 101*/ /* LIBRARYINVENTORY SCSI TS3100 917BCML5 4098 101*/ /* LIBRARYINVENTORY SCSI TS3100 918BCML5 4101 101*/ /* LIBRARYINVENTORY SCSI TS3100 919BCML5 4105 101*/ /* LIBRARYINVENTORY SCSI TS3100 935BCML5 4113 101*/ /* LIBRARYINVENTORY SCSI TS3100 936BCML5 4114 101*/ /* LIBRARYINVENTORY SCSI TS3100 937BCML5 4099 101*/ /* LIBRARYINVENTORY SCSI TS3100 938BCML5 4108 101*/ /* LIBRARYINVENTORY SCSI TS3100 939BCML5 4110 101*/ /* LIBRARYINVENTORY SCSI TS3100 940BCML5 4109 101*/ /* LIBRARYINVENTORY SCSI TS3100 941BCML5 4117 101*/ DEFINE PATH TSM_OPECGDY TS3100 SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=lb2.1.0.5 ONLINE=YES DEFINE PATH TSM_OPECGDY DRIVE1 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3100 DEVICE=mt2.0.0.5 ONLINE=YES DEFINE PATH TSM_OPECGDY DRIVE2 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3100 DEVICE=mt3.0.0.5 ONLINE=YES DEFINE DEVCLASS ULTRIUM5 DEVT=LTO FORMAT=ULTRIUM5C MOUNTL=DRIVES MOUNTWAIT=15 MOUNTRETENTION=15 PREFIX=ADSM LIBRARY=TS3100 WORM=NO DRIVEENCRYPTION=ALLOW LBPROTECT=NO SERVERBACKUPNODEID 1
You can move only the database to new directories. To move the database from one location on the server to another location, follow this procedure:
TSM:SERVER1> backup db type=full devclass=files
mkdir /tsmdb005 mkdir /tsmdb006 mkdir /tsmdb007 mkdir /tsmdb008
/tsmdb005 /tsmdb006 /tsmdb007 /tsmdb008
TSM:SERVER1> dsmserv removedb TSMDB1
TSM:SERVER1> dsmserv restore db todate=today on=dbdir.file
As « tsminst1 » user, stop the TSM server:
# dsmserv removedb
Stop DB2 as tsminst1 user:
# db2stop
List the DB2 instance and remove it:
[tsminst1@tsmsrv]/tsm/config# db2ilist tsminst1 [tsminst1@tsmsrv]/tsm/config# db2idrop tsminst1
Then remove the directories DB, log, archlog, configuration files.
If the log is running out of space, the current transaction is rolled back, and the server issues an error message and halts. You cannot restart the server until the active log size is increased.
To increase the size of the active log while the server is halted, complete the following steps:
activelogsize 131072
Log files of 512 MB are automatically defined until the size specified in the ACTIVELOGSIZE server option is reached. If a log mirror exists, log files are also defined automatically.
You can move only the active log from one directory to another.
mkdir /activelog2
activelogdir /activelog2
http://www-01.ibm.com/support/docview.wss?uid=swg21567061
tsm: LU21TSM01>q log f=d Active Log Directory: /tsmserver/tsminst1/tsmactilog Total Space(MB): 8,192 Used Space(MB): 55 Free Space(MB): 8,137 Archive Log Directory: /tsmserver/tsminst1/tsmarchlog Total Size of File System (MB): 32,768.00 Space Used on File System (MB): 334.79 Free Space(MB): 32,433.21 Mirror Log Directory: Total Size of File System (MB): Space Used on File System (MB): Free Space(MB): Archive Failover Log Directory: /tsmserver/tsminst1/tsmarcflog Total Size of File System (MB): 15,360.00 Space Used on File System (MB): 7,826.44 Free Space(MB): 7,533.56
As tsminst1 db2 connect to tsmdb1 db2 get db cfg |grep LOG
tsminst1@TSM01:/home/tsminst1>db2 get db cfg | grep -i tsminst Path to log files = /tsmserver/tsminst1/tsmactilog/NODE0000/LOGSTREAM0000/ Mirror log path (MIRRORLOGPATH) = /tsmserver/tsminst1/tsmmirrlog/NODE0000/LOGSTREAM0000/ First log archive method (LOGARCHMETH1) = DISK:/tsmserver/tsminst1/tsmarchlog/ Failover log archive path (FAILARCHPATH) = /tsmserver/tsminst1/tsmarcflog/
If the paramaters aren't updated, you can stop TSM, start DB2 manually, update the paramater and stop DB2 before starting TSM again.
db2 update db cfg for tsmdb1 using MIRRORLOGPATH ''
It’s not possible to reduce or increase the size of the archive log, it’s done automatically, depending on space available on the filesystem or drive. You can move only the archive log from one directory to another.
mkdir /archivelog2
archivelogdir /archivelog2
cp -r /archivelog/* /archivelog2
System Database Directory
The system database directory resides in the SQLDBDIR subdirectory in the instance directory. This directory is used to catalog both local and remote databases. The directory contains the database name, alias, type, and node where the database resides. If the database is local, a pointer to the local database directory is located in the system database directory. If the database is remote, there is a pointer to the node directory.
As instance user
$ db2 catalog db TSMDB1 on <path_instance>
make a copy of all files located in the instance user home directory
After renaming the instance file, complete the following steps. Important: Complete steps 1-6 for each one of your Tivoli Storage Manager server instances.
1. Issue the following command: installation_directory\db2\bin\db2idrop InstanceName
2. Start the installation wizard again and step through it to upgrade the Tivoli Storage Manager server.
3. After the upgrade, recreate each of the instances using the following command: installation_directorydb2\bin\db2icrt InstanceName –u InstanceUser, password
4. Recreate the variables in the instance file using the db2set -i command. Issue this command for each variable in your instance file. Ensure that the variable is in quotation marks: installation_directory\db2\bin\db2set –i InstanceName “Variable”
For example, to recreate the first variable in the example instance file, issue the following command: db2set -i server1 “DB2_SKIPINSERTED=ON”
5. Stop and start the database instance:
a. Open a DB2 command window. One method of doing this is by going to the C:\Program Files\Tivoli\TSM\db2\bin directory, or if you installed Tivoli Storage Manager in a different location, go to the db2\bin subdirectory in your main installation directory. Then, issue this command: db2cmd
b. Set the database instance: set db2instance=InstanceName
c. Start DB2: db2start
d. Catalog and upgrade each database name. The DatabasePath is the drive, for example, D:, if the DB2 database catalog exists on the D drive. “db2 catalog db DatabaseNameon DatabasePath“ “db2 upgrade db DatabaseName”
e. Stop DB2: db2stop
6. Start and run the Tivoli Storage Manager server.