DB2 FOR LUW / DB2FORLUW / A10 - DB2

The problem only happens to data partitioned tables and MDC 
tables. 
 
When it happens, the LOAD command appears to hang in LOAD phase. 
In snapshot the application is stuck in "Performing a Load" 
status. 
 
After 'db2pd -stack all' command is performed, the following 
stack traces can be seen in stack files: 
 
+++++ Load coordinator agent if DPF +++++ 
=========================================== 
_p_nsleep 
nsleep 
nanosleep 
ossSleep 
sqlorest 
iFinalSyncUp_sqlusCLoadMPPCoordinator 
iCoordinateSAs_sqlusCLoadMPPCoordinator 
sqlu_register_table_load 
iRun_sqlusCLoadMPPCoordinator 
sqlu_register_table_load_MPP 
sqluvtld_route_in 
=========================================== 
 
+++++ db2lload subagent if DPF or Load agent if EE +++++ 
=========================================== 
select 
sqlorqueInternal 
sqlorque2 
sqlulReadQ 
sqlulPollMsg 
sqluvload 
call_sqluvload 
sqluLoadPartition 
iRun_sqlusCLoadSubAgent 
=========================================== 
 
+++++ db2lfrmX +++++ 
=========================================== 
msgrcv 
sqlorqueInternal 
sqlorque2 
squFetchNewRecListBuf 
sqluGetNewRecordStruct 
sqluFormatDMRec 
sqluGetAndFormatRecords 
iRun_sqluCFormatter 
 
If there is only one formatter (i.e. db2lfrm0), then the stack 
of db2lfrm0 might be as below or almost the same as the stack of 
db2lrid. 
 
thread_wait 
sqloWaitEDUWaitPost 
sqloSyncUp 
sqluFlushRidderData 
iRun_sqluCFormatter 
=========================================== 
 
+++++ db2lrid +++++ 
=========================================== 
msgrcv 
sqlorqueInternal 
sqlorque2 
squGetMsgFromEQ2 
sqlulGetBuff 
sqlulNextPage 
sqluCreateAndInitPage 
sqlulGetRID 
sqluAssignRIDsToDMRecList 
sqluRiddifierProcOneSubList 
sqluRiddifierProcessRecList 
sqluMDCRPProcessAnyCachedLists 
sqluGetDMRecLists 
iRun_sqluCRidder 
=========================================== 
 
+++++ db2lbm +++++ 
=========================================== 
_p_nsleep 
nsleep 
nanosleep 
ossSleep 
sqlorest 
sqlulBMGetNextBuffer 
sqluGetMoreDataForBM 
sqlulBMCont 
iRun_sqluCBufferManipulator 
===========================================

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

Increasing the size of data buffer (by specifying a large value 
for DATA BUFFER option in LOAD command, such as 50000 or larger) 
sometimes can solve the problem.

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

First fixed in DB2 LUW Version 10.1 Fix Pack 3.

Increasing the size of data buffer (by specifying a large value 
for DATA BUFFER option in LOAD command, such as 50000 or larger) 
sometimes can solve the problem.

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

12.11.2012
06.10.2013
06.10.2013