Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Posts
    4

    Unanswered: 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.dll6
    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.

  2. #2
    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

  3. #3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •