Skip to main content

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

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

DB2 for Linux, UNIX and Windows


Software version:
10.1


Reference #:
IC87898


Modified date:
2012-12-17

Translate my page

Content navigation