DB2 FOR LUW / DB2FORLUW / 970 - DB2

When archiving and extracting a delimited ASCII file using the 
'DB2AUDIT EXTRACT DELASC' command, the CONTRSTTYPE column is 
extracted as a string. However, the db2audit.ddl script creates 
the column as an integer. This results in a column type mismatch 
which throws an SQL3119W when executing a LOAD/IMPORT operation 
using the delimited files.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 FP8                                      * 
****************************************************************

Create the audit table with CONTRSTTYPE column as CHAR(1)

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

This issue is fixed in DB2 v9.7 FP8

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC91275 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

02.10.2012
19.04.2013
19.04.2013

9.7.FP8