Overview

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

Version

ALTIBASE HDB version 4 or later

Solution

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.

Reference

-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.