DB2 FOR LUW / DB2FORLUW / 970 - DB2

Note that this issue affects DB2 LUW Version 9.7 Fix Pack 8 
only. 
 
When very little data buffer is specified, such as 8, for a load 
with a MDC/RP table, and row compression is enabled for the 
table, the load might hang because of exhausted buffers. 
 
You can see the following stacks (especially the load formatter 
stack that is a bit different from the other load hang issues we 
have found before): 
 
Load Media Reader (db2lmr): 
  select 
  sqlorqueInternal 
  sqlorque2 
  sqluReadBufferFromQueue 
  sqluMCContinueRestore 
  sqluMCProcessRestoreStates 
  sqluMCStartRestoreMediaController 
  sqluCMediaReader::iRun 
 
Load Formatter (db2lfrm0): 
  msgrcv 
  sqlorqueInternal 
  sqlorque2 
  squGetMsgFromEQ2 
  sqlulGetBuff 
  sqlulNextPage 
  sqluCreateAndInitPage 
  sqldNextDictPageForLoad 
  sqldInsertDictionary 
  sqluInsertDictionary 
  sqluBuildDictionary 
  sqluAssignRIDsToDMRecList 
  sqluRiddifierProcOneSubList 
  sqluRiddifierProcessRecList 
  sqluRiddifyRecords 
  sqluGetNewRecordStruct 
  sqluFormatDMRec 
  sqluGetAndFormatRecords 
  sqluCFormatter::iRun 
 
Load Buffer Manipulator (db2lbm0): 
  sleep 
  nsleep 
  nanosleep 
  ossSleep 
  sqlorest 
  sqlulBMGetNextBuffer 
  sqluGetMoreDataForBM 
  sqlulBMCont 
  sqluCBufferManipulator::iRun 
 
Load Agent (db2agent): 
  select 
  sqlorqueInternal 
  sqlorque2 
  sqlulReadQ 
  sqlulPollMsg 
  sqluvload 
  call_sqluvload 
  sqluLoadPartition 
  sqlu_register_table_load 
  sqluvtld_route_in

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 For LUW users                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.7 Fix Pack 9 or higher levels.  * 
****************************************************************

Increase the number of data buffers

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

keiner bekannt / siehe Local-Fix

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

10.04.2013
17.12.2013
17.12.2013

9.7.FP9