IBM Support

IZ53532: SQL0901 with token "Potential corruption in statistics.", from sqlno_prds_is_NPK_adjust_eligible()

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL0901 with token "Potential corruption in statistics.",  from
    sqlno_prds_is_NPK_adjust_eligible()
    
    <A SAMPLE Stack Trace>
    -------Frame------ ------Function + Offset------
    0x09000000003AB6BC pthread_kill + 0x88
    0x09000000057D2B34 sqloDumpEDU + 0x74
    0x09000000059BF610 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
    0xC30
    0x09000000059B7B64 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x584
    0x09000000059B5808 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x188
    0x09000000059B5354 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc +
    0x234
    0x09000000063F4A14 sqlnn_erds__FiN41e + 0x2B4
    0x0900000006A17AA4
    sqlno_prds_is_NPK_adjust_eligible__FP13sqlno_globalsP9sqlno_qtb9
    sqlno_setP9sqlnq_qunT4P13SQLNN_BOOLEAN
    + 0x1264
    0x0900000006A0EE0C
    sqlno_prop_compute_cgs_join_adjust_qun__FP13sqlno_globalsP9sqlno
    _qtbP11sqlno_tableP9sqlno_cgsP9sqlnq_qunT513SQLNN_BOOLEANT79sqln
    o_set
    + 0xC4C
    0x0900000006A0C26C
    sqlno_prop_compute_cgs_join_adjustment__FP13sqlno_globalsP9sqlno
    _qtbP11sqlno_tableP9sqlnq_qunP9sqlno_setP9sqlno_cgs9sqlno_setT7
    + 0x36C
    0x09000000069FCAE8
    sqlno_prop_compute_cgs_adjustments__FP13sqlno_globalsP9sqlno_qtb
    + 0x768
    

Local fix

  • To work around, you may have RUNSTATS done on the tables.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SQL0901 with token "Potential corruption in statistics.",    *
    * from                                                         *
    * sqlno_prds_is_NPK_adjust_eligible()                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * To work around, you may have RUNSTATS done on the tables.    *
    ****************************************************************
    

Problem conclusion

  • Incorrect check of internal statistic profile in optimizer code.
     V91FP8 and future release contains the fix, which will allow
    the query to be ran successfully.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ53532

  • Reported component name

    DB2 EDE AIX

  • Reported component ID

    5724N7600

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-17

  • Closed date

    2010-01-27

  • Last modified date

    2010-01-27

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

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

    IZ56136

Fix information

  • Fixed component name

    DB2 EDE AIX

  • Fixed component ID

    5724N7600

Applicable component levels

  • R910 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]

Document Information

Modified date:
04 October 2021