IBM Support

BACKUP DB failures with error ANR2968E sqlcode -2033 sqlerrmc 168



V6 Tivoli Storage Manager BACKUP DB failures with error ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 168.


The following error is encountered after initiating a BACKUP DB process:

11/09/2010 10:00:43 ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 168. (SESSION: 1647, PROCESS: 124)


The sqlerrmc 168 return code means the following:


The cause is that access to the Tivoli Storage Manager API password file was denied (TSM.PWD). With out this password file, the API cannot connect to the Server to complete the BACKUP DB.

The TSM.PWD file should be located in the directory referenced by the API's "passworddir" option in the dsm.sys file located here(by default):


Access could be denied because of a permission's issue, or because the API's TSM.PWD does not exist.


V6 Tivoli Storage Manager Servers

Resolving The Problem

If the TSM.PWD file exists at the location specified by the "passworddir", resolve any permission's issues that may exist. This file should have the following permission's, owner, and group settings(for example):

-rw------- 1 root root 151 Sep 21 16:22 TSM.PWD

If the TSM.PWD file does not exist, or cannot be found, regenerate it by setting the API password. More information for completing this can be located at the following link:

V6.3 (Step 6):

[{"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":"6.3","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM ADSM ITSM Spectrum Protect

Document Information

Modified date:
17 June 2018