Fixes are available
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
"create procedure." trapped when the number of routine with same routinetype, routinename and param_count >160 Stack: ---------- <StackTrace> ##### Object: /opt/IBM/db2/V9.1/lib64/libdb2e.so.1 sqloCrashOnCriticalMemoryValidationFailure(0xffffffff73100530,0x ffffffff 7e45bf69,0xffffffff7e9cb048,0x1c,0x32,0x1000) + 0x50 __1cISMemPoolbGdiagnoseMemoryCorruptionAndCrash6MLkpkc_v_(0xffff ffff7310 0530,0xffffffff7e45bf69,0xffffffff7e9cb048,0x1c,0x32,0x1000) + 0x2a0 sqlofmblkEx(0xffffffff71d8ffe0,0xffffffff71d80000,0x0,0xffffffff 71d80068 ,0x1ff80,0x400) + 0x4c4 __1cbQsqlrlc_sysrtns_procschemas_fetch_from_disk6FpnIsqlrr_cb_pC HHIIIpnI SMemPool_pnWsqlrl_routine_res_list_pnISQdDLZ_RID_pI_i_(0xfffffff f73110ea 0,0xc,0xc20,0x0,0x8,0xffffffff7ffe0bb4) + 0x51c __1cbLsqlrlc_sysrtns_procschemas_load_entry6FpnIsqlrr_cb_pnbGsql rlc_entr y_sysrtns_procschemas_IIIpI_i_(0xffffffff73110ea0,0x24493c140,0x 3,0x7,0x 0,0xffffffff7ffe0bb4) + 0x1ac __1cRsqlrlc_load_entry6FpnIsqlrr_cb_pnTsqlrlc_entry_common_IIIpI _i_(0xff ffffff73110ea0,0x24493c140,0x3,0x7,0x0,0xffffffff7ffe0bb4) + 0x334 __1cUsqlrlc_request_ulock6FpnIsqlrr_cb_pnTsqlrlc_entry_common_pn Usqlrlc anchor_common_pbIIIpIpnOSQdDLP_LOCK_INFO_7_i_(0xffffffff7f0abb80 ,0xfffff fff7ffe0cef,0x0,0x2449384a4,0x3800,0x2449384a4) + 0x60c __1cbEsqlrlc_find_request_usage_lock6FpnIsqlrr_cb_pnKsqlrlc_key IIIppnTs qlrlc_entry_common_pIpnOSQdDLP_LOCK_INFO__i_(0xffffffff73110ea0, 0xffffff ff7ffe1208,0x3,0x7,0x0,0xffffffff7ffe1308) + 0x2e0 __1cbGsqlrlc_sysrtns_procschemas_fetch6FpnIsqlrr_cb_pCHHIIIpnISM emPool_p nWsqlrl_routine_res_list__i_(0xffffffff73110ea0,0xffffffff71d511 88,0x1b6 a0000,0x3,0x0,0xffffffff720302c0) + 0x4ac __1cUsqlrl_find_procedure6FpCH0HHipnPsqlra_func_path_0pnWsqlrg_r esolved rt_list_ipnISMemPool_bppnSsqlra_routine_info_9A0rHrpnLsqlrg_rtnp d__i_(0x ffffffff7ffe1b60,0x80040001,0xffffffff7e849120,0x80040000,0xffff ffff7ffe 1b68,0xffffffff7f091978) + 0x178 ... ... ---------- If issue query below, select count(*) from sysibm.sysroutines where ROUTINETYPE='P' and ROUTINENAME = <routine name> and PARM_COUNT= <param number> The result will be no less than 160
Local fix
Drop some routines so the number of routine with same routinename, same routinetype and param_count is less than 160.
Problem summary
"create procedure." trapped when the number of routine with same routinetype, routinename and param_count >160 If issue query below, select count(*) from sysibm.sysroutines where ROUTINETYPE='P' and ROUTINENAME = <routine name> and PARM_COUNT= <param number> The result will be no less than 160
Problem conclusion
Problem was first fixed in Version V950 Fix Pack 4
Temporary fix
Drop some routines so the number of routine with same routinename, same routinetype and param_count is less than 160.
Comments
APAR Information
APAR number
IZ44660
Reported component name
DB2 UDB ESE SOL
Reported component ID
5765F4102
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-25
Closed date
2009-06-30
Last modified date
2009-07-02
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
R950 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":"950"}]
Document Information
Modified date:
03 October 2021