IBM Support

ANR2969E Database restore terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 10.

Troubleshooting


Problem

Tivoli Storage Manager server database restore fails with the following message after the volume is mounted for restore : []ANR2969E Database restore terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 10.[]

Symptom

Following errors will be seen in the foreground during a restore DB command :

ANR2969E Database restore terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 10.
ANR2032E RESTORE DB: Command failed - internal server error detected.
ANR9999D Thread<1> issued message 2032 from:
ANR9999D Thread<1> 0x00000000d16fe6 outMsgf
ANR9999D Thread<1> 0x000000004d9c16 AdmRestoreDb
ANR9999D Thread<1> 0x00000000488156 admRestoreDatabase
ANR9999D Thread<1> 0x000000004769c8 main
ANR9999D Thread<1> 0x000037b0a1ed1d *UNKNOWN*
ANR9999D Thread<1> 0x00000000474de9 *UNKNOWN*

Cause

Permission issue

Diagnosing The Problem

Examine the db2diag.log file for errors during the restore attempt. Look for messages similar to the following :


2014-06-09-17.44.43.997679-360 I140814E377 LEVEL: Error
PID : 23806 TID : 140074175948544PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000
EDUID : 558 EDUNAME: db2med.290.0 (TSMDB1) 0
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog,
probe:695
MESSAGE : Error in vendor support code at line: 377 rc: 106

In this message, it shows a TSM API return code 106 is received. The return code translates to the
following :
DSM_RC_ACCESS_DENIED 106 /* denied due to improper permission

Resolving The Problem

In this case, the return code 106 was received because the ERRORLOGNAME option was a using a file name and the Tivoli Storage Manager server instance did not have permissions to it.

Verify the filename specified with the ERRORLOGNAME option (dsm.opt for Windows and dsm.sys for UNIX) and make sure that it has proper permissions for the Tivoli Storage Manager server instance userid.

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

Document Information

Modified date:
17 June 2018

UID

swg21675953

Page Feedback