If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 Backup with TSM failing with SQL2062N and Reason Code 610

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-17-04, 16:11
mrichards mrichards is offline
Registered User
 
Join Date: Dec 2004
Posts: 4
DB2 Backup with TSM failing with SQL2062N and Reason Code 610

Has anyone had problems backing up UDB 7.2 FP6 on Win2k with TSM 5.2?
After configuring and compiling userexit, when I try to run a 'db2 backup db dbname use TSM', I receive:

D:\Program Files\Tivoli\TSM\baclient>db2 backup db HR use TSM
SQL2062N An error occurred while accessing media
"D:\SQLLIB\bin\db2tadsm.dll". Reason code: "610".

The db2diag.log shows:
2004-12-17-13.43.37.799000 InstanceB2 Node:000
PID:7056(db2syscs.exe) TID:7128 Appid:*LOCAL.DB2.041216230509
database_utilities sqlubcka Probe:0 Database:HR

Starting a full database backup.

2004-12-17-13.43.41.080000 InstanceB2 Node:000
PID:7056(db2syscs.exe) TID:10264 Appid:none
database_utilities sqluMapVend2MediaRCWithLog Probe:1

Error in Vendor Support Code at line: 332. rc: 610

2004-12-17-13.43.41.174000 InstanceB2 Node:000
PID:7056(db2syscs.exe) TID:10264 Appid:none
database_utilities sqluMCInitBackupMC Probe:85

Media controller -- vendor device initialization error

2004-12-17-13.43.41.252000 InstanceB2 Node:000
PID:7056(db2syscs.exe) TID:7128 Appid:*LOCAL.DB2.041216230509
database_utilities sqlubMWResponse Probe:5 Database:HR

DiagData
f2f7 ffff 443a 5c53 514c 4c49 425c 6269 ò÷ÿÿD:\SQLLIB\bi
6e5c 6462 3274 6164 736d 2e64 6c6c ff36 n\db2tadsm.dllÿ6
3130 00 10.


2004-12-17-13.43.41.393000 InstanceB2 Node:000
PID:7056(db2syscs.exe) TID:7128 Appid:*LOCAL.DB2.041216230509
database_utilities sqlubMWResponse Probe:10 Database:HR

DiagData
f2f7 ffff ò÷ÿÿ


2004-12-17-13.43.41.674000 InstanceB2 Node:000
PID:7056(db2syscs.exe) TID:7128 Appid:*LOCAL.DB2.041216230509
database_utilities sqlubcka Probe:0 Database:HR

Backup terminated.
Reply With Quote
  #2 (permalink)  
Old 12-17-04, 17:09
dbamota dbamota is offline
Registered User
 
Join Date: Sep 2003
Posts: 237
RC 610 means
0610 E DSM_RC_NLS_CANT_OPEN_TXT Explanation: The system is unable to open the message txt file (dscenu.txt or dsmclientV3.cat for AIX). On the AS/400 platform this file is QANSAPI/QAANSENU(TXT). System Action: The system returns to the calling procedure. User Response: Verify that the dscenu.txt file is in the directory pointed to by DSMI_DIR. For AIX, verify that the dsmclientV3.cat file has a symbolic link to /usr/lib/nls/msg/<locale>/dsmclientV3.cat
__________________
mota
Reply With Quote
  #3 (permalink)  
Old 12-17-04, 17:59
mrichards mrichards is offline
Registered User
 
Join Date: Dec 2004
Posts: 4
OK. That worked to get me to this next step.

D:\Program Files\Tivoli\TSM\baclient>db2 backup db HR use TSM
SQL2062N An error occurred while accessing media
"D:\SQLLIB\bin\db2tadsm.dll". Reason code: "185".

When I try to rerun the command after getting the above message, I get
D:\Program Files\Tivoli\TSM\baclient>db2 backup db HR use TSM
SQL2062N An error occurred while accessing media
"D:\SQLLIB\bin\db2tadsm.dll". Reason code: "2041".

I'll get this message until I issue a db2stop & db2start. Any ideas? My dsm.opt is listed here:

PASSWORDACCESS GENERATE
TCPSERVERADDRESS tsm.cln.ralston.com
SCHEDLOGRetention 7 D
ERRORLOGRetention 7 D
SCHEDMODE PROMPTED
TCPBUFFSIZE 62
TCPWINDOWSIZE 63
EXCLUDE *:*
INCLUDE E:\DB2\...\* DBTEST

*domain -SYSTEMOBJECT
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On