DB2 FOR LUW / DB2FORLUW / 970 - DB2

Loading a large number of records into a partitioned table that 
contains an XML column may fail with a SQL0901N error. 
 
The LOAD aborts with SQL0901N error and the following is logged 
in db2diag.log: 
 
2012-07-11-23.09.58.209812+120 I3853A817          LEVEL: Severe 
PID     : 7667800              TID  : 7198        PROC : db2sysc 
0 
INSTANCE: ddddd               NODE : 000         DB   : SAMPLE 
APPHDL  : 0-2207               APPID: *LOCAL.ddddd.120711210625 
AUTHID  : DDDDD 
EDUID   : 7198                 EDUNAME: db2lfrm0 0 
FUNCTION: DB2 UDB, database utilities, 
sqluXmlGeneratePseudoRIDForThisRow, probe:4887 
MESSAGE : ZRC=0x82150001=-2112552959=SQLU_GENERIC_ERROR 
"Internal Error" 
          DIA8532C An internal processing error has occurred. 
DATA #1 : LOADID, PD_TYPE_LOADID, 56 bytes 
LOADID: 11793.2012-07-11-23.06.25.021180.0 (65530;32769) 
DATA #2 : String, 22 bytes 
Max pseudo RID reached 
DATA #3 : unsigned integer, 8 bytes 
1 
DATA #4 : unsigned integer, 8 bytes 
1 
DATA #5 : unsigned integer, 8 bytes 
65536

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 Fix Pack 8                    * 
****************************************************************

Split the LOAD files in smaller chunks when possible. 
 
Reduce the DATA BUFFER value used by the LOAD. This buffer needs 
to be specified explicitly in the LOAD command otherwise LOAD 
will 
use around 25% of free memory in the DB2 utility heap.

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 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
 

First fixed in DB2 UDB Version 9.7 Fix Pack 8

keiner bekannt / siehe Local-Fix

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

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

02.08.2012
08.04.2013
08.04.2013

9.7.FP8