DUE TO RUNNING DB2SET FROM PRE-FIXPAK 6 AGAINST FIXPACK 6 OR HIGHER
从归档日志抽取到审计日志的时候
执行：db2audit extract file /home/db2inst1/audit/db2inst1/DXYTEST/NODE0000/LOGSTREAM0000/aud1.aud from files /home/db2inst1/audit/db2inst1/DXYTEST/NODE0000/LOGSTREAM0000/C0000000/S0000000.LOG
报错AUD0022N The Audit Log File is corrupted.
AUD0001N Operation failed.
查了一下：
AUD0022N THE AUDIT LOG FILE IS CORRUPTED" DUE TO RUNNING DB2SET FROM PRE-FIXPAK 6 AGAINST FIXPACK 6 OR HIGHER (OR VICE VERSA)
没看懂，求解释
执行：db2audit extract file /home/db2inst1/audit/db2inst1/DXYTEST/NODE0000/LOGSTREAM0000/aud1.aud from files /home/db2inst1/audit/db2inst1/DXYTEST/NODE0000/LOGSTREAM0000/C0000000/S0000000.LOG
报错AUD0022N The Audit Log File is corrupted.
AUD0001N Operation failed.
查了一下：
AUD0022N THE AUDIT LOG FILE IS CORRUPTED" DUE TO RUNNING DB2SET FROM PRE-FIXPAK 6 AGAINST FIXPACK 6 OR HIGHER (OR VICE VERSA)
没看懂，求解释
3 同行回答
回复 1# d414491305
那个db2audit extract后面的from跟的是你之前通过db2audit archive database dbname to path （db level audit log）或者db2audit archive to path（instance level audit log） 生成的db2audit的log文件
默认是在sqllib/security/auditdata（windows的有点不同）目录下面的
文件命名格式就是这样
db2audit.instance.log.node_number[.YYYYMMDDHHMMSS] for the instance log
db2audit.db.dbname.log.node_number[.YYYYMMDDHHMMSS] for the database log
，并不是跟db2 archive log文件，db2audit根本读不懂db2 archive log当然就给你报错啦。
具体用法请看下面的链接
http://www-01.ibm.com/support/kn ... _9.7.0%2F3-6-2-6-13 收起
那个db2audit extract后面的from跟的是你之前通过db2audit archive database dbname to path （db level audit log）或者db2audit archive to path（instance level audit log） 生成的db2audit的log文件
默认是在sqllib/security/auditdata（windows的有点不同）目录下面的
文件命名格式就是这样
db2audit.instance.log.node_number[.YYYYMMDDHHMMSS] for the instance log
db2audit.db.dbname.log.node_number[.YYYYMMDDHHMMSS] for the database log
，并不是跟db2 archive log文件，db2audit根本读不懂db2 archive log当然就给你报错啦。
具体用法请看下面的链接
http://www-01.ibm.com/support/kn ... _9.7.0%2F3-6-2-6-13 收起