TSM 6.1.2 DB Bakup Fails with ANR2968E Database backup terminated. DB2 sqlcode: -2033

[sunnychoudary]

Hi,

I am newbie with TSM and had recently installed TSM 6.1.2 in our environment. Everything is working except, by tsm database backups fails with following error message

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

The command I use to backup db is

BACKUP DB devclass=tsmdbbkpdisk type=full scratch=yes

Devclass tsmdbbkpdisk is defined and as set dbrecovery as well.

Device Device Storage Device Format Est/Max Mount
Class Access Pool Type Capacity Limit
Name Strategy Count (MB)
--------- ---------- ------- --------- ------ -------- ------
TSMDBBKP- Sequential 1 FILE DRIVE 2,048.0 32
DISK

Detailed process is listed below:-

ANR2017I Administrator ADMIN issued command: BACKUP DB devclass=tsmdbbkpdisk type=full scratch=yes
ANR4559I Backup DB is in progress.
ANR0984I Process 2 for DATABASE BACKUP started in the BACKGROUND at 15:09:48.
ANR2280I Full database backup started as process 2.
ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 610.
ANR0985I Process 2 for DATABASE BACKUP running in the BACKGROUND completed with completion state FAILURE at 15:09:52.


I have also followed the instructions mentioned in this article http://www-01.ibm.com/support/docview.wss?uid=swg21390301. But still I cannot overcome this issue. Any help will be much appreciated.

Thanks in advance

 

[slonk]

I have also followed the instructions mentioned in this article http://www-01.ibm.com/support/docview.wss?uid=swg21390301. But still I cannot overcome this issue.

I had the same issue. In my case the last article line:

* C:\Progra~1\Tivoli\TSM\server\dsmsutil UPDATEPW /NODE:$$_TSMDBMGR_$$ /PASSWORD:TSMDBMGR /VALIDATE:NO

did not seem to work. Instead I used the line form the 6.1 Installation Guide (see "Preparing the database manager for backup"):

* "c:\program files\tivoli\tsm\server\dsmsutil.exe" UPDATEPW /NODE:$$_TSMDBMGR_$$ /PASSWORD:TSMDBMGR /VALIDATE:NO /OPTFILE:"d:\tsmserver1\tsmdbmgr.opt"

After this all was fine.

 

[sunnychoudary]

Hi Slonk,

Thanks for your reply mate.

Even after doing what you suggested and following up Installation Guide, I am still not able to backup the database through TSM.

I did further digging and was able to capture the db2diag information, looking at it is is complaining about a specific dll file, I am not sure how to proceed further. Does it make any sense to you?

FYI my tsm is updated to fix pack 6.1.2


C:\Program Files\Tivoli\TSM\db2\BIN>db2set -i server1 -all
[e] DB2PATH=C:\Program Files\Tivoli\TSM\db2
DB2_SKIPINSERTED=ON
DB2_KEEPTABLELOCK=ON
DB2_EVALUNCOMMITTED=ON
DB2_VENDOR_INI=C:\Progra~1\Tivoli\TSM\server1\tsmdbmgr.env
DB2_SKIPDELETED=ON
DB2INSTPROF=C:\ProgramData\IBM\DB2\DB2TSM1
DB2COMM=TCPIP
DB2_PARALLEL_IO=*
[g] DB2_EXTSECURITY=YES
[g] DB2SYSTEM=MG-01
[g] DB2PATH=C:\Program Files\Tivoli\TSM\db2
[g] DB2INSTDEF=DB2TSM
[g] DB2ADMINSERVER=DB2DAS00

C:\Program Files\Tivoli\TSM\db2\BIN>db2set -l
SERVER1
DB2TSM


db2diag
------------



2009-09-18-13.34.51.308000+600 E2927658H458 LEVEL: Info
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1508
MESSAGE : Starting an online db backup.

2009-09-18-13.34.51.447000+600 E2928118H411 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluvint, probe:374
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0x00000262=610 -- see TSM API Reference for meaning.

2009-09-18-13.34.51.449000+600 I2928531H734 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:646
DATA #1 : String, 141 bytes
Vendor error: rc = 11 returned from function sqluvint.
Return_code structure from vendor library C:\PROGRA~1\Tivoli\TSM\db2\bin\db2tsm.dll:

DATA #2 : Hexdump, 40 bytes
0x73F72E20 : 6202 0000 3337 3420 3631 3000 0000 0000 b...374 610.....
0x73F72E30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x73F72E40 : 0000 0000 0000 0000 ........

