|
Problem IC88134
|
Status: Closed |
LOAD COMMAND MIGHT HANG WHEN LOADING DATA INTO DATA PARTITIONED TABLES OR MDC TABLES |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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
=========================================== |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
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. |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 LUW Version 10.1 Fix Pack 3. |
| Workaround |
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. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.11.2012
06.10.2013
06.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
