Troubleshooting
Problem
The backup of the TSMDB1 database fails with message: ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: -53
Cause
The communication method for the database manager is not correctly configured.
Diagnosing The Problem
Verify that the API's dsm.sys file is correctly configured for communication with the server:
1. Find the location of the tsmdbmgr.opt and dsm.sys files. Making the assumption that the OS environment is the same as the running instance, run the "env" command as the database instance user. For example:
$ env | grep DSM
DSMI_DIR=/opt/tivoli/tsm/server/bin/dbbkapi
DSMI_LOG=/home/tsminst1/tsminst1
DSMI_CONFIG=/home/tsminst1/tsminst1/tsmdbmgr.opt
If there is reason to believe that the DB2 instance was started with a different environment, the "ps eww" command can be used to verify the environment that is held within DB2 memory.
The tsmdbmgr.opt file will be indicated by the value for DSMI_CONFIG, and the dsm.sys file will be located in the directory defined by DSMI_DIR.
2. Find the value of SERVERNAME in tsmdbmgr.opt, for example:
SERVERNAME TSMDBMGR_tsminst1
3. For Tivoli Storage Manager versions 6 and 7, find the value for COMMMETHOD, TCPSERVERADDRESS, and TCPPORT in the stanza of the dsm.sys file which matches the SERVERNAME found in the tsmdbmgr.opt file. For example:
COMMMETHOD tcpip
TCPPORT 1500
TCPSERVERADDRESS 127.0.0.1
Make sure that the values for COMMMETHOD and TCPPORT match the values found in the dsmerv.opt file.
Alternatively, for Tivoli Storage Manager and IBM Spectrum Protect versions 7.x, you can used shared memory instead of TCPIP as the communication method. In that case, make sure the following lines are in the correct SERVERNAME stanza of the dsm.sys and that matching values are found in the dsmserv.opt file. For example:
COMMMETHOD sharedmem
SHMPORT 1501
Resolving The Problem
Make necessary corrections as the root user to the API's dsm.sys file.
For more information about the correct configuration for backup and restore of the tsmdb1 database, refer to the IBM Tivoli Storage Manager Knowledge Center and search for the section 'Preparing the database manager for database backup'.
Related Information
Product Synonym
TSM ADSM
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21990047