IBM Support

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

Troubleshooting


Problem

A Tivoli Storage Manager server database backup process is launched and fails with the ANN2968E error. Because the database backup fails to run, the recovery log fills up and crashes the server.

Symptom

The db2diag log file may also show the following error :

<timestamp> xxxxxxxxxxxxxx LEVEL: Error
PID : nnn TID : 1 PROC : db2fm
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, Fault Monitor Facility, fmIsDB2AUTOSTARTOn, probe:40
MESSAGE : ECF=0x900003AC=-1879047252=ECF_FM_POPEN_FAILED
Function popen failed
CALLSTCK:
[0] 0x090000000347A0D8 pdOSSeLoggingCallback + 0x34
[1] 0x0900000002B0FBA4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x0900000002B0F948 ossLog + 0x88
[3] 0x090000000054E560 fmIsAUTOSTARTOn__FPcPb + 0x4A0
[4] 0x0900000000552634 gcf_getstate + 0x2B4
[5] 0x0900000000DB0CEC getState__9GcfCallerFP12GCF_PartInfoUlP11GCF_RetInfo + 0x1CC
[6] 0x0000000100003990 main + 0x2430
[7] 0x0000000100000290 __start + 0x98
[8] 0x0000000000000000 ?unknown + 0x0
[9] 0x0000000000000000 ?unknown + 0x0

Cause

Insufficient AIX system resource

Diagnosing The Problem

The database backup fails with sqlerrmc: 292 which indicates a Tivoli Storage Manager API return code of 292. This return code is defined as follows :
#define DSM_RC_TCA_FORK_FAILED 292 /* Error forking off TCA process */
This indicates that the API was unable to fork a process to do its database backup.

Resolving The Problem

The error indicates that the AIX "Maximum number of PROCESSES allowed per user" (maxuproc) value is too low. It is necessary to increase this value to solve this issue. In this particular case, the maxuproc value was set to 128 and was increased to 4096 using the following commands.

Use the following command to verify the current value :
lsattr –l sys0 –E | grep maxuproc

Use the following command to change the value to 4096
chdev –l sys0 –a maxuproc=’4096’

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

Document Information

Modified date:
17 June 2018

UID

swg21585705