home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC87149 Status: Geschlossen

LOAD COMMAND MIGHT HANG WHEN LOADING DATA INTO DATA PARTITIONED TABLES OR
MDC TABLES

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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.
verfügbare FixPacks:
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

Lösung
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-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC88134 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.10.2012
08.04.2013
08.04.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP8
Problem behoben lt. FixList in der Version
9.7.0.8 FixList