Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
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:
Fix information
Fixed component name
DB2 UDB ESE SOL
Fixed component ID
5765F4102
Applicable component levels
R910 PSY
UP
Document Information
Modified date:
01 October 2021