|
Problem IC82686
|
Status: Closed |
TERMINATE DATABASE HANGS INDEFINITLY WHILE WAITING FOR ANOTHER AGENT THAT IS WAITING FOR START-USING TO COMPLETE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Database terminate code waits indefintly while waiting for
another agent to finish in sqloWaitEDUWaitPost from function
sqeApplication::AppSecondaryStartUsing:
0x00002AAAABF433E3 sqloWaitEDUWaitPost + 0x0195
0x00002AAAABB6327E
_ZN14sqeApplication22AppSecondaryStartUsingEP8sqeAgentP16SQLE_CL
IENT_INFOP5sqlca + 0x05e8
Terminate database EDU stack:
Stack:
======================
0x00002AAAB03C4E2F ossDumpStackTraceEx + 0x01ef
0x00002AAAB03BFBEE _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00cc
0x00002AAAAD4CBCAB sqlo_trce + 0x03fb
0x00002AAAAD510FD6 sqloDumpDiagInfoHandler + 0x00e0
0x00002AAAAABD4C00 __invoke_dynamic_linker__ + 0x0370
0x00002AAAB0D74D2A semtimedop + 0x000a
0x00002AAAABF433E3 sqloWaitEDUWaitPost + 0x0195
0x00002AAAABB68344 _ZN19sqzReservableObject14WaitForLastManEi
+ 0x00fa
0x00002AAAABB7EDCE
_ZN16sqeLocalDatabase13TermDbConnectEP8sqeAgentP5sqlcai + 0x110a
0x00002AAAABB6131D
_ZN14sqeApplication12AppStopUsingEP8sqeAgenthP5sqlca + 0x0b75
0x00002AAAAC8FDDB4 _Z21sqleSubAgentStopUsingP8sqeAgent +
0x00c6
0x00002AAAAC8E8C10 _Z20sqleSubRequestRouterP8sqeAgentPjS1_ +
0x0e30
0x00002AAAAC8E8EA8 _Z21sqleProcessSubRequestP8sqeAgent +
0x00a6
0x00002AAAABB55333 _ZN8sqeAgent6RunEDUEv + 0x0629
0x00002AAAAC22491C _ZN9sqzEDUObj9EDUDriverEv + 0x00a6
0x00002AAAAC224873 _Z10sqlzRunEDUPcj + 0x0009
0x00002AAAABF93E3A sqloEDUEntry + 0x02f4
0x00002AAAAABCD143 cond_extricate_func + 0x0083
0x00002AAAB0D738CD __clone + 0x006d
Stack of Agent stuck in sqloWaitEDUWaitPost
Stack:
======================
0x00002AAAB03C4E2F ossDumpStackTraceEx + 0x01ef
0x00002AAAB03BFBEE _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00cc
0x00002AAAAD4CBCAB sqlo_trce + 0x03fb
0x00002AAAAD510FD6 sqloDumpDiagInfoHandler + 0x00e0
0x00002AAAAABD4C00 __invoke_dynamic_linker__ + 0x0370
0x00002AAAB0D74D2A semtimedop + 0x000a
0x00002AAAABF433E3 sqloWaitEDUWaitPost + 0x0195
0x00002AAAABB6327E
_ZN14sqeApplication22AppSecondaryStartUsingEP8sqeAgentP16SQLE_CL
IENT_INFOP5sqlca + 0x05e8
0x00002AAAAC8F8B48 _ZN8sqeAgent12initSubAgentEv + 0x0cd0
0x00002AAAAC8E8E75 _Z21sqleProcessSubRequestP8sqeAgent +
0x0073
0x00002AAAABB55333 _ZN8sqeAgent6RunEDUEv + 0x0629
0x00002AAAAC22491C _ZN9sqzEDUObj9EDUDriverEv + 0x00a6
0x00002AAAAC224873 _Z10sqlzRunEDUPcj + 0x0009
0x00002AAAABF93E3A sqloEDUEntry + 0x02f4
0x00002AAAAABCD143 cond_extricate_func + 0x0083
0x00002AAAB0D738CD __clone + 0x006d |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 v97fp7 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC87429 IC87898
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.04.2012
23.10.2012
23.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
