|
Problem IC87149
|
Status: Closed |
LOAD COMMAND MIGHT HANG WHEN LOADING DATA INTO DATA PARTITIONED TABLES OR MDC TABLES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 on Linux, Unix and Windows *
* platforms. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 LUW Version 9.7 Fix Pack 8 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 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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
|
| Solution |
First fixed in DB2 LUW Version 9.7 Fix Pack 8. |
| 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. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88134
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.10.2012
08.04.2013
08.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