2009-09-18-13.34.51.451000+600 I2929267H382 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:686
MESSAGE : Error in vendor support code at line: 374 rc: 610

2009-09-18-13.34.51.453000+600 E2929651H358 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:677
MESSAGE : Media controller -- Generic error

2009-09-18-13.34.51.455000+600 E2930011H451 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:677
MESSAGE : SQL2033N An error occurred while accessing TSM during the processing
of a database utility. TSM reason code: "".

2009-09-18-13.34.51.457000+600 E2930464H345 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:677
DATA #1 : String, 3 bytes
610

2009-09-18-13.34.51.460000+600 E2930811H565 LEVEL: Severe
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubHandleTSMError, probe:1144
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2033
DATA #2 : Hexdump, 8 bytes
0x71EA4E70 : 0FF8 FFFF 3631 3000 ....610.

2009-09-18-13.34.51.462000+600 E2931378H988 LEVEL: Severe
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubHandleTSMError, probe:1144
MESSAGE : SQL2033N An error occurred while accessing TSM during the processing
of a database utility. TSM reason code: "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2033 sqlerrml: 3
sqlerrmc: 610
sqlerrp : sqlubHan
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2009-09-18-13.34.51.942000+600 E2932368H515 LEVEL: Error
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluvdel, probe:1742
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0x00000262=610 -- see TSM API Reference for meaning.

2009-09-18-13.34.51.945000+600 I2932885H927 LEVEL: Error
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubDeleteVendorImage, probe:558
MESSAGE : SQL2062N An error occurred while accessing media "". Reason code:
"".
DATA #1 : String, 27 bytes
Error returned by sqluvdel.
DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
Vendor RC=0x0000001A=26 -- see DB2 API Guide for meaning.
DATA #3 : Hexdump, 40 bytes
0x73F72F40 : 6202 0000 3137 3432 2036 3130 0000 0000 b...1742 610....
0x73F72F50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x73F72F60 : 0000 0000 0000 0000 ........

2009-09-18-13.34.51.947000+600 E2933814H611 LEVEL: Error
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubCleanupPartialBackup, probe:708
MESSAGE : SQL2062N An error occurred while accessing media "". Reason code:
"".
DATA #1 : String, 63 bytes
Could not delete partial backup image created on vendor device.

2009-09-18-13.34.52.091000+600 E2934427H437 LEVEL: Severe
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:848
MESSAGE : Backup terminated.

 

[Manufest]

I had the same error because I initialized the server (on Windows) with the mmc console. After pulling my hair out for a while, I figured out that it is now recommended to use dsmicfgx.exe to initialize the server (c:\program files\tivoli\tsm\server\dsmicfgx.exe on a default install).

I really couldn't find any documentation on deleting an instance, so I just uninstalled and reinstalled, and then initialized using dsmicfgx.exe.

 

[sunnychoudary]

Yes I also used the Windows MMC to configure the TSM Instance. But now that I had my backups running for past one week, I don't want to uninstall the old instance. ... well the installation instructions never mentioned that using MMC was not recommended.. damm...

Hope there is a way to fix this...

 

[Manufest]

I found this slide show which shows that the MMC console is no longer recommended.


Try this article.

 

[sunnychoudary]

I have already tried what is mentioned in http://www-01.ibm.com/support/docview.wss?uid=swg21390301, but still its not working.

Yes in the slide, it only has 3 ways (admin center, dsmicfgx or manually). But in the installation instructions for 6.1, they stated all 4 and I choose the very first option which was MMC...

I am able to manually backup the database..using db2 control center..

 

[Manufest]

Are any of your DB2 services running as a user?

 

[sunnychoudary]

Yes Manufest, Please have a look at the attachment.

 

[Manufest]

hmmm not really sure. Do you have an active agreement with IBM? I'd suggest giving their support a shout.

 

[sunnychoudary]

Hi Manufest,

The issue is resolved now. The Environment variable DSMI_DIR was pointing to wrong location. After configuring DSMI_DIR=C:\Program Files\Tivoli\TSM\cosole the backups started working again.

Thank you for your help mate..

Cheers...

 

[kajio11]

Problem Resolved

Many Thanx for you guys for these tips, :up:

Actually the procedures in this link solved my problem...

http://www-01.ibm.com/support/docview.wss?uid=swg21390301