How to take TSM Database backup when the TSM Server is down

 You can take TSM DB backup by using DB2 commands even after TSM server is down. There are many situations where you need to take TSM DB backup offline to start the TSM server. For example some of the reasons are if

• You havent took TSM DB backup for while and your TSM server got crashed.

• Your TSM server got crashed while taking TSM DB backup.

• If your DB backup command gets hanged you need to manually restart TSM server.

In the above situations if  you try to restart your TSM server with dsmserv command, it does not start and might show you the below error

ANR7801I Subsystem process ID is 4117.

ANR0900I Processing options file /home/tsminst1/dsmserv.opt.

ANR7814I Using instance directory /home/tsminst1.

ANR4726I The ICC support module has been loaded.

ANR0990I Server restart-recovery in progress.

ANR0172I rdbdb.c(2356): Error encountered performing action ActivateDatabase.

ANR0162W Supplemental database diagnostic information:  -1035:SQLSTATE 57019: The statement

was not successful, because of a problem with a resource.

:-1035 (SQL1035N  The database is

currently in use.  SQLSTATE=57019

and in the db2diag.log file, it will show the following error message. The location of the log is /home/tsminst1/sqllib/db2dump directory.

2015-02-17-18.40.11.234235+330 I35531942E481       LEVEL: Event

PID     : 2515                 TID  : 140736896952064PROC : db2sysc 0

INSTANCE: tsminst1             NODE : 000

EDUID   : 1                    EDUNAME: db2sysc 0

FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1000

DATA #1 : String, 47 bytes

[Force]->Number of applications to be forced :

DATA #2 : Hexdump, 4 bytes

0x00007FFFDCBEF1D4 : 0200 0000                                  ....

[tsminstn@DCMBACKUP db2dump]$ tail -20 tsminstn.0.nfy

ADM10502W  Health indicator "Database Backup Required" ("db.db_backup_req") is

in state "Manual backup required" on "database" "tsminst1.TSMDB1  ".

2015-02-17-18.00.44.237755   Instance:tsminst1   Node:000

PID:2509(db2star2)   TID:3969238816   Appid:none

base sys utilities  DB2StartMain Probe:911

In the above situation, you cannot restart your TSM server unless you take the DB backup. and we dont have any dsmserv utilities to take the TSM DB backup offline. 

Solution:

Since TSM uses DB2 database, you can take TSM DB backup using DB2 commands offline and then restart your TSM server. Please note that this backup cannot be used for DRM purpose, and you have to take TSM DB backup as soon as the server starts running fine. So here are the simple steps which might help you

1) First connect to DB2 database through command-line, Go to /home/tsminst1/sqllib/db2dump directory and run 

$ db2start

02/17/2015 18:42:59     0   0   SQL1063N  DB2START processing was successful.

SQL1063N  DB2START processing was successful.

2) Now, you have to take the DB backup by using the following command, in the below command tsmdb1 is the DB name and DBBACKUP2/dbb2 is the location where backup will be stored. make sure you have enough place for the backup to be stored in the directory.

$ db2 backup db tsmdb1 to /DBBACKUP2/dbb2

Backup successful. The timestamp for this backup image is : 20150217184833

3) After the backup is successfully completed, you can run the dsmserv command to start the TSM server as usual.

$ su - tsminst1

$ /opt/tivoli/tsm/server/bin/dsmserv

[facebook src="Uptodatewithme" width="500" height="400" hide-cover="true" posts="true"/]