DB2 FOR LUW / DB2FORLUW / 980 - 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.8 Fix Pack 3                        * 
****************************************************************

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.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

Problem was fixed in DB2 Version 9.8 Fix Pack 3

keiner bekannt / siehe Local-Fix

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

17.09.2010
10.01.2011
10.01.2011

9.8.FP3