DB2 FOR LUW / DB2FORLUW / 950 - DB2

V9.5 Fixpak 6 contains a fix for apar IC67239 
As part of the fix, debug code was added but that may get 
triggered in normal circumstances 
( e.g. when a connection has more than 100 open cursors ) which 
may lead to excessive unnecessary error reporting in the 
db2diag.log. 
 
The messages will start with "WARNING: DB2 MAY BE LOOPING IN 
LOOKUP STATMENT." 
 
 
for example the following shell script may trigger the problem 
from CLP : 
 
i=200 
while [ $i -gt 100 ] 
do 
   db2 +c "declare c$i cursor for  values ( $i )" 
   db2 +c "open c$i" 
   i=`expr $i - 1` 
done 
while [ $i -gt 0 ] 
do 
    db2 +c "declare c$i cursor with hold for  values ( $i )" 
    db2 +c "open c$i" 
    i=`expr $i - 1` 
done 
 
db2 commit

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The db2diag.log may contain excessive diagnostic messages    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade DB2 to V9.5 Fixpack 8                                * 
****************************************************************

Turn off the statement monitor switch 
Identify the application/connection with a high number of open 
cursors and alter the application.( e.g. more frequent commits )

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

This problem was first fixed in V9.5 FixPack 8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC73941 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.11.2010
19.07.2011
19.07.2011

9.5.FP8