|
Problem IC87043
|
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 / 970 - 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 users of version 9.7 on Linux, Unix and Windows *
* platforms. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 LUW Version 9.7 Fix Pack 8 or higher levels. *
**************************************************************** |
| Local Fix: |
Specifying CPU_PARALLELISM 1 may avoid hanging. |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 LUW Version 9.7 Fix Pack 8. |
| Workaround |
Specifying CPU_PARALLELISM 1 may avoid hanging. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC87075
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.10.2012
08.04.2013
08.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
