IBM Support

IC92601: RUNSTATS ON XML COLUMNS PRODUCES INAPPROPRIATE WARNING LEVEL DIAGNOSTIC MESSAGES.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • 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.
    

Local fix

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

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 FP9                                      *
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 V9.7 FP9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC92601

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-24

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC95353 IC96274

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R980 PSN

       UP

  • RA10 PSN

       UP

  • RA50 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC92601

Modified date: 17 December 2013