|
Problem IC91297
|
Status: Geschlossen |
DB2 LOAD INTO PARTITIONED TABLE THAT CONTAINS AN XML COLUMN MAY FAIL WITH SQL0901N - "MAX PSEUDO RID REACHED" |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 3. *
**************************************************************** |
| Local-Fix: |
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. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 Version 10.1 Fix Pack 3. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 03.04.2013
08.10.2013
08.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
