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

warehouse發表於2014-06-13

tsm 自身db備份報錯。
TSM:SERVER1>
backup db devclass=tsm_dbbak type=full
ANR2017I Administrator SERVER_CONSOLE issued command: BACKUP DB devclass=tsm_dbbak type=full
ANR4559I Backup DB is in progress.
ANR0984I Process 2 for DATABASE BACKUP started in the BACKGROUND at 04:45:33 PM.
ANR2280I Full database backup started as process 2.
TSM:SERVER1>
ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 106.
ANR0985I Process 2 for DATABASE BACKUP running in the BACKGROUND completed with completion state
FAILURE at 04:45:34 PM.
ANR0406I Session 1 started for node $$_TSMDBMGR_$$ (Linux x86-64) (Tcp/Ip 127.0.0.1(12908)).
ANR0403I Session 1 ended for node $$_TSMDBMGR_$$ (Linux x86-64).
ANR0406I Session 2 started for node $$_TSMDBMGR_$$ (Linux x86-64) (Tcp/Ip 127.0.0.1(12909)).
ANR0403I Session 2 ended for node $$_TSMDBMGR_$$ (Linux x86-64).
ANR0406I Session 3 started for node $$_TSMDBMGR_$$ (Linux x86-64) (Tcp/Ip 127.0.0.1(12910)).
ANR0403I Session 3 ended for node $$_TSMDBMGR_$$ (Linux x86-64).
ANR0406I Session 4 started for node $$_TSMDBMGR_$$ (Linux x86-64) (Tcp/Ip 127.0.0.1(12911)).
ANR0403I Session 4 ended for node $$_TSMDBMGR_$$ (Linux x86-64).
ANR2992W  The total DB used in DB space is 18,218 megabytes, and the total space available in the DB
space is 18,901 megabytes. The ratio is 0.96.

Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level 1.0

