Home

Neueste Versionen	FixList
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren
Kontaktformular

DB2 - Problembeschreibung

Problem IC98127	Status: Geschlossen
HEAVY WORKLOAD MAY HANG DB2
Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
DB2 may hang by a heavy workload. Below stack trace backs may be shown by db2fodc -hang command generating .stack.txt files. We have following few pattern that telling it is not idle. Stack: ====================== 0x09000000000F0694 thread_wait + 0x94 0x090000001624BA24 sqloWaitEDUWaitPost + 0x3B4 0x0900000015D287E0 sqlrihsjn__FP8sqlrr_cb + 0x21D4 0x0900000015D23E94 sqlrihsjn__FP8sqlrr_cb + 0xC08 0x0900000015D23E94 sqlrihsjn__FP8sqlrr_cb + 0xC08 0x09000000160DFD2C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_op... 0x0900000016CFFB44 sqlrr_subagent_router__FP8sqeAgentP12SQ... 0x0900000016CF6738 sqlrr_subagent_router__FP8sqeAgentP12SQ... 0x0900000013867F68 @81@sqleSubRequestRouter__FP8sqeAgentPU... 0x090000001752A690 RunEDU__8sqeAgentFv + 0x343B8 0x09000000175B7D58 RunEDU__8sqeAgentFv + 0xDC 0x090000001539A040 EDUDriver__9sqzEDUObjFv + 0x14C 0x0900000015C224B8 sqloEDUEntry + 0x3A4 Summary: Found in 9 stacks of a total of 45 stacks ( 20.00% ) in 15 ... Found in: ./9306162.100748.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.100748.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.100748.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.35983.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.35983.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.35983.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.94323.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.94323.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.94323.000.stack.txt -- db2agnts(APPL_B) ... Stack: ====================== 0x09000000000F0694 thread_wait + 0x94 0x090000001624BA24 sqloWaitEDUWaitPost + 0x3B4 0x090000001624B380 WaitRecvReady__11sqkfChannelFiT1 + 0x278 0x0900000013514550 ReceiveAnyBuffer__11sqkfChannelFPP10sq... 0x09000000187B1608 sqlktrcv__FP9sqlri_taoPi + 0x874 0x09000000187B367C sqlkt_unpack_tuple__FP9sqlri_taoPiPbP5... 0x09000000187B367C sqlkt_unpack_tuple__FP9sqlri_taoPiPbP5... 0x0900000018300038 sqlritqa__FP8sqlrr_cb + 0x784 0x09000000182FDB30 sqlritqa__FP8sqlrr_cb + 0x188 0x09000000160DFD2C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_o... 0x09000000159D4F18 sqlrr_process_fetch_request__FP14db2UC... 0x0900000015FC5154 sqlrr_open__FP14db2UCinterfaceP15db2UC... 0x0900000016250E14 sqljsParseRdbAccessed__FP13sqljsDrdaAs... 0x0900000016262704 @72@sqljsSqlam__FP14db2UCinterfaceP8sq... 0x0900000016262704 @72@sqljsSqlam__FP14db2UCinterfaceP8sq... Summary: Found in 3 stacks of a total of 45 stacks ( 6.67% ) in 15 ... Found in: ./9306162.27502.000.stack.txt -- db2agent(APPL_B) ... ./9306162.27502.000.stack.txt -- db2agent(APPL_B) ... ./9306162.27502.000.stack.txt -- db2agent(APPL_B) ... ..... This last one seems to be suspicious as it is waiting for lock, but there is no lock wait record in the db2pd -lock. Stack: ====================== 0x09000000000F0694 thread_wait + 0x94 0x090000001624BA24 sqloWaitEDUWaitPost + 0x3B4 0x09000000133ABF00 IntrptWaitLock__12@40@sqeAgentFP16SQLO... 0x0900000015C4603C sqlrsopen__FP8sqlrr_cbP9sqlri_taoiT3P1... 0x0900000014B88888 sqlrisrt__FP8sqlrr_cb + 0x228 0x09000000160DFD2C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_o... 0x0900000016CFFB44 sqlrr_subagent_router__FP8sqeAgentP12S... 0x0900000016CF6738 sqlrr_subagent_router__FP8sqeAgentP12S... 0x0900000013867F68 @81@sqleSubRequestRouter__FP8sqeAgentP... 0x090000001752A690 RunEDU__8sqeAgentFv + 0x343B8 0x09000000175B7D58 RunEDU__8sqeAgentFv + 0xDC 0x090000001539A040 EDUDriver__9sqzEDUObjFv + 0x14C 0x0900000015C224B8 sqloEDUEntry + 0x3A4 Summary: Found in 3 stacks of a total of 45 stacks ( 6.67% ) in 15 ... Found in: ./9306162.170139.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.170139.000.stack.txt -- db2agnts(APPL_B) ... ./9306162.170139.000.stack.txt -- db2agnts(APPL_B) ...
Problem-Zusammenfassung:
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 10.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.5 FixPack 4. * ****************************************************************
Local-Fix:

verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
Lösung
Problem was first fixed in DB2 UDB Version 10.5 FixPack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung:	04.12.2013 08.09.2014 08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)

Problem behoben lt. FixList in der Version
10.5.0.4