Viewing Table Lock Details

Use the Sybase Control Center node-level monitor view to display details of locked tables, views or materialized views for the selected SAP Sybase IQ server.

In the Perspective Resources window, select the resource, click the arrow, and select Monitor Node.
In the left pane of the IQ Node Level Monitor view, select Table Locks.
From the Table Locks list, select the lock you want details about by highlighting the locking connection, name of user holding the lock or locked table.

Note: To display the information in a chart or table in the full window, select the Maximize icon in the top right of the area.

Area	Description
Table Lock Details	Connection ID – identifies the locking connection. Table Type – indicates whether the lock is on a table or materialized view. Table Owner – identifies the owner of the locked table or materialized view. Index ID – identifies the index of the locked table or materialized view. Lock Class – indicates the classification as Schema, Row, Table, or Position.. Lock Duration – indicates the duration as Transaction, Position, or Connection. Lock Type – indicates the type (dependant on the lock class). Row ID – identifies the row with an 8-byte row identifier or NULL.

Area

Description

Table Lock Details

Connection ID – identifies the locking connection.

Table Type – indicates whether the lock is on a table or materialized view.

Table Owner – identifies the owner of the locked table or materialized view.

Index ID – identifies the index of the locked table or materialized view.

Lock Class – indicates the classification as Schema, Row, Table, or Position..

Lock Duration – indicates the duration as Transaction, Position, or Connection.

Lock Type – indicates the type (dependant on the lock class).

Row ID – identifies the row with an 8-byte row identifier or NULL.