PM51131: During initialization, RAA ISSUES MSG DMH5986E WITH SQL CODE -913 INDICATING DATABASEDEADLOCK

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Full message information:
    
    "
    DMH5986E: A database connection could not be made. SQL error
    code = -913
     Caused by: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR
    TIMEOUT.  REASON CODE 00C9008E, TYPE OF RESOURCE 00000200, AND
    RESOURCE NAME   DSNDB06 .SYSDBASE. SQLCODE=-913,
    SQLSTATE=57033, DRIVER=3.62.73
    +
     com.ibm.db2.jcc.am.SqlException: UNSUCCESSFUL EXECUTION CAUSED
    BY  DEADLOCK OR TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE
    000002   00, AND RESOURCE NAME DSNDB06 .SYSDBASE. SQLCODE=-913,
    SQLSTATE=57033,
    DRIVER=3.62.73
    "
    

Local fix

  • restart RAA for System z applications
    

Problem summary

  • RAA code was making a query twice, once using READ_UNCOMMITTED
    (1), and a second time using the default (in most cases,
    REPEATABLE_READ (4)).  The second read was redundant, and
    causing lock escalates.
    

Problem conclusion

  • RAA code was changed to not make the second call.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM51131

  • Reported component name

    RAA FOR SSTEM Z

  • Reported component ID

    5655W5700

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-10-28

  • Closed date

    2011-10-28

  • Last modified date

    2013-02-07

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

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

Modules/Macros

  • WSAAWAR
    

Fix information

  • Fixed component name

    RAA FOR SSTEM Z

  • Fixed component ID

    5655W5700

Applicable component levels

  • R600 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Asset Analyzer

Software version:

6.0

Reference #:

PM51131

Modified date:

2013-02-07

Translate my page

Machine Translation

Content navigation