IBM Support

DB2 backup operation may fail with ANR2968E error and sqlcode -2033.

Troubleshooting


Problem

"backup database use tsm" command process may fail with ANR2968E Database backup terminated, DB2 sqlcode: -2033, DB2 sqlerrmc: 610.

Cause

The proper locale file may not be linked in the correct location if Tivoli Storage Manager Client was recently upgraded.

Diagnosing The Problem

Checking the list of files in the 64-bit API directory will reveal that the local directory containing the message codes is missing:

tsm:/opt/tivoli/tsm/client/api/bin64 # ls -ltra
total 5824
-rw-r--r-- 1 root root 0 Dec 3 13:37 dsmerror.log
-rw-rw-r-- 1 root root 486 Jan 27 22:51 dsm.sys
-r-xr-xr-x 1 root bin 3259048 Mar 2 09:58 libApiTSM64.so
-rwsr-xr-x 1 root bin 2670186 Mar 2 09:58 dsmtca
drwxr-xr-x 4 root bin 4096 Mar 22 10:50 ..
drwxr-xr-x 2 root bin 4096 Mar 22 10:50 sample
drwxr-xr-x 3 root bin 4096 Mar 24 11:31 .

Resolving The Problem

Please link the appropriate locale directory to a location inside your /opt/tivoli/tsm/client/api/bin64 location. For example:

tsm:/opt/tivoli/tsm/client/api/bin64 # pwd
/opt/tivoli/tsm/client/api/bin64
tsm:/opt/tivoli/tsm/client/api/bin64 #

ln -s /opt/tivoli/tsm/client/lang/en_US/ /opt/tivoli/tsm/client/api/bin64
ln -s /opt/tivoli/tsm/client/lang/ja_JP/ /opt/tivoli/tsm/client/api/bin64


After doing this you can check the link was created properly:

tsm:/opt/tivoli/tsm/client/api/bin64 # ls -ltra
total 5824
-rw-r--r-- 1 root root 0 Dec 3 13:37 dsmerror.log
-rw-rw-r-- 1 root root 486 Jan 27 22:51 dsm.sys
lrwxrwxrwx 1 root root 17 Mar 24 14:46 en_US -> ../../lang/en_US/
lrwxrwxrwx 1 root root 17 Mar 24 14:46 ja_JP -> ../../lang/ja_JP/
-r-xr-xr-x 1 root bin 3259048 Mar 2 09:58 libApiTSM64.so
-rwsr-xr-x 1 root bin 2670186 Mar 2 09:58 dsmtca
drwxr-xr-x 4 root bin 4096 Mar 22 10:50 ..
drwxr-xr-x 2 root bin 4096 Mar 22 10:50 sample
drwxr-xr-x 3 root bin 4096 Mar 24 14:46 .


After this is done, the database backups should no longer fail with an sqlerrmc of 610.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Client","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

swg21608072

Page Feedback