DB2 FOR LUW / DB2FORLUW / 950 - DB2

This problem with LOAD hanging is rarely hit, and it only 
affects LOAD using DEL files or ASC files (i.e. it does not 
affect other LOAD input types like IXF files, LOAD from CURSOR, 
etc.)  The trigger is when customer's input data has very long 
records. 
 
This problem could be identified by checking the stack 
trace(call stack) of "load formatters (db2lfrmX)" and "load 
media reader (db2lmr)". 
 
"load media reader (db2lmr)" are stuck on stack trace like this: 
 
select 
sqlorqueInternal 
sqlorque2 
sqluReadBufferFromQueue 
sqluMCContinueRestore 
sqluMCProcessRestoreStates 
sqluMCStartRestoreMediaController 
sqloCreateEDU 
...... 
 
 
"load formatters (db2lfrmX)" are stuck on either stack trace: 
 
sqloWaitEDUWaitPost 
sqloSyncUp 
sqluRiddifyRecords 
sqluGetAndFormatRecords 
sqluldat 
sqloCreateEDU 
...... 
 
or: 
 
msgrcv 
sqlorqueInternal 
sqlorque2 
sqlulGetBuff 
sqlulcgf (for DEL file) or  sqlulagr (for ASC file) 
sqlulcrr (for DEL file) or  sqlularr (for ASC file) 
sqluGetAndFormatRecords 
sqluldat 
sqloCreateEDU 
......

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.5 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 LUW Version 9.5 Fix Pack 10 or higher levels.  * 
****************************************************************

1. Specify "CPU_PARALLELISM 1" in LOAD command; or 
2. Specify "ANYORDER" option in LOAD command; or 
3. Increase the amount of load buffer either explicitly via DATA 
BUFFER option or implicitly via increasing UTIL_HEAP_SZ 
database configuration parameter.  (This will work around 
a specific problem instance, but it is possible to hit a 
different load hang with the new load buffer value.)

First fixed in DB2 LUW Version 9.5 Fix Pack 10.

1. Specify "CPU_PARALLELISM 1" in LOAD command; or 
2. Specify "ANYORDER" option in LOAD command; or 
3. Increase the amount of load buffer either explicitly via DATA 
BUFFER option or implicitly via increasing UTIL_HEAP_SZ database 
configuration parameter.(This will work around a specific 
problem instance, but it is possible to hit a different load 
hang with the new load buffer value.)

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

20.09.2009
13.06.2012
13.06.2012

9.5.FP10