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

Fixes are available

Rational Asset Analyzer Fix Pack 4 (6.0.0.4) for 6.0
Rational Asset Analyzer Fix Pack 7 (6.0.0.7) for 6.0
Rational Asset Analyzer Fix Pack 8 (6.0.0.8) for 6.0
Rational Asset Analyzer Fix Pack 9 (6.0.0.9) for 6.0
Rational Asset Analyzer for System z Fix Pack 4 (6.0.0.4) for 6.0
Rational Asset Analyzer for System z Fix Pack 6 (6.0.0.6) for 6.0
Rational Asset Analyzer for System z Fix Pack 7 (6.0.0.7) for 6.0
Rational Asset Analyzer for System z Fix Pack 8 (6.0.0.8) for 6.0
Rational Asset Analyzer for System z Fix Pack 9 (6.0.0.9) for 6.0
Rational Asset Analyzer Fix Pack 10 (6.0.0.10) for 6.0
Rational Asset Analyzer for System z Fix Pack 10 (6.0.0.10) for 6.0
Rational Asset Analyzer Fix Pack 11 (6.0.0.11) for 6.0
Rational Asset Analyzer for System z Fix Pack 11 (6.0.0.11) for 6.0
Rational Asset Analyzer 6.1
Rational Asset Analyzer for System z 6.1
Rational Asset Analyzer Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer for System z Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer for System z Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer Fix Pack 8 (6.1.0.8) for 6.1

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



Document information


More support for:

Rational Asset Analyzer

Software version:

6.0

Reference #:

PM51131

Modified date:

2013-02-07

Translate my page

Content navigation