DB2 FOR LUW / DB2FORLUW / A10 - DB2

The problem rarely occurs and only affects Load with DEL or ASC 
files. Load might hang if input data has large corrupted 
section, e.g. 100MB of 0x0 accidentally appended to one row. 
 
When the Load hang occurs, you can observe the following stacks: 
 
Load Media Reader (db2lmr) is stuck on: 
 
select 
sqlorqueInternal 
sqlorque2 
sqluReadBufferFromQueue 
sqluMCContinueRestore 
sqluMCProcessRestoreStates 
sqluMCStartRestoreMediaController 
iRun_sqluCMediaReader 
 
Load Formatters (db2lfrmX) are stuck on: 
 
sqloWaitEDUWaitPost 
sqloSyncUp 
sqluRiddifyRecords 
sqluGetAndFormatRecords 
iRun_sqluCFormatter 
 
or 
 
msgrcv 
sqlorqueInternal 
sqlorque2 
sqlulGetBuff 
sqlulcgf (DEL) or sqlulagr (ASC) 
sqlulcrr (DEL) or sqlularr (ASC) 
sqluGetAndFormatRecords 
iRun_sqluCFormatter

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 10.1 Fix Pack 4                           * 
****************************************************************

Fix the corrupted input data and load again, or try either of 
the following workarounds: 
- Specify the CPU_PARALLELISM 1 parameter for Load; 
- Specify the "ANYORDER" file modifier for Load.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 10.1 Fix Pack 4

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

21.10.2013
02.06.2014
02.06.2014