IBM Support

LI74636: SQL0901N ERROR WHEN RUNSTATS WITH TABLESAMPLE OPTION AGAINST TABLE HAS XML COLUMN WITH LARGE AMOUNT OF ROWS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL0901N error is hit when runstats with tablesample option
    against table has XML columns with over 10,000,000 non null XML
    rows.
    
    db2diag.log has the following kind of messages:
    
    2009-05-02-13.02.58.480811-240 I2139319E1676       LEVEL: Severe
    PID     : 16375                TID  : 189699975520 PROC :
    db2sysc 0
    INSTANCE: db2inst             NODE : 000          DB   :
    SAMPLEDB
    APPHDL  : 0-50023              APPID:
    *LOCAL.db2inst.090502105741
    AUTHID  : MSDB2
    EDUID   : 353                  EDUNAME: db2agent (SAMPLEDB) 0
    FUNCTION: DB2 UDB, XML Node Manager, XmlrnStatsCheckSanity,
    probe:20
    MESSAGE : ZRC=0x82A40001=-2103181311=XMLRN_PRG_ERR
              "XMRN unexpected system error"
              DIA8532C An internal processing error has occurred.
    DATA #1 : String, 32 bytes
    XML Stats Sanity check is failed
    CALLSTCK:
      [0] 0x0000002A989438F7
    _Z21XmlrnStatsCheckSanityP13SQLO_MEM_POOLP8sqlrg_pdi + 0x163
      [1] 0x0000002A97ED1B67
    _Z20sqlr_update_catalogsP8sqlrr_cbP11sqlrrstringS2_P10SQLD_TSTAT
    iPP10SQLD_ISTATPiPP8sqlrg_pdP5sqlcaiP14sqlrg_nodecardtjm +
    0x3FFB
      [2] 0x0000002A97EBE877
    _Z17sqlrLocalRunstatsP8sqlrr_cbP11sqlrrstringS2_S2_httPP8sqlrg_p
    diiiiP16sqlrl_stats_colsPPsjPPtjdjtPP20sqlr_runstats_resultS8_m
    + 0x2267
      [3] 0x0000002A97EB72FA
    _Z8sqlrrstaP8sqlrr_cbP11sqlrrstringS2_S2_hhP17sqlrl_stats_parmsP
    KhPs + 0xD1E
      [4] 0x0000002A97F14AF6 _Z17sqlrr_runstats_DAP5sqldaP5sqlca +
    0x852
      [5] 0x0000002A9705A6F6
    _Z19sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgent
    P5sqlca + 0xFE0
      [6] 0x0000002A9705CF62
    _Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0xE30
      [7] 0x0000002A97155C65
    _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x361
      [8] 0x0000002A9714A5F3
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x3E7
      [9] 0x0000002A9714AD08
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface + 0xF4
    

Local fix

  • Perform runstats without tablesample option
    

Problem summary

  • SQL0901N ERROR WHEN RUNSTATS WITH TABLESAMPLE OPTION AGAINST
    TABLE HAS XML COLUMN WITH LARGE AMOUNT OF ROWS.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 5
    

Temporary fix

  • Perform runstats without tablesample option
    

Comments

APAR Information

  • APAR number

    LI74636

  • 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-06-04

  • Closed date

    2009-12-28

  • Last modified date

    2009-12-28

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

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

    IC61933

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:
28 December 2009