IBM Support

LI73413: TABLE OR INDEX STATISTICS CORRUPTION MIGHT CAUSE A DB2 SERVER ABEND

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If the DB2 server is unexpectedly terminated and the DB2 trap
    file contains SIGSEGV (Signal #11) on UNIX or exception
    C0000005 on Windows with the following call function stack,
    it is because of corrupt table or index statistics:
    .
    sqlrg_nodecard::getNodeNumber + 0x0
    sqlno_prds_is_NPK_adjust_eligible + 0x680
    sqlno_prop_compute_cgs_join_adjust_qun + 0x5a7
    sqlno_prop_compute_cgs_join_adjustment + 0x2a5
    sqlno_prop_compute_cgs_adjustments + 0xac0
    sqlno_prop_compute_ff_adjustments + 0x5a
    sqlno_plan_begin_opr  + 0x316
    sqlno_call_sf  + 0x77
    <...snip...>
    .
    The purpose of this APAR is to add resiliency to such scenarios,
    i.e. return an SQL error instead of causing a DB2 server abend:
    .
    SQL0901N  The SQL statement failed because of a non-severe
    system error. Subsequent SQL statements can be processed.
    (Reason "Potential corruption in statistics.".)
    SQLSTATE=58004
    .
    The db2diag.log will contain a message similar to:
    .
    2008-04-21-13.05.38.915985-240 I220900E621       LEVEL: Severe
    PID     : 1334                 TID  : 183089958  PROC : db2agent
    INSTANCE: db2inst1             NODE : 000        DB   : SAMPLE
    APPHDL  : 0-51                 APPID: *N0.db2inst1.080421170528
    AUTHID  : db2inst1
    FUNCTION: DB2 UDB, SW- optimizer,
              sqlno_prds_is_npk_adjust_eligible, probe:220
    MESSAGE : Stats corruption found for the following table.
    DATA #1 : String, 8 bytes
    DB2INST1
    DATA #2 : String, 14 bytes
    TABLE1
    DATA #3 : Dumped object of size 47680 bytes at offset 0, 56 byte
    /home/db2inst1/sqllib/db2dump/13342701332256.000
    .
    To help DB2 support, upon seeing such symptoms please contact
    the IBM DB2 UDB service immediately.
    

Local fix

Problem summary

  • see APAR description
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 2
    

Temporary fix

  • see APAR description
    

Comments

APAR Information

  • APAR number

    LI73413

  • 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

    2008-05-02

  • Closed date

    2008-11-03

  • Last modified date

    2008-11-03

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

    IZ21535

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

Modules/Macros

  • ENG_SQNO
    

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSN

       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:
03 November 2008