IBM Support

IT31866: FODC_TRAP IN MEMCOPY IS POSSIBLE WHEN EXECUTING A COMPLEX QUERY WITH RID FUNCTION WHEN INTERNAL OPTIMIZATIONS ARE DONE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Instance could go down with a NULL pointer access during
    execution of the query in a very rare specific case, when
    internal optimization is done.
    Stacks could vary, but most likely
    - RID function is used in the query
    - Plan has a TEMP or a SORT and there are operations above it.
    - Stack will have sqldEvalDataPred executing sqlri* function
    
    Support needs to be contacted and dumps must be provided for
    examination
    to be sure that this issue is hit.
    
    One of possible stacks:
    
    memcpy
    sqlri_max_Complete_Bigint
    sqlriaggNoGroup2
    sqldEvalDataPred
    sqlsfetc
    sqlriNljnPiped
    sqlriSectInvoke
    sqlrr_subagent_router
    ...
    

Local fix

  • db2stop
    db2set DB2_TCG_DEFAULT_OPTIONS="set disable_pushdown on"
    db2start
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * RID function and SORT                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * See Error Description                                        *
    ****************************************************************
    

Problem conclusion

  • See Error Description
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31866

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-14

  • Closed date

    2021-03-19

  • Last modified date

    2021-03-19

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

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

Document Information

Modified date:
20 March 2021