Re: Locks on crashed database

2014-11-27 Thread Peter Ondruška
Dear Knut, many thanks for the tip. For others who need something similar here is the complete code: package xarecovery; import java.sql.SQLException; import java.util.logging.Level; import javax.sql.XAConnection; import javax.sql.XADataSource; import javax.transaction.xa.XAException; import

Locks on crashed database

2014-11-25 Thread Peter Ondruška
Dear all, I have a database that has locks in SYSCS_DIAG.LOCK_TABLE. How do I remove those locks? I restarted the database but the locks are still there. SYSCS_DIAG.TRANSACTION_TABLE also has related record with status PREPARED. This database was used with XA on application server but it was

Re: Locks on crashed database

2014-11-25 Thread Knut Anders Hatlen
Peter Ondruška peter.ondru...@kaibo.eu writes: Dear all, I have a database that has locks in SYSCS_DIAG.LOCK_TABLE. How do I remove those locks? I restarted the database but the locks are still there. SYSCS_DIAG.TRANSACTION_TABLE also has related record with status PREPARED. This database