IBM Support

IT31779: DB2 MIGHT TRAP IN SQLRWAPPLICATIONAGENTITERATOR:EXECUTE() DURINGEXECUTION OF THE MON_GET_APPL_LOCKWAIT TABLE FUNCTION

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

  • It is possible when using autonomous routines to hit a timing
    hole where unlatched access is allowed to a shared structure.
    The unlatched access may cause a trap in the
    sqlrwApplicationAgentIterator::execute() function which is
    executed when
    a user queries the MON_GET_APPL_LOCKWAIT table function.
    
    The stack looks like this:
    From the Stack #1             Signal #11
    0      ossDumpStackTraceInternal
    1      ossDumpStackTraceV98
    2      OSSTrapFile::dumpEx
    3      sqlo_trce
    4      sqloEDUCodeTrapHandler
    5      _IO_ftrylockfile
    6      sqlrwApplicationAgentIterator::execute
    7      sqlrwFilteredApplicationIterator::execute
    8      sqlrwGetApplLockwait
    9      sqlrwGetWLMTableFunctionResult
    10      sqlrwGetWLMTableFunctionMergedResult
    11      sqlerTrustedRtnCallbackRouter
    12      monGetApplLockwait
    13      sqloInvokeFnArgs
    14      sqlriInvokerTrusted
    15      sqlriInvokeInvoker
    16      sqlriutf
    17      sqlri_tfopn
    18      sqlriopn
    19      sqlrita
    20      sqlrihsjn
    21      sqlrihsjn
    22      sqlriSectInvoke
    23      sqlrr_process_fetch_request
    24      sqlrr_open
    25      sqljs_ddm_opnqry
    26      sqljsParseRdbAccessed
    27      sqljsParse
    28      sqljsSqlam
    29      sqljsDrdaAsInnerDriver
    30      sqljsDrdaAsDriver
    31      sqeAgent::RunEDU
    32      sqzEDUObj::EDUDriver
    33      sqloEDUEntry
    34      start_thread
    35      clone
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v111m4fp6 or later                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to db2_v111m4fp6 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31779

  • 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-05

  • Closed date

    2021-03-15

  • Last modified date

    2021-03-15

  • 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:
16 March 2021