DB2 FOR LUW / DB2FORLUW / A50 - DB2

When collecting statistics on xml columns, the RUNSTATS utility 
logs inappropriate diagnostic messages.  These messages are 
informational only, and should not have been logged as warnings. 
The FUNCTION area of the messages will show sqlr_init_tstat with 
different probe numbers.  One example is: 
 
2013-05-19-00.01.23.710459-240 I3584706A811       LEVEL: Warning 
PID     : 17563742             TID  : 36788       PROC : db2sysc 
0 
INSTANCE: db2inst1               NODE : 000         DB   : MYDB 
APPHDL  : 0-354                APPID: *LOCAL.myapp.130519040103 
AUTHID  : db2inst1 
EDUID   : 36788                EDUNAME: db2agent (MYDB) 0 
FUNCTION: DB2 UDB, relation data serv, sqlr_init_tstat, 
probe:13234 
DATA #1 : String, 17 bytes 
statHeapAutomatic 
DATA #2 : Boolean, 1 bytes 
true 
DATA #3 : String, 13 bytes 
min_pool_size 
DATA #4 : unsigned integer, 8 bytes 
16992 
DATA #5 : String, 5 bytes 
hpmin 
DATA #6 : unsigned integer, 4 bytes 
2813424 
DATA #7 : String, 5 bytes 
hpmax 
DATA #8 : unsigned integer, 4 bytes 
2813424 
DATA #9 : String, 14 bytes 
stat_heap_size 
DATA #10: unsigned integer, 8 bytes 
17956864 
 
This problem was first introduced in DB2 Version 9.7 Fixpack 6.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v10.5 FP3                                     * 
****************************************************************

There is no facility to disable just these warnings from 
sqlr_init_tstat while maintaining DIAGLEVEL 3.

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem Fixed In DB2 v10.5 FP3

keiner bekannt / siehe Local-Fix

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

27.08.2013
21.04.2014
21.04.2014