DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* 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.   * 
****************************************************************

Specifying CPU_PARALLELISM 1 may avoid hanging.

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 LUW Version 9.7 Fix Pack 8.

Specifying CPU_PARALLELISM 1 may avoid hanging.

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

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

08.10.2012
08.04.2013
08.04.2013

9.7.FP8