IBM Support

IC77170: TOO MANY OR PREDICATES LEAD TO STACK CORRUPTION ON HP IPF

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On HP IPF you might encounter trap due to stack exhaustion when
    compiling a query with many OR predicates.
    
    The stack of the failing agent may look like following:
    
    <StackTrace>
    ossDumpStackTrace
    OSSTrapFile4dumpEmiP9__siginfoPv
    sqlo_trce
    sqloEDUCodeTrapHandler
    sqlno_pred_classify
    sqlno_analyze_ANDORNOT
    sqlno_analyze_pred_expr
    </StackTrace>
    
    
    To prevent stack corruption due to to many levels of recursion
    DB2 checks for remaining stack memory before entering the next
    level of recursion.
    
    The current implementation of this check does report more free
    stack space memory than actually available on HP IPF.
    This prevents the DB2 Optimizer from detecting the stack memory
    exhaustion on time.
    
    The APAR will adress the stack memory check implementation on HP
    IPF.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users on HP-UX platform.                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Problem Description above.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.5 Fix Pack 9.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.5 Fix Pack 9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77170

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-27

  • Closed date

    2012-03-14

  • Last modified date

    2012-03-14

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

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

    IC77389 IC84149

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 March 2012