|
Problem IC87075
|
Status: Closed |
IF TABLE CONTAINS XML COLUMNS, LOAD MIGHT HANG IN LOAD PHASE WHILE RIDDER(db2lrid) TRIES TO TERMINATE ITSELF BECAUSE OF ERROR |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
This problem is first fixed in version 10.1 fixpack 2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.10.2012
13.11.2012
13.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
