IBM Support

Tivoli Storage Manager Server Database backup fails with sqlerrmc: 2025

Troubleshooting


Problem

A database backup is run and fails with the following error : []ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 2025[]

Symptom

The backup is run with the following command :
Backup DB Type=full devclass=class_name
The backup fails with the following errors :

10/28/11 11:42:19 ANR0406I Session nn started for node $$_TSMDBMGR_$$ DB2/LINUXX8664) (Tcp/Ip localhost(20967)). (SESSION: nn)
10/28/11 11:42:19 ANR0403I Session nn ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664). (SESSION: nn)
10/28/11 11:42:19 ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 2025. (SESSION: nn, PROCESS: xx)
10/28/11 11:42:19 ANR0985I Process xx for DATABASE BACKUP running in the BACKGROUND completed with completion state FAILURE at 11:42:19 AM. (SESSION: 32710, PROCESS: 82)

Cause

DB2 instance is configured with an incorrect management class

Diagnosing The Problem

The "DB2 sqlerrmc: 2025" error indicates the backup failed because of a Tivoli Storage Manager API error. The API reason code of "2025" means the following :

2025 E: DSM_RC_INVALID_MCNAME The management class name was not found.
Explanation
A query or send operation is unable to find the management class name.

Logon as the instance owner and run the following command to verify if a management class is specified in the database configuration :

db2 get db cfg for tsmdb1 |grep TSM_MGMTCLASS

For example, the command may return :

TSM management class (TSM_MGMTCLASS) = tapeclass

Also run the following command to verify if an include statement in used in the dsm.sys used by the Tivoli Storage Manager server database backup :

cat /opt/tivoli/tsm/client/api/bin64/dsm.sys

For example, the command may return :

inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl.lst

Resolving The Problem

  • If an include statement is used in the dsm.sys file, edit the /opt/tivoli/tsm/client/api/bin64/dsm.sys file and remove the include or inclexcl statement.
  • If a management class is specified in the database configuration, logon as the instance owner and remove the management class with the following command :
    db2 update db cfg for database using TSM_MGMTCLASS NULL
    Stop and restart the Tivoli Storage Manager Server. This will trigger a db2stop /db2start which will commit the change.
  • Re-run the backup db command.

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

Document Information

Modified date:
17 June 2018

UID

swg21570523

Page Feedback