DB2 FOR LUW / DB2FORLUW / 970 - DB2

This APAR is a more complete fix to that which was originally 
included in APAR IC94729. 
 
The engine might crash (segv/abort) with the following stack 
when explicitly rebinding a program that calls a stored 
procedure: 
 
  0x0000020002F41600 sqlra_get_sect_info_by_cursor_name + 0x0778 
  0x000002000232D1AC sqlnq_sem + 0xc9c0 
  0x0000020001FA71EE 2sqlnp_smactn + 0x01ba 
  0x0000020001F9ECC8 2sqlnp_parser + 0x05f0 
  0x0000020001FA1470 0sqlnp_main + 0x0b20 
  0x0000020001D1F138 0sqlnn_cmpl + 0x283c 
  0x0000020001D243B8 0sqlnn_cmpl + 0x0034 
  0x0000020002ED99AA sqlra_compile_var + 0x1b22 
  0x0000020002EF0D68 sqlra_find_var + 0x1058 
  0x0000020002F66090 sqlra_get_var + 0x0df8 
  0x00000200030B32EC sqlri_ddl_get_section + 0x0070 
  0x00000200030B5F74 sqlri_ddl_common + 0x0914 
  0x00000200030B666A sqlriddl + 0x004e 
  0x00000200030DD198 sqlriSectInvoke + 0x02f8 
  0x0000020002F181D8 sqlra_internal_sql + 0x1b80 
  0x0000020001D3D2EC sqlnn_regen_procedure + 0x1960 
  0x00000200033300B4 address: 0x00000200033300B4; offset in lib: 
0x00000000032D80B4; 
  0x0000020003334318 address: 0x0000020003334318; offset in lib: 
0x00000000032DC318; 
  0x00000200033358A4 sqlrlFindProcedure + 0x10b0 
  0x0000020002000A64 sqlnq_resolve_procedure + 0x096c 
  0x000002000201F084 sqlnq_procedure_tresolve + 0x01b8 
  0x0000020002040374 sqlnq_call_stmt + 0x0274 
  0x0000020001FA71EE sqlnp_smactn + 0x01ba 
  0x0000020001F9F658 sqlnp_parser + 0x0f80 
  0x0000020001FA1470 sqlnp_main + 0x0b20 
  0x0000020001D1F138 sqlnn_cmpl + 0x283c 
  0x0000020001D243B8 sqlnn_cmpl + 0x0034 
  0x0000020002D8E9E8 sqlrr_cmpl + 0x04a8 
  0x0000020002D428F4 sqlrr_compile + 0x0370 
  0x00000200018685FE sqljs_ddm_bndsqlstt + 0x023a 
  0x00000200018327EC sqljsParseInBind + 0x0200 
  0x000002000183317E sqljsParse + 0x0312 
 
The key it seems is to attempt a 'bind' over a program calling a 
procedure after a trivial operation (like 'alter table add 
default value to a column') has been made but the program has 
not been recompiled.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 V9.7 users.                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 11 or higher.                   * 
****************************************************************

Fixed in DB2 V9.7 Fix Pack 11.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

03.10.2014
12.10.2015
12.10.2015

9.7.FP11