DB2 FOR LUW / DB2FORLUW / 970 - DB2

Having SQL0083C returned may result in a hang of the database. 
This is only in a SMP env. (INTRA_PARALLEL YES) 
 
Stack: 
IntrptWaitLock 
sqlri_hsjnInit 
 
For example: 
 
insert into t.t4 select c.c1, c.c2 from t.t3 c, ( select b.c1, 
b.c2 from t.t1 a, t.t2 b where a.c1=b.c1 ) d where c.c2=d.c2 
 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0083C  A memory allocation error has occurred.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users of V9.7                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to the latest fix pack.                              * 
****************************************************************

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Fixed in fix pack 9

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC92731 IC95345 
Nachfolger : 

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

21.05.2013
23.12.2013
23.12.2013

9.0.