DB2 FOR LUW / DB2FORLUW / A10 - DB2

A value assignment from array of row data type to row data type 
might cause an instance crash. 
The stack trace shows function stack like as follows: 
 
getTargetVar 
psm_gen_assignment 
psm_gen_array_assignment 
sqlnq_psm_process_set_stmt 
sqlnq_psm_sem_act 
sqlnp_smactn 
sqlnp_parser 
sqlnp_main 
 
This issue can come up if all the following conditions are met. 
 
- An SQL routine contains an assignment to an unsubscripted row 
type variable field. 
- The row type variable must be a global variable, or a module 
variable (PL/SQL package variable). 
- The right-hand side of the assignment must contain an array 
subscript. 
 
A script like below illustrates how this problem is produced. 
--------------------------- 
create or replace module M1 
/ 
alter module M1 publish 
  type TYP1 as row( 
     C1  varchar(10) 
  ) 
/ 
alter module M1 publish 
  type TYP1ARRY as typ1 array[integer] 
/ 
alter module M1 publish 
  variable TYP1VAR typ1 
/ 
alter module M1 publish procedure P1 
( 
  in t1arr typ1arry 
) 
modifies SQL data 
language SQL 
begin 
  set typ1var.c1 = t1arr[1].c1; -- 
  -- this assignment may cause a crash. 
end 
/ 
---------------------------

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use value assignment described in the APAR test.   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V10.1 Fixpack 4 or later.              * 
****************************************************************

A temporary local variable can be used to bypass the condition.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

This problem was first fixed in DB2 V10.1 FixPack 4.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC98910 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.01.2014
09.06.2014
09.06.2014