|
Problem IC87075
|
Status: Geschlossen |
IF TABLE CONTAINS XML COLUMNS, LOAD MIGHT HANG IN LOAD PHASE WHILE RIDDER(db2lrid) TRIES TO TERMINATE ITSELF BECAUSE OF ERROR |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
If table contains XML columns, db2 load might hang in load phase
while Ridder(db2lrid) tries to terminate itself because of some
error (e.g. regular and long data reside in different table
spaces, but the container of regular table space is full during
loading).
When a hang is happening, you can see the following symptoms
from output of "db2pd -util" and stack traces:
- Load is in load phase.
- db2lrid tries to terminate itself and the Load job because of
error.
- db2lrid is waiting for db2lfrmX to complete.
- Some db2lfrmX are synchronizing with other ones, whereas the
other db2lfrmX are still waiting for empty record list buffers.
Stack of db2lrid:
ossSleep
sqlorest
sqluTermRidder
sqluCRidder
sqluLoadEDUDriver
sqloEDUEntry
Stack of db2lfrm doing synchronization:
semtimedop
sqloWaitEDUWaitPost
sqloSyncUp
sqluRiddifyRecords
sqluGetAndFormatRecords
sqluCFormatter
sqluLoadEDUDriver
sqloEDUEntry
Stack of db2lfrm waiting for empty buffers:
msgrcv
sqlorqueInternal
sqlorque2
squFetchNewRecListBuf
sqluGetNewRecordStruct
sqluFormatDMRec
sqluGetAndFormatRecords
sqluCFormatter
sqluLoadEDUDriver
sqloEDUEntry |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to version 10.1 fixpack 2. *
**************************************************************** |
| Local-Fix: |
Specifying CPU_PARALLELISM 1 may avoid hanging. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
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 |
This problem is first fixed in version 10.1 fixpack 2. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 08.10.2012
13.11.2012
13.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
