DB2 FOR LUW / DB2FORLUW / 950 - DB2

Under certain scenarios,a message was added to the db2diag.log 
to provide additional 
information.  The new message by itself is not necessarily an 
indication of a problem 
and there could be legitimate reasons statistics were not 
present when the test surrounding 
the message is checked. 
 
Unless there are other failures occurring, the message by itself 
does not necessarily mean there is a problem. 
 
Below is a sample message: 
2011-11-22-09.18.24.852532-120 I224142E1587        LEVEL: Severe 
PID    : 24446                TID  : 47274847627584PROC : 
db2sysc 0 
INSTANCE: db2inst1            NODE : 000          DB  : SAMPLE 
APPHDL  : 0-14298              APPID: 
*LOCAL.db2inst1.111122093345 
AUTHID  : DB2INST1 
EDUID  : 22                  EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, SW- query graph, sqlnq_fcs::need_statistics, 
probe:140 
MESSAGE : cst population error 
DATA #1 : signed integer, 4 bytes 
3 
DATA #2 : String with size, 24 bytes 
TABLE1 
CALLSTACK: 
  [0] 0x00002AFEF0B7B637 pdLog + 0xD7 
  [1] 0x00002AFEF1D21DB7 _ZN9sqlnq_fcs15need_statisticsEP3loc + 
0x1E7 
  [2] 0x00002AFEF1B41621 
_Z25sqlno_kc_get_eff_colcountP13sqlno_globalsP9sqlnq_qnc22SQLNO_ 
SET_EFF_COLCOUNTPP3locPS2_Pf + 0x3BF 
  [3] 0x00002AFEF1B41156 
_Z22sqlno_kc_func_colcountP13sqlno_globalsP9sqlnq_qncP9sqlnq_pid 
22SQLNO_SET_EFF_COLCOUNTPP3locPS2_Pf + 0x8C4 
  [4] 0x00002AFEF1B418AD 
_Z25sqlno_kc_get_eff_colcountP13sqlno_globalsP9sqlnq_qnc22SQLNO_ 
SET_EFF_COLCOUNTPP3locPS2_Pf + 0x64B 
  [5] 0x00002AFEF1BDF02E 
_Z32sqlno_int_order_arrange_grby_ordP13sqlno_globalsP9sqlno_qtbP 
16sqlno_listheader + 0x31A 
  [6] 0x00002AFEF1C5D49D 
_Z20sqlno_plan_begin_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_opr + 
0x4E9 
  [7] 0x00002AFEF0DC8F58 
_Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ 
LNN_BOOLEAN + 0x8E 
  [8] 0x00002AFEF1C65436 
_Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_ 
opr + 0x9C 
  [9] 0x00002AFEF0DC8F58 
_Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ 
LNN_BOOLEAN + 0x8E

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See above.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.5 Fix Pack 9.                           * 
****************************************************************

Ignore the message unless other failures are occurring. 
Alternately, reduce DIAGLEVEL to 0 to turn off all messages to 
the db2diag.log.

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

Problem was first fixed in Version 9.5 Fix Pack 9.

keiner bekannt / siehe Local-Fix

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

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

30.11.2011
23.03.2012
23.03.2012

9.5.FP9