DB2备份常见错误代码及含义

1、DB2 常见错误代码DB2 的错误信息分为 4 类:1: DB2 错误信息：- SQLN例如：SQL2062N该类错误信息可以通过DB2 命令查看详细描述$db2 ? 2: Error Code:-XXX可以参考附件 DB2_Code.PDF 查找.该类错误信息一般会和Error Code 一同出现.可在附件 DB2_Code.PDF查找错误描述4: Reas on Code.Reas on code: xxxx.出现该类通常是第三方 API 或操作系统返回的错误信息.可从系统层面查找原因例如：在 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 参数为 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（可能错误的参数或出口指向）原因分析：#defi ne EXDEV18#defi ne ENODEV19#defi ne ENOTDIR 20/*Improper link/* No*/*/*/查找 Reason Code= 1”的描述1: CommCell里面的 DB2 子客户端没有关联相应的存储策略。2: MA 加载介质异常（MA 服务不正常，带库状态异常）3:带库介质资源不足或磁库空间不足查找 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