IZ44660: "CREATE PROCEDURE." TRAPPED WHEN THE NUMBER OF ROUTINE WITH SAME ROUTINETYPE, ROUTINENAME AND PARAM_COUNT >160

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 is sysrouted FROM one or more of the following:

  IZ30448

• 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