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

最新推荐文章于 2022-11-17 17:36:24 发布

clt3617

最新推荐文章于 2022-11-17 17:36:24 发布

阅读量330

点赞数

文章标签：数据库网络

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.
上面这段话出自下面连接：
http://publib.boulder.ibm.com/infocenter/tsminfo/v6/index.jsp?topic=%2Fcom.ibm.itsm.messages.doc%2Fmsgs7414.html

最后我参考官方doc为tsm db backup做了重新配置（Preparing the database manager for backup），doc连接如下：
http://www-01.ibm.com/support/knowledgecenter/?lang=en#!/SSGSG7_6.3.4/com.ibm.itsm.srv.install.doc/t_srv_prep_dbmgr.html
--================================
主要是我原来的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.