Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: Aix- Sqlstate=57033

    Hi,
    I am working on J2EE web application with,
    1.WebSphere 5.1
    2.DB2 7.1 with fixpack 7 as backend.

    Platform : AIX 5.1

    I do have some database operations in my application.

    But the problem is that sometimes i get SQL Exception due to "SQLSTATE=57033".

    Can anybody help me? Why this is happening?

    Thanks in advance.

    Bsa

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Aix- Sqlstate=57033

    SQLSTATE 57033: Deadlock or timeout occurred without automatic rollback.

    Deadlock :
    If app A waits for app B to release a lock and app B waits for app A to release a lock, and neither of them can progress without the lock held by the other, DB2 decides at random to '57033' one of them, thereby allowing the other to complete ... The interval between deadlock checks is defined using db cfg DLCHKTIME- default 10000 milliseconds

    Timeout:

    If app A waits for app B to release a lock, then app A waits for app B to release the lock for LOCKTIMEOUT (db cfg parm) milliseconds ... In this case, app B is not dependent on locks held by app A ... By default, app A will wait for indefinite period (-1) ....


    If you have not changed any of the db cfg parameters I mentioned above, then you application(s) are deadlocking ...

    You can define an event monitor to capture the deadlock ...

    Steps to define and use an event monitor :
    1) Define event monitor - Check SQL Reference for correct syntax

    CREATE EVENT MONITOR DLMON FOR DEADLOCK WRITE TO 'C:\abcd\'

    2) Activate the monitor

    SET EVENT MOINTOR EVMON STATE 1

    3) Allow it to run till you come across a deadlock

    4) Stop Event Monitor

    SET EVENT MOINTOR EVMON STATE 0

    5) Use db2evmon command to format the monitor's output - Refer Command Reference for details

    db2evmon -d sample dlmon

    HTH

    sathyaram





    Originally posted by bsa_java
    Hi,
    I am working on J2EE web application with,
    1.WebSphere 5.1
    2.DB2 7.1 with fixpack 7 as backend.

    Platform : AIX 5.1

    I do have some database operations in my application.

    But the problem is that sometimes i get SQL Exception due to "SQLSTATE=57033".

    Can anybody help me? Why this is happening?

    Thanks in advance.

    Bsa
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2003
    Posts
    2

    Re: Aix- Sqlstate=57033

    >If you have not changed any of the db cfg parameters I mentioned >above, then you application(s) are deadlocking ...

    How to do this ? What are recommanded values?

    Sorry to bother you again!

    - Bsa

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •