Symptom

The AUDIT_DELIM_EXTRACT stored procedure can be used to extract, to a delimited ASCII file, the audit files of a database. In addition the db2audit tool can be used with the 'extract' and 'delasc' options to accomplish the same. The extracted audit records are placed in a delimited ASCII format which then can be inserted into DB2 database table using the LOAD command.

The load may encounter the following errors and as a result reject some of the records.

LOAD FROM D:\AUDIT\execute.del OF DEL MODIFIED BY DELPRIORITYCHAR LOBSINFILE INSERT INTO DB2AUDIT.EXECUTE
SQL3501W The table space(s) in which the table resides will not be placed in
backup pending state since forward recovery is disabled for the database.

SQL3109N The utility is beginning to load data from file
"D:\AUDIT\execute.del".

SQL3500W The utility is beginning the "LOAD" phase at time "06/29/2010
14:04:55.319513".

SQL3519W Begin Load Consistency Point. Input record count = "0".

SQL3520W Load Consistency Point was successful.

SQL3119W The field value in row "135" and column "27" cannot be converted to
an INTEGER value. A null was loaded.

SQL3229W The field value in row "135" and column "32" is invalid. The row was
rejected. Reason code: "1".

SQL3185W The previous error occurred while processing data from row "135" of
the input file.

SQL3125W The character data in row "420" and column "2" was truncated because
the data is longer than the target database column.

SQL3117W The field value in row "420" and column "10" cannot be converted to
a SMALLINT value. A null was loaded.

SQL3119W The field value in row "460" and column "27" cannot be converted to
an INTEGER value. A null was loaded.

SQL3229W The field value in row "460" and column "32" is invalid. The row was
rejected. Reason code: "1".

SQL3185W The previous error occurred while processing data from row "460" of
the input file.

SQL3119W The field value in row "923" and column "27" cannot be converted to
an INTEGER value. A null was loaded.

SQL3229W The field value in row "923" and column "32" is invalid. The row was
rejected. Reason code: "1".

SQL3185W The previous error occurred while processing data from row "923" of
the input file.

SQL3119W The field value in row "924" and column "27" cannot be converted to
an INTEGER value. A null was loaded.

SQL3229W The field value in row "924" and column "32" is invalid. The row was
rejected. Reason code: "1".

SQL3185W The previous error occurred while processing data from row "924" of
the input file.