home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT04850 Status: Closed

DB2READLOG() API CAN RETURN RECORDS FORMATTED AS DB2READLOG_FILTER_ON EVEN
WHEN DB2READLOG_FILTER_OFF WAS SET

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
This will happen in the very rare case where we have one 
connection (i.e. application) using the db2ReadLog() API that 
drives 'read' requests while specifying alternating filter 
options (i.e. switching between DB2READLOG_FILTER_ON and 
DB2READLOG_FILTER_OFF). 
 
Example: 
Application: connect to db 
Application: db2ReadLog reads records between LRI 'Val1' and 
'Val2' (FILTER ON) 
Application: db2ReadLog reads records between LRI 'Val1' and 
'Val2' (FILTER OFF) 
 
What matters is that in BOTH cases 'LRI Val2' should be the same 
for both connections. 'LRI Val1' does not matter and can be 
different.  In other words, the second scan is continuing from 
the end of the previous scan (with filtering OFF). 
 
This second scan will return information as if the filter ON 
option was still specified (implying the output structure is 
different) even though filter OFF was used.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 users which utilize db2 read log API.                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v101fp5, db2_v105fp6 or newer.                * 
*                                                              * 
* If you do not want to upgrade do not switch, use a different * 
* connection for the read log API filter OFF if your main scan * 
* is using FILTER ON.                                          * 
****************************************************************
Local Fix:
Solution
This was fixed in V105FP5 and V105FP6, now you can switch 
without any issues.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.10.2014
06.08.2015
06.08.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList