IBM Support

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

Troubleshooting


Problem

A Tivoli Storage Manager BACKUP DB fails with an ANR2968, sqlcode -2033 and sqlerrmc 138.

Cause

The most likely cause of the 138 error code is the Trusted Communication Agent (dsmtca) does not have the correct permissions or it is not owned by root.

Diagnosing The Problem

The following message is seen in the Tivoli Storage Manager activity log:


    ANR2968E Database backup terminated. DB2 sqlcode: -2033 sqlerrmc: 138.
    The "sqlerrmc: 138" is a Tivoli Storage Manager API return code.
     
The API return codes with an explanation can be found at the following link: http://publib.boulder.ibm.com/infocenter/tsminfo/v6/topic/com.ibm.itsm.messages.doc/apirtncodes.html

The specific API return code of 138 can be found at the following link:
http://publib.boulder.ibm.com/infocenter/tsminfo/v6/topic/com.ibm.itsm.messages.doc/msgs7345.html
    0138 E: DSM_RC_TA_NOT_VALID The trusted agent execution/owner permissions are invalid.
    Explanation
    The trusted agent execution/owner permissions are invalid.
    System action
    Processing stopped.
    User response
    Have your system administrator check the installation instructions for the client to ensure that the trusted agent permissions are set correctly.

Resolving The Problem

To resolve the ANR2968, sqlerrmc 138 verify the following:

    • Does the dsmtca exist in the directory specified by the DSMI_DIR environment variable?
    • Is the dsmtca owned by root?
    • Are the permissions for the dsmtca set to 6755 (-rwsr-sr-x)?
If you answered no to any of these questions, resolve the issue and try the backup again.

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

Document Information

Modified date:
17 June 2018

UID

swg21638886