IBM Support

ANR2968E error with sqlcode -2033 and sqlerrmc -50 with backup db process

Troubleshooting


Problem

A database backup on Tivoli Storage Manager server running on AIX fails with ANR2968E error.

Symptom

The database backup was running successfully in the past, but started failing even if no configuration changes were done with the Tivoli Storage Manager server instance. The following error was logged in the activity log:

ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: -50

Diagnosing The Problem

Examine the /usr/tivoli/tsm/client/api/bin64/dsm.sys file and verify the TCPSERVERADDRESS option. For example :

SERVERNAME TSMDBMGR_tsminst1
COMMMETHOD TCPIP
TCPPORT 1500
TCPSERVERADDRESS localhost
PASSWORDACCESS generate
NODENAME $$_TSMDBMGR_$$
PASSWORDDIR /home/tsminst1
ERRORLOGNAME /home/tsminst1/tsmdbmgr.log

In this example, the TCPSERVERADDRESS was set to localhost, Run the "ping localhost" command to verify that it resolves to the correct address. If the localhost is resolved to an incorrect tcp/ip address, this indicates a problem with hostname resolution.

Resolving The Problem

There are 2 possible solutions listed below.

  1. Resolve the problem with name resolution in AIX so that 'localhost' can be resolved to the right IP address.
  2. Alternatively, edit /usr/tivoli/tsm/client/api/bin64/dsm.sys file and change

    TCPSERVERADDRESS localhost

    --to--

    TCPSERVERADDRESS 127.0.0.1

    Save the changes to the dsm.sys file and run the database backup again.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"}],"Version":"All Supported Versions","Edition":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21633106

Page Feedback