TSM:SERVER1>
--================================
搜尋錯誤ANR2968E,找到官方的解釋是:

  • 106 - Ensure that the DB2 Instance DSMI_DIR environment variable is pointing to the location of the Tivoli Storage Manger API executables and the dsm.sys configuration file. If the DSMI_DIR setting is wrong, correct it for the DB2 instance, and then restart the DB2 instance.
    上面這段話出自下面連線:

  • 最後我參考官方doc為tsm db backup做了重新配置(Preparing the database manager for backup),doc連線如下:

    --================================
    主要是我原來的tsminst1的.bash_profile裡面缺少下面內容:

    if [ -f /home/tsminst1/sqllib/db2profile ]; then
          .  /home/tsminst1/sqllib/db2profile
      fi
    export DSMI_CONFIG=/home/tsminst1/tsminst1/tsmdbmgr.opt 
    export DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
    export DSMI_LOG=/home/tsminst1/tsminst1 

    --=========================
    總之重新Preparing the database manager for backup之後再次備份ok了,資訊提示如下:

    backup db devclass=tsm_dbbak type=full
    ANR2017I Administrator SERVER_CONSOLE issued command: BACKUP DB devclass=tsm_dbbak type=full
    ANR4559I Backup DB is in progress.
    ANR0984I Process 3 for DATABASE BACKUP started in the BACKGROUND at 04:56:47 PM.
    ANR2280I Full database backup started as process 3.
    TSM:SERVER1>
    ANR0406I Session 5 started for node $$_TSMDBMGR_$$ (DB2/LINUXX8664) (Tcp/Ip 127.0.0.1(12912)).
    ANR8493I FILE volume /tsmdbbak/02649809.DBV mounted in drive FILELIB1 (FILE) in library FILELIB.
    ANR8340I FILE volume /tsmdbbak/02649809.DBV mounted.
    ANR0511I Session 5 opened output volume /tsmdbbak/02649809.DBV.
    ANR1360I Output volume /tsmdbbak/02649809.DBV opened (sequence number 1).
    ANR8341I End-of-volume reached for FILE volume /tsmdbbak/02649809.DBV.
    ANR1362I Output volume /tsmdbbak/02649809.DBV closed (full).
    ANR0514I Session 5 closed volume /tsmdbbak/02649809.DBV.
    ANR8468I FILE volume /tsmdbbak/02649809.DBV dismounted from drive FILELIB1 (FILE) in library
    FILELIB.
    ANR8493I FILE volume /tsmdbbak/02649814.DBV mounted in drive FILELIB10 (FILE) in library FILELIB.
    ANR8340I FILE volume /tsmdbbak/02649814.DBV mounted.
    ANR0511I Session 5 opened output volume /tsmdbbak/02649814.DBV.
    ANR1360I Output volume /tsmdbbak/02649814.DBV opened (sequence number 2).
    ANR8341I End-of-volume reached for FILE volume /tsmdbbak/02649814.DBV.
    ANR1362I Output volume /tsmdbbak/02649814.DBV closed (full).
    ANR0514I Session 5 closed volume /tsmdbbak/02649814.DBV.
    ANR8468I FILE volume /tsmdbbak/02649814.DBV dismounted from drive FILELIB10 (FILE) in library
    FILELIB.
    ANR8493I FILE volume /tsmdbbak/02649821.DBV mounted in drive FILELIB11 (FILE) in library FILELIB.
    ANR8340I FILE volume /tsmdbbak/02649821.DBV mounted.
    ANR0511I Session 5 opened output volume /tsmdbbak/02649821.DBV.
    ANR1360I Output volume /tsmdbbak/02649821.DBV opened (sequence number 3).
    ANR8341I End-of-volume reached for FILE volume /tsmdbbak/02649821.DBV.
    ANR1362I Output volume /tsmdbbak/02649821.DBV closed (full).
    ANR0514I Session 5 closed volume /tsmdbbak/02649821.DBV.
    ANR8468I FILE volume /tsmdbbak/02649821.DBV dismounted from drive FILELIB11 (FILE) in library
    FILELIB.
    ANR8493I FILE volume /tsmdbbak/02649828.DBV mounted in drive FILELIB12 (FILE) in library FILELIB.
    ANR8340I FILE volume /tsmdbbak/02649828.DBV mounted.
    ANR0511I Session 5 opened output volume /tsmdbbak/02649828.DBV.
    ANR1360I Output volume /tsmdbbak/02649828.DBV opened (sequence number 4).
    ANR1361I Output volume /tsmdbbak/02649828.DBV closed.
    ANR0514I Session 5 closed volume /tsmdbbak/02649828.DBV.
    ANR8468I FILE volume /tsmdbbak/02649828.DBV dismounted from drive FILELIB12 (FILE) in library
    FILELIB.
    ANR0403I Session 5 ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664).
    ANR0406I Session 6 started for node $$_TSMDBMGR_$$ (DB2/LINUXX8664) (Tcp/Ip 127.0.0.1(12913)).
    ANR8493I FILE volume /tsmdbbak/02649834.DBV mounted in drive FILELIB2 (FILE) in library FILELIB.
    ANR8340I FILE volume /tsmdbbak/02649834.DBV mounted.
    ANR0511I Session 6 opened output volume /tsmdbbak/02649834.DBV.
    ANR1360I Output volume /tsmdbbak/02649834.DBV opened (sequence number 1).
    ANR1361I Output volume /tsmdbbak/02649834.DBV closed.
    ANR0514I Session 6 closed volume /tsmdbbak/02649834.DBV.
    ANR8468I FILE volume /tsmdbbak/02649834.DBV dismounted from drive FILELIB2 (FILE) in library
    FILELIB.
    ANR0403I Session 6 ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664).
    ANR4550I Full database backup (process 3) completed.
    ANR0985I Process 3 for DATABASE BACKUP running in the BACKGROUND completed with completion state
    SUCCESS at 04:57:17 PM.

    Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level 1.0

    TSM:SERVER1>

    來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/19602/viewspace-1182447/,如需轉載,請註明出處,否則將追究法律責任。

    相關文章