IBM Support

TSMDB1 backup fails with ANR2968E, DB2 sqlerrmc: -53

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'.

IBM Tivoli Storage Manager Knowledge Center

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"6.3;7.1","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM ADSM

Document Information

Modified date:
17 June 2018

UID

swg21990047