ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 106
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,找到官方的解釋是:
上面這段話出自下面連線:
最後我參考官方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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192SQL
- DB2錯誤資訊(按sqlcode排序)DB2SQL排序
- DB2 backup與resotre,rollforwardDB2Forward
- db2 create database 命令DB2Database
- DB2 -668 錯誤,sqlcode=-668 ,SQLSTATE=57016DB2SQL
- db2備份恢復(backup restore)DB2REST
- db2 online backup 設定DB2
- Oracle database, DB2, Postgresql行號OracleDatabaseDB2SQL
- Java訪問SSL enabled DB2 DatabaseJavaDB2Database
- DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001DB2SQLError
- DB2中SQLSTATE=57016,SQLCODE=-668,原因碼“7”的解決DB2SQL
- DB2:ksh: db2: not found.DB2
- DB2 connect to database連線資料包錯DB2Database
- DB2 backup fails with SQL2079N return code 30DB2AISQL
- DB2系列之DB2安裝DB2
- [DB2]DB2備份和恢復DB2
- [DB2]db2重定向恢復DB2
- 轉:DB2聯合資料庫(FEDERATED DATABASE)配置例項DB2資料庫Database
- DB2 WLMDB2
- DB2 explainDB2AI
- DB2 listenerDB2
- db2概念DB2
- DB2 INFOCENTERDB2
- join (db2)DB2
- DB2 CLPDB2
- The DB2 environmentDB2
- DB2 CRASHDB2
- db2 list history backup輸出資訊中各個型別的解釋DB2型別
- db2 -attribute of key are miss in result set . db2 錯誤DB2
- [DB2]linux下安裝db2 v9.7DB2Linux
- db2 資訊中心DB2
- db2 reorg,runstatsDB2
- DB2 安裝DB2
- Db2 備份DB2
- DB2程式模型DB2模型
- DB2監控DB2
- DB2 Q&ADB2
- DB2 刪除DB2