IBM Support

Hub for Troubleshooting ANR2968E/ANR2993E Server Database Backup Failures

Troubleshooting


Problem

Hub for Troubleshooting ANR2968E/ANR2993E Server Database Backup Failures

Resolving The Problem


Overview:

The IBM Storage Protect server uses several different components to complete BACKUP DB processing of its internal DB2 database (TSMDB1). Although the BACKUP DB process is initiated via the Server process, it uses the IBM Storage Protect client API and the DB2 database API to complete the operation. The approximate flow of the operation is as follows:


If the configuration of any of these components is incorrect, an administrator may experience ANR2968E or ANR2993E errors during BACKUP DB operations, which causes the process to fail. The most typical cause of this error involves configuration of the IBM Storage Protect API. Documentation regarding configuring the server for database backup operations can be found here:

Preparing the database manager for database backup


Understanding the ANR2968E/ANR2993E errors:

The following types of errors may be received during BACKUP DB processing:

ANR2968E Database backup terminated. DB2 sqlcode: sqlcode. DB2 sqlerrmc: sqlerrmc.

ANR2993E The database backup terminated with a log problem. DB2 sqlcode: sqlcode. DB2 sqlerrmc: sqlerrmc.

This errors indicate that DB2 detected a problem during the database backup operation. This commonly indicates a configuration or procedural issue with the Tivoli Storage Manager API or Server component.

The DB2 sqlcode (sqlcode) provided is a return code from the DB2 product. This will most likely always be -2033 or -2428, which indicates the following respectively:

SQL2033N  An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "<reason-code>".

SQL2428N  The BACKUP did not complete because one or more of the requested log files could not be retrieved.

The DB2 sqlerrmc (sqlerrmc) is a return code from the Storage Protect API. This code is generally the most useful for problem determination efforts. A comprehensive list of possible API return codes and their high-level meanings can be found here.

Problem Resolution:

A list of TechNotes that can help with troubleshooting ANR2968E/ANR2993E for the various different return codes can be found below:

ANR2968E:
ANR2968E with SQLERRMC -50:


ANR2968E with SQLERRMC 29:


ANR2968E with SQLERRMC 61:


ANR2968E with SQLERRMC 75:


ANR2968E with SQLERRMC 106:


ANR2968E with SQLERRMC 109:


ANR2968E with SQLERRMC 138:


ANR2968E with SQLERRMC 161:


ANR2968E with SQLERRMC 168:


ANR2968E with SQLERRMC 292:


ANR2968E with SQLERRMC 400:


ANR2968E with SQLERRMC 409:


ANR2968E with SQLERRMC 426:


ANR2968E with SQLERRMC 610:


ANR2968E with SQLERRMC 2025:

ANR2968E with SQLERRMC 362:

      DB Backup Fails with ANR2968E (-362 SQL Error)


ANR2993E:
ANR2993E with SQLCODE 2428:


 Note: Above technote also covers older versions (v6.x and v7.x) of DB backup issues so it's possible same steps may not apply to v8.x. Always, refer the latest version of IBM Product Document.

[{"Type":"MASTER","Line of Business":{"code":"LOB69","label":"Storage TPS"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEGHY","label":"IBM Storage Protect"},"ARM Category":[{"code":"a8m3p000000hAaJAAU","label":"Server-\u003EDatabase Backup"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1.0;8.1.1;8.1.10;8.1.11;8.1.12;8.1.13;8.1.14;8.1.15;8.1.16;8.1.17;8.1.18;8.1.19;8.1.2;8.1.20;8.1.21;8.1.22;8.1.23;8.1.24;8.1.25;8.1.26;8.1.27;8.1.3;8.1.4;8.1.5;8.1.6;8.1.7;8.1.8;8.1.9;8.2.0"}]

Product Synonym

ISP; ITSM; TSM ; ADSM; DB2; IBM SPECTRUM PROTECT; Tivoli Storage Manager; IBM Storage Protect

Document Information

Modified date:
18 November 2025

UID

swg21970809

Page Feedback