IBM Support

IZ65855: DEADLOCKLOSERDATAACCESSEXCEPTION WITH WSRR AND DB2

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When using the WSRR UI, you see
    
    "A problem occurred executing the query [query syntax]"
    
    followed by GSR0089E and GSR0597E with a reason of
    
    org.springframework.dao.DeadlockLoserDataAccessException
    
    Once this has happened, subsequent transactions are likely to
    fail with SQLException error code 4497 and SQLState null.
    

Local fix

  • Not applicable
    

Problem summary

  • The way that WSRR interacted with DB2 meant that in some
    high-throughput environments you might see
    DeadlockLoserDataAccessException.
    
    This fix supplies a runtime fix, and a change to the database
    configuration parameters. The database configuration parameters
    will only be applied if you run a new WSRR install.
    
    If you are applying this fix to an existing WSRR install, you
    should set the following parameters directly against DB2:
    
     db2set DB2_SKIPINSERTED=YES
     db2set DB2_SKIPDELETED=YES
    
    Note that other databases (for example Oracle) are not affected
    by this fix.
    

Problem conclusion

  • Apply this fix to reduce the possibility of database deadlock
    exceptions for DB2.
    
    If you are applying an iFix or a fixpack, ensure that you set
    the DB2SET commands manually to your existing database.
    
    It is expected to be available in 6.3.0.2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ65855

  • Reported component name

    SERVICE REGISTR

  • Reported component ID

    5724N7200

  • Reported release

    630

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-26

  • Closed date

    2009-12-15

  • Last modified date

    2009-12-21

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

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

Fix information

  • Fixed component name

    SERVICE REGISTR

  • Fixed component ID

    5724N7200

Applicable component levels

  • R630 PSY

       UP



Document information

More support for: WebSphere Service Registry and Repository

Software version: 6.3

Reference #: IZ65855

Modified date: 21 December 2009


Translate this page: