IBM Support

IT24609: DB2EXPLN SEGV AND CRASHES THE SERVER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2expln utility may trap in v111m1fp2+ with the following
    scenario.
    
    db2 connect to sample
    db2 "select * from staff"
    db2pd -d sample -dynamic
    db2expln -d sample -cache 513,1,1,1 -o expln.out
    
    produces a stack similar to the following:
    stack in trap file:
    
    0        ossDumpStackTraceInternal
    1        ossDumpStackTraceV98
    2        OSSTrapFile::dumpEx
    3        sqlo_trce
    4        sqloEDUCodeTrapHandler
    5        __restore_rt
    6        sqlra_find_var_env
    7        sqlra_find_var
    8        sqlra_get_sql_cache_sect
    9        sqlerTrustedRtnCallbackRouter
    10       sqlCache
    11       sqloInvokeFnArgs
    12       sqlriInvokerTrusted
    13       sqlriInvokeInvoker
    14       sqlricall
    15       sqlriSectInvoke
    16       sqlrr_process_execute_request
    17       sqlrr_execute
    18       sqljs_ddm_excsqlstt
    19       sqljsParseRdbAccessed
    20       sqljsParse
    21       sqljsSqlam
    22       sqljsDrdaAsSPDriver
    23       sqlerWaitForFencedInvocation
    24       sqlerInvokeFencedRoutine
    25       sqlriInvokeInvoker
    26       sqlricall
    27       sqlriSectInvoke
    28       sqlrr_process_execute_request
    29       sqlrr_execute
    30       sqlerCallDL
    31       sqljs_ddm_excsqlstt
    32       sqljsParseRdbAccessed
    33       sqljsParse
    34       sqljsSqlam
    35       sqljsDrdaAsInnerDriver
    36       sqljsDrdaAsDriver
    37       sqeAgent::RunEDU
    38       sqzEDUObj::EDUDriver
    39       sqloEDUEntry
    40       start_thread
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * N/A                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v111m4fp4                                         *
    ****************************************************************
    

Problem conclusion

  • v111m4fp4 contains fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24609

  • 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

    2018-04-04

  • Closed date

    2019-02-11

  • Last modified date

    2019-02-11

  • 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

  • RB10 PSN

       UP

[{"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":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022