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 removed for troubleshooting.
Thanks -- Peter Ondruška