IBM Support

IZ53526: INSTANCE ABEND POSSIBLE DUE TO INCORRECTION EXECUTION SECTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An instance may abend when copying data into a table queue under
    some very specific access plan conditions.
    A typical trap file may show the following functions on top in
    the stacktrace :
    
    Stack:
    ======================
    
     memmove
     sqlkt_pack_tuple
     sqlktins
     sqlritqb2
    
    
     The problem is due to an incorrect buffer location being
    accessed.
     This can only be confirmed by db2 service personnel by
    examining the "section dump" of the execution plan,
     which is located in the binary dump file.
    
     From an access plan point of view, at least the following
    conditions need to be true  :
     * There is a star join that has a join of a dimension table
    (above the IXAND operator ) that references
     the same columns of the dimension table that were already
    accessed in the star join (below the IXAND operator )
     ( this may also be referred to as a back join )
    * The dimension table column that is accessed in the star join
    is accessed via list prefetching
      i.e. there is a RID scan operator followed by a fetch
    operation on the base table.
    
    * The index scan in the list prefetch of the dimension table
    within the star join has a sargable predicate on a column that
    is used in the back join.
    

Local fix

  • There is no known workaround for this problem, other than to
    force a different access plan to avoid
     at least one of the above conditions.
    

Problem summary

  • Problem summary : instance abend possible due to bad
    execution section in
    very specific circumstances ( see long description )
    Users affected : potentially all
    Problem conclusion : This apar fixes this problem
    

Problem conclusion

  • This problem has first been fixed in v9.1 fixpak 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ53526

  • Reported component name

    DB2 DPF

  • Reported component ID

    5724N7400

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-18

  • Closed date

    2009-10-29

  • Last modified date

    2009-10-29

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

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

    JR33398 IC61510

Fix information

  • Fixed component name

    DB2 DPF

  • Fixed component ID

    5724N7400

Applicable component levels

  • R910 PSN

       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