IC87898: TERMINATE DATABASE HANGS INDEFINITLY WHILE WAITING FOR ANOTHER AGENT THAT IS WAITING FOR START-USING TO COMPLETE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error 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
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2 v101fp2                                       *
    ****************************************************************
    

Problem conclusion

  • upgrade to db2 v101fp2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87898

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-04

  • Closed date

    2012-12-17

  • Last modified date

    2012-12-17

  • APAR is sysrouted FROM one or more of the following:

    IC82686

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • RA10 PSN

       UP

  • RA10 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC87898

Modified date:

2012-12-17

Translate my page

Machine Translation

Content navigation