DB2 FOR LUW / DB2FORLUW / 970 - DB2

In certain scenarios, the db2ReadLog API could return the 
db2ReadLogFilterData structure pre-pended to the log record with 
the "sqlcode" field incorrrectly set to -204. This false error 
message might cause some replication solutions to perform an 
unnecessary full refresh. This error can happen when all of the 
follow criteria are true: 
- The registry variable DB2_LOGGING_DETAIL is set to either 
APPLINFO or AUTHID 
- The iFilterOption field in the db2ReadLog API is set to 
DB2READLOG_FILTER_ON 
- The transaction belongs to a table which has both DATA CAPTURE 
CHANGES and compression enabled.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* In certain scenarios, the db2ReadLog API could return the    * 
* db2ReadLogFilterData structure pre-pended to the log record  * 
* with the "sqlcode" field incorrrectly set to -204. This      * 
* false error message might cause some replication solutions   * 
* to perform an unnecessary full refresh. This error can       * 
* happen when all of the follow criteria are true:             * 
* - The registry variable DB2_LOGGING_DETAIL is set to either  * 
* APPLINFO or AUTHID                                           * 
* - The iFilterOption field in the db2ReadLog API is set to    * 
* DB2READLOG_FILTER_ON                                         * 
* - The transaction belongs to a table which has both DATA     * 
* CAPTURE CHANGES and compression enabled.                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 4                        * 
****************************************************************

If an sqlcode -204 error is found, check the log record type in 
the log manager log record header. If the record type is "0x0069 
- Information Only" OR "0x008B - Application Information", the 
sqlcode can be safely ignored.

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 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
 

Problem was fixed in DB2 Version 9.7 Fix Pack 4

keiner bekannt / siehe Local-Fix

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

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

15.09.2010
28.04.2011
28.04.2011

9.7.FP4