Skip to end of metadata
Go to start of metadata



This is a method of forcibly ending a session that is being locked.



ALTIBASE HDB version 4 or later



It must be performed by accessing the sys account.

1. Check the table name, transaction ID, and lock type in v$lock.

2. Use the trans_id obtained above to find the session.

3. Use the session_id to check the session information.

4. Disconnect the session.



-A session in which rollback is in progress is not disconnected even if session close is performed, so must wait until the rollback is finished.

-For information on the above v$ view OR SYSTEM_META_TABLE column, refer to the Admin manual.


  • No labels