IBM Support

LI74952: RUNSTAT ON XML DATA MAY REPORT WARNING IN FUNCTIONXMLRNSTATS::SUMMARIZEBCATCHALLPV()

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • While running runstats on xml tables we may receive following in
    db2diag.log file.
    
    ================================
    2009-09-03-10.55.31.720092+120 I2037449E857        LEVEL:
    Warning
    PID     : 1379                 TID  : 46920529602880PROC :
    db2sysc 0
    INSTANCE: inst1              NODE : 000          DB   : SAMPLE
    APPHDL  : 0-321                APPID: *LOCAL.abcd.090903085300
    AUTHID  : Admin
    EDUID   : 114                  EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, XML Node Manager,
    XmlrnStatsSummarizeBCatchAllPV,
    probe:1976
    DATA #1 : String, 16 bytes
    Sample Node Card
    DATA #2 : unsigned integer, 8 bytes
    0
    DATA #3 : String, 15 bytes
    Sample Doc Card
    DATA #4 : unsigned integer, 8 bytes
    0
    DATA #5 : String, 14 bytes
    Sum Node Count
    DATA #6 : unsigned integer, 4 bytes
    1206532352
    DATA #7 : String, 13 bytes
    Sum Doc Count
    DATA #8 : unsigned integer, 4 bytes
    1185276928
    DATA #9 : String, 20 bytes
    Distinct Value Count
    DATA #10: unsigned integer, 8 bytes
    632
    
    
    This messages are not harmful for the system,these will be
    reported as a info message as a fix of this APAR in future
    releses.
    

Local fix

Problem summary

  • RUNSTAT ON XML DATA MAY REPORT WARNING IN
    FUNCTIONXMLRNSTATS::SUMMARIZEBCATCHALLPV()
    

Problem conclusion

  • This APAR is first fixed in V9.5 Fixpak 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74952

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-09

  • Closed date

    2010-05-14

  • Last modified date

    2010-05-14

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

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

    IC64367 IC64378 IC64380 IC64450 IC64451 IC64452 IC64455

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 May 2010