IBM Support

IZ05879: TWO DEPENDENT AGENTS ENGAGED IN PROCESSING INVALIDATION OF OBJECT AND SPACE MANAGEMENT DELETION, FIRST AGENT CRASHES.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Two dependednt agents processing the invalidation and space
    management deletion of a variation that is dependent on the
    object being invalidated.
    
    First agent points in processing invalidation of the object,
    latch is held.
    Since the invalidating (1st) agent has the latch, second agents
    call to space management will not acquire the latch and then
    will fall into the 'grounding' code. This will NULL out the
    pointers both agents points for the object.
    The first agent will now trap due to the dereference of the
    pointer with a similar stack as the customer encountered.
    
    __1cVsqlra_inval_vars_hard6FpnIsqlrr_cb_CpCI2hIIpHI_i_(0x0,0x1ad
    80000,0x0,0x2e362f8a4,0x2e5b58be0,0x0) + 0x8a4
    __1cUsqlrl_drop_g_t_table6FpnIsqlrr_cb_pChpnIsqlrg_pd_i_i_(0xfff
    fffff73310ea0,0xffffffff6fc16cc0,0x3337f7bf8,0x3337f7800,0x0,0x0
    ) + 0x778
    __1cXsqlrl_declare_g_t_table6FpnIsqlrr_cb_pChpnRsqlrl_table_parm
    s_pnIsqlrg_pd_pnMsqlrg_seq_pd_pnSsqlrg_datapartinfo__i_(0xffffff
    ff73310ea0,0xffffffff6fb14de8,0xffffffff6fb14df8,0xffffffff70811
    2a0,0xffffffff6fb14a00,0x0) + 0x4b4
    __1cWsqlnq_create_table_end6FpnJsqlnq_qtb_Li1rLpnKsqlrl_flds_pnZ
    sqlnq_base_table_seq_info__i_(0xffffffff7e48e077,0x20047ad60,0x1
    000000,0x1400,0xffffffff6fc18418,0xffffffff6fc18408) + 0x33e8
    __1cRsqlnq_table_defn16FppnIstknode__inKactiontype_pCpnDloc__i_(
    0xffffffff7e48f5d9,0xffffffff6fc37570,0xffffffff6fc37340,0xfffff
    fff70c30080,0xffffffff71e04280,0xffffffff7e7b7898) + 0xa98
    __1cMsqlnp_smactn6FpnIsqlnp_cb_i_i_(0xffffffff70c303e0,0xca3c,0x
    ffffffff70c30518,0x5,0xc800,0xffffffff7e7b7898) + 0x61c
    __1cMsqlnp_parser6FpnIsqlnp_cb__i_(0xffffffff70c303e0,0xffffffff
    70c392cf,0xffffffff70c39258,0xffffffff70c385d8,0x19c80000,0xffff
    ffff7e7b7898) + 0x213c
    __1cKsqlnp_main6FpnMsqlnq_string_hppnJsqlnq_qur__i_(0xffffffff7f
    fdae38,0xffffffff6fc387d8,0xffffffff7ffdae60,0x10000,0xffffffff7
    efa9a00,0xffffffff7efbb188) + 0x7c8
    __1cKsqlnn_cmpl6FpnUsqle_agent_privatecb_pnLsqlrrstring_hnRsqlnn
    _compileMode_hpnOsqlrr_cmpl_env_iippnJsqlnq_qur__i_(0xffffffff73
    31b040,0xffffffff7ffdb550,0xffffffff7ffdb6a0,0x4e,0x0,0xffffffff
    73310ea0) + 0x33e8
    __1cKsqlnn_cmpl6FpnUsqle_agent_privatecb_pnLsqlrrstring_hnRsqlnn
    _compileMode_hpnOsqlrr_cmpl_env__i_(0xffffffff7331b040,0xfffffff
    f7ffdb550,0x0,0x5,0x8,0xffffffff7ffdb6a0) + 0x30
    
    .
    .
    .
    .
    .
    
    __1cRsqljsDrdaAsDriver6FpnRsqlcc_init_struct__i_(0xffffffff7efbb
    188,0xffffffff7e7b7898,0xffffffff73200080,0xffffffff7331d180,0x2
    002edb00,0x0) + 0x320
    __1cMsqleRunAgent6FpcI_v_(0x1,0x2002edb00,0xffffffef001878f0,0xf
    fffffff7e38ff07,0xffffffff7efbb1b0,0xffffffff7e7b7898) + 0x1d38
    __1cNsqloCreateEDU6FpFpcI_v0LpnNSQdDLO_EDU_INFO_pi_i_(0xffffffff
    7bbb17d8,0xffffffff7fff58c8,0x8,0xffffffff7f12b8c8,0xffffffff7ff
    f5880,0xffffffff7fff5888) + 0x228
    sqloSpawnEDU(0xffffffff7bbb17d8,0xffffffff7fff58c8,0x8,0xfffffff
    f7fff5888,0xffffffff7fff5880,0x284a008) + 0x1d0
    __1cSsqleCreateNewAgent6FipnIsqlekrcb_pnRsqlcc_init_struct_pnQsq
    lkdRqstRplyFmt_pnSsqle_master_app_cb_ipnUagentPoolLatchVector_pn
    QSQdDLO_EDUWAITPOST_pnRsqle_connect_info_ppnNsqle_agent_cb__i_(0
    x2002edb00,0x2001cd900,0x200010080,0x0,0x3,0xffffffff) + 0x710
    __1cUsqleGetAgentFromPool6FipnRsqlcc_init_struct_ipnMsqlz_app_hd
    l_pnQsqlkdRqstRplyFmt_pnRsqle_connect_info__i_(0xffffffff7f10b82
    8,0x0,0x20001268c,0x2001a6768,0x1,0x0) + 0x2d68
    __1cMsqleGetAgent6FipnRsqlcc_init_struct_ipnMsqlz_app_hdl_pnQsql
    kdRqstRplyFmt_i_i_(0x1,0xffffffff7fff8050,0x23,0x0,0x0,0x200011a
    cc) + 0x964
    __1cVsqlcctcpconnmgr_child6FpcI_v_(0x315,0xffffffff7e370269,0x20
    01e3a20,0x4,0xffffffff,0xffffffff7e7b7898) + 0x15f8
    __1cNsqloCreateEDU6FpFpcI_v0LpnNSQdDLO_EDU_INFO_pi_i_(0xffffffff
    7b9402e0,0xffffffff7fff8898,0x18,0xffffffff7f12b8c8,0xffffffff7f
    ff8724,0xffffffff7fff8858) + 0x228
    sqloSpawnEDU(0xffffffff7b9402e0,0xffffffff7fff8898,0x18,0xffffff
    ff7fff8858,0xffffffff7fff8724,0x284a008) + 0x1d0
    __1cPsqlcctcpconnmgr6FpnPSQdDLCC_CONNMGR_T_pnJsqlf_kcfd_H_h_(0x8
    3258,0x4,0x19580000,0x168,0x2,0x2) + 0x12c0
    sqlcctcp_start_listen(0x200011a80,0x2001e3a20,0x21,0xffffffff7ef
    bb2e0,0x2e78ffc,0xffffffff7b93e898) + 0x54
    __1cKsqlccstrts6FpnJsqlf_kcfd_pnPSQdDLCC_CONNMGR_T_rH_h_(0x20001
    1a80,0x2001e3a20,0xffffffff7fffe3be,0x0,0x2c00,0xffffffff7efbb2e
    0) + 0x16c
    

Local fix

  • No local fix but chance of crash may be reduced by increasing
    PCKCACHESZ by 50%
    

Problem summary

  • TWO DEPENDENT AGENTS ENGAGED IN PROCESSING INVALIDATION OF
    OBJECT AND SPACE MANAGEMENT DELETION, FIRST AGENT CRASHES.
    

Problem conclusion

  • FIX in FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ05879

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-10-03

  • Closed date

    2008-12-03

  • Last modified date

    2008-12-03

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

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

    IZ20732

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R910 PSY

       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:
01 October 2021