1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

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:
    72
    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,608
    Likes Received:
    370
    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:
    72
    Likes Received:
    1
    Thank you Sir! That worked.

    Much appreciated!

    -b
     

Share This Page