Home

Latest versions	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

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IC98127	Status: Closed
HEAVY WORKLOAD MAY HANG DB2
product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
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 Summary:
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 10.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.5 FixPack 4. * ****************************************************************
Local Fix:

available fix packs:
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
Solution
Problem was first fixed in DB2 UDB Version 10.5 FixPack 4.
Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	04.12.2013 08.09.2014 08.09.2014
Problem solved at the following versions (IBM BugInfos)

Problem solved according to the fixlist(s) of the following version(s)
10.5.0.4