DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 FixPack 9                             * 
****************************************************************

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

Problem was first fixed in DB2 UDB Version 9.7 FixPack 9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC95992 IC97045 IC97064 
follow-up : 

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

13.09.2013
23.12.2013
23.12.2013

9.7.FP9