DB2 - Problembeschreibung
Problem IT02765 | Status: Geschlossen |
SLOW PERFORMANCE FROM CLI BASED LOAD | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
CLI based load may experience significantly reduced performance on V10.5. The impact may be greater, if multiple concurrent CLI based loads are being run. The stacks for the load EDUs may be similar (but not always the same) to the following, which can be an indicator that this issue is being hit: 0x0900000002921D54 ossLockGetConflict + 0x1D4 0x09000000183474A4 @143@pdLogInternal__FUlUiT1T2N41PvT1bPPc + 0x89C 0x09000000183CAF68 pdLogEvRecEx + 0x6C 0x090000001833BC30 pdLogEvRecEx + 0xC8 0x090000001D0900A0 sqluvload__FPUcT1P9SQLP_LSN8P7sqlubmhPP15sqlu_media_listT5UcP26s qluCLoadRequestDescriptorP8sqluvlcbPi + 0xD60 0x090000001C08A7E0 @160@call_sqluvload__FP8sqeAgentP12SQLB_GLOBALSP26sqluCLoadReque stDescriptorP20sqlu_loadapi_load_cbiT5PiT7 + 0x1D0 0x090000001D11093C sqluLoadPartition__FP8sqeAgentP26sqluCLoadRequestDescriptoriN23P iT6 + 0x750 0x090000001D0FF230 sqlu_register_table_load__FP26sqluCLoadRequestDescriptorP24sqlus CLoadMPPCoordinatorP15sql_static_dataPb + 0x1B7C 0x090000001BFFD8BC sqluvtld_route_in__FP12SQLE_DB2RA_T + 0x723C 0x0900000017B7D7D4 sqluCliMoveToNextReadUnit__FP13SQLU_REMLD_CB + 0x208 0x0900000017B866A0 sqlrr_array_input_load__FP14db2UCinterfacePP15db2UCdiagStructUlU s + 0x24A0 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix * * Pack 4) or higher. * **************************************************************** | |
Local-Fix: | |
N/A | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
First Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.06.2014 21.10.2014 21.10.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |