1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Can't backup DB

Discussion in 'TSM Server' started by BDMcGrew, Aug 28, 2017.

  1. BDMcGrew

    BDMcGrew ADSM.ORG Member

    Joined:
    Mar 9, 2015
    Messages:
    71
    Likes Received:
    1
    So I've got dozens of 6.3.3.0 servers running in Win2K8 that are all fine save for 2 servers that's won't do a DB backup. I'm getting the below errors. I'm at a loss. I've googled the errors and sql codes and tried all the fixes I can find (which worked on another server having the problem) but these two servers I'm unable to resolve.

    Anyone have any ideas? I'll take all the help I can get :)

    Appreciate it!

    -brian

    tsm: LPDTSM001>backup db type=full dev=lpd0013_P_Y wait=yes
    ANR0984I Process 2 for Database Backup started in the FOREGROUND at 15:50:51.
    ANR4559I Backup DB is in progress.
    ANR2280I Full database backup started as process 2.
    ANR4626I Database backup will use 1 streams for processing with the number
    originally requested 1.
    ANR2983E Database backup terminated due to environment or setup issue related
    to DSMI_DIR - DB2 sqlcode -2033 sqlerrmc 168 .
    ANR0985I Process 2 for Database Backup running in the FOREGROUND completed with
    completion state FAILURE at 15:51:01.
    ANR1893E Process 2 for Database Backup completed with a completion state of
    FAILURE.
    ANS8001I Return code 4.

    tsm: LPDTSM001>

    tsm: LPDTSM001>q devc

    Device Device Storage Device Format Est/Max Mount
    Class Access Pool Type Capacity Limit
    Name Strategy Count (MB)
    --------- ---------- ------- --------- ------ -------- ------
    DISK Random 0
    LPD0013_- Sequential 1 FILE DRIVE 61,440.0 50
    DT_N
    LPD0013_- Sequential 1 FILE DRIVE 30,720.0 50
    DT_Y
    LPD0013_- Sequential 1 FILE DRIVE 61,440.0 50
    P_N
    LPD0013_- Sequential 1 FILE DRIVE 30,720.0 50
    P_Y
    WHSTSM021 Sequential 0 SERVER 500.0 1

    tsm: LPDTSM001>q db f=d

    Database Name: TSMDB1
    Total Size of File System (MB): 1,716,902
    Space Used by Database(MB): 53,856
    Free Space Available (MB): 1,136,469
    Total Pages: 3,903,493
    Usable Pages: 3,903,293
    Used Pages: 3,890,113
    Free Pages: 13,180
    Buffer Pool Hit Ratio: 94.8
    Total Buffer Requests: 1,462,098
    Sort Overflows: 0
    Package Cache Hit Ratio: 95.4
    Last Database Reorganization: 08/24/2017 05:15:04
    Full Device Class Name: LPD0013_P_Y
    Number of Database Backup Streams: 1
    Incrementals Since Last Full: 0
    Last Complete Backup Date/Time: 06/27/2017 07:30:31


    tsm: LPDTSM001>


    D:\tsm\lpdtsm01>more tsmdbmgr.env
    DSMI_CONFIG=d:\tsm\lpdtsm01\tsmdbmgr.opt
    DSMI_LOG=d:\tsm\lpdtsm01

    D:\tsm\lpdtsm01>more tsmdbmgr.opt
    *************************************************
    nodename $$_TSMDBMGR_$$
    commmethod tcpip
    tcpserveraddr localhost
    tcpport 1500
    passwordaccess generate
    errorlogname d:\tsm\lpdtsm01\TSMDBMGR_TSMSERVER1.log

    D:\tsm\lpdtsm01>

    D:\tsm\lpdtsm01>db2set
    DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:500
    DB2_KEEPTABLELOCK=OFF
    DB2_VENDOR_INI=d:\tsm\lpdtsm01\tsmdbmgr.env
    DB2INSTPROF=C:\ProgramData\IBM\DB2\DB2TSM1
    DB2COMM=TCPIP

    D:\tsm\lpdtsm01>
     
  2.  
  3. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,533
    Likes Received:
    354
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    Hi,

    sqlerrmc 168 is actually a TSM API return code: https://www.ibm.com/support/knowled.../com.ibm.itsm.msgs.client.doc/msg-0168_E.html

    Try:
    Code:
    "c:\program files\tivoli\tsm\server\dsmsutil.exe" UPDATEPW /NODE:$$_TSMDBMGR_$$ /PASSWORD:TSMDBMGR /VALIDATE:NO /OPTFILE:"d:\tsm\lpdtsm01\tsmdbmgr.opt"
    source: bottom of this page: https://www.ibm.com/support/knowled...bm.itsm.srv.install.doc/t_srv_prep_dbmgr.html
     
    DanM and BDMcGrew like this.
  4. BDMcGrew

    BDMcGrew ADSM.ORG Member

    Joined:
    Mar 9, 2015
    Messages:
    71
    Likes Received:
    1
    Thank you Sir! That worked.

    Much appreciated!

    -b
     

Share This Page