DB2備份常見錯誤代碼及含義

1、DB2 常見錯誤代碼DB2 的錯誤信息分為 4 類:1: DB2 錯誤信息：- SQLN例如：SQL2062N該類錯誤信息可以通過DB2 命令查看詳細描述$db2 ? 2: Error Code:-XXX可以參考附件 DB2_Code.PDF 查找.該類錯誤信息一般會和Error Code 一同出現(xiàn).可在附件 DB2_Code.PDF查找錯誤描述4: Reas on Code.Reas on code: xxxx.出現(xiàn)該類通常是第三方 API 或操作系統(tǒng)返回的錯誤信息.可從系統(tǒng)層面查找原因例如：在 AIX 可以在如下文件找到該錯誤的描述/usr/i nclude/sys/ errno.h例如常

2、見 Reason Code#endif /* _ALL_SOURCE */#defi ne EPERM1/* Operatio n not permitted*/#defi ne ENOENT2/* No such file or directory*/#defi ne ESRCH3/* No such process*/#defi ne EINTR4/* i nterrupted system call*/#defi ne EIO5/* I/O error*/#defi ne ENXIO6/* No such device or address*/#defi ne E2BIG7/* Arg

3、list too long*/#defi ne ENOEXEC 8/* Exec format error*/#defi ne EBADF9/* Bad file descriptor*/#defi ne ECHILD10/* No child processes*/#defi ne EAGAIN11/* Resource temporarily un available*/#defi ne ENOMEM12/* Not eno ugh space*/#defi ne EACCES13/* Permissi on denied*/#defi ne EFAULT14/* Bad address*

4、/#defi ne ENOTBLK 15/* Block device required*/#defi ne EBUSY16/* Resource busy*/#defi ne EEXIST17/* File exists*/3: SQL STATE Code:SQLSTATE: XXXXXReas on Code= “1 ” 從/usr/include/sys/ errno.h#define EPERM1/* Operation not permitted（操作不被允許）原因分析：此時 1 代表某些操作不被允許.,配合 SQL2426N 可以知道是因為沒有更新 TRACKMOD 參數(shù)為 ON

5、.所以增量備份不備允許.2:SQL2062N An error occurred while access ing media/opt/simpa na/Base64/libDb2Sbt.so.Reason code: 11.Reason Code= 11從 /usr/include/sys/ errno.h 查找 Reason Code= 11” 的描述#define EAGAIN 11/* Resource temporarily unavailable （無法分配資源）原因分析:3:SQL2062N An error occurred while accessingmedia VENDO

6、R. Reason code:18.Rea son Code=18”從/usr/include/sys/ errno.h18/* Improper link（可能錯誤的參數(shù)或出口指向）原因分析：#defi ne EXDEV18#defi ne ENODEV19#defi ne ENOTDIR 20/*Improper link/* No*/*/*/查找 Reason Code= 1”的描述1: CommCell里面的 DB2 子客戶端沒有關(guān)聯(lián)相應的存儲策略。2: MA 加載介質(zhì)異常（MA 服務不正常，帶庫狀態(tài)異常）3:帶庫介質(zhì)資源不足或磁庫空間不足查找 Reason Code=18 ”的描述#

7、defi ne EXDEV*SQL2426N The database has not bee n con figured to allow the in creme ntalbackupoperati on. Reas on code =1.I guess this db did not update the db configuration which cv request. Should be done:#db2 update db cfg for us ing LOGARCHOPT1 CvClie ntName=,Cvl nsta nceName=l nsta nce001#db2 update db cfg for usi ng VENDOROPT CvClie ntName=,Cvl nsta nceName=l nsta nce001#db2 update db cfg for us ing LOGARCHMETH1VENDOR:/opt/simpa na/Base64/libDb2Sbt.soSQL2071NAn error occurred while access ing the shared libra