DB2 - Problem description
Problem IT09916 | Status: Closed |
"QUIESCE DB" COMMAND MIGHT HANG ON DB2 SERVER, IF CONNECTION CONCENTRATOR AND LOOPBACK IS USED | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
"quiesce DB" command might hang, and the decoupled application handles might not be forced off. Similarly commands like db2stop force might hang too, as internally they try to force off these decoupled application handles in a loopback setup. The stack shows , the disconnect signal been send and then it simply hangs- StackTrace> -------Frame------ ------Function + Offset------ 0x0900000000116048 recv + 0xC8 0x09000000110ACF70 tcprecv__FP17SQLCC_COMHANDLE_TiPcT2UsT5P21SQLCC_TCPCONNHANDLE_TP 12SQLCC_COND_TUiPi + 0x30C 0x09000000110AECF4 sqlcctcprecv__FP17SQLCC_COMHANDLE_TP12SQLCC_COND_T + 0x4B8 0x090000000DEDA220 sqlccrecv + 0x12C 0x090000000FD574C0 sqljcReceive__FP10sqljCmnMgr + 0x104 0x090000000D8A4828 sqljrDrdaArDisconnect__FP14db2UCinterface + 0x278 0x090000000D8E9104 sqleuUCagentDrdaArTermConnect__FP14db2UCinterface + 0x84 0x090000000E6D415C sqleUCagentConnCleanup__FP8sqeAgentP14db2UCconHandlebT3 + 0x118 0x090000000DDF6148 sqleUCagentConnCleanup__FP8sqeAgentP14db2UCconHandlebT3@glue9E5 + 0x7C 0x090000000D995630 @63@sqljsDBCleanup__FP8sqeAgentP14db2UCinterface + 0x110 0x090000000FC20D18 @63@sqljsInitApp__FP8sqeAgentP14db2UCconHandlePPc + 0x4C 0x090000000FC20BA8 @63@sqljsInitAgent__FP8sqeAgentP18SQLCC_INITSTRUCT_TP14db2UCconH andlePbPPc + 0x328 0x090000000FC200C4 @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x230 0x090000000FC1FBC0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x1EC 0x090000000FCF317C RunEDU__8sqeAgentFv + 0x2F0 0x090000000FCF1968 EDUDriver__9sqzEDUObjFv + 0xE8 0x090000000FCF7E18 sqloEDUEntry + 0x250 </StackTrace> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Customer using loopback in DB2 V9.7 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 V9.7fp11 * **************************************************************** | |
Local Fix: | |
Disable connection concentrator or Loopback | |
Solution | |
The customer won't face any hang after upgrade to DB2 v9.7fp11 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.07.2015 13.10.2015 13.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP11 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.11 |