IZ20888: EXECUTING A STORED PROCEDURE IN A DPF ENVIRONMENT MIGHT CRASH THE INSTANCE IN SQLRL_USERTEMPGETINFO().

DB2 Version 9.1 Fix Pack 7  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

• Executng a Stored Procudure (SP) in a DPF environment might
  crash the instance.  This will only occur if the SP is executed
  from a non-catalog partition.  On the partition where the SP is
  executed the first DB2 Trap file generated with contain the
  following partial stack traceback:
  
  ossDumpStackTrace + 0x0080
  OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa
  sqlo_trce + 0x033b
  sqloEDUCodeTrapHandler + 0x0074
  address: 0x0000002A957D34F0 ; dladdress: 0x0000002A957C7000 ;
  offset in lib: 0x000000000000C4F0 ;
  sqlrl_userTempGetInfoP8sqlrr_cbiP19sqlrl_tbspace_parmsP12sqlrg_s
  eq_pdPtP14sqlrg_partkeyd + 0x029c
  sqlrl_declare_g_t_tableP8sqlrr_cbPhsP17sqlrl_table_parmsP8sqlrg_
  pdP12sqlrg_seq_pdP18sqlrg_datapartinfo + 0x06be
  sqlnq_create_table_endP9sqlnq_qtbmiS0_RmP10sqlrl_fldsP25sqlnq_ba
  se_table_seq_info + 0x281c
  sqlnq_table_defn1PP8stknode_i10actiontypePhP3loc + 0x0b8f
  

Local fix

• Execute the Stored Procedure from the catalog partition.
  

Problem summary

• Users Affected:  ALL
  
  Problem Description:  Please refer to 'ERROR DESCRIPTION'
  
  Problem Summary:  Please refer to 'ERROR DESCRIPTION'
  

Problem conclusion

• Problem was first fixed in Version 9.1 FixPack 6
  

Temporary fix

• see LOCAL FIX
  

Comments

APAR Information

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

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

  IZ21044

Fix information

• Fixed component name

  DB2 DPF

• Fixed component ID

  5724N7400

Applicable component levels

• R910 PSN

     UP