Viewing Table Lock Statistics

Use the SAP 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 view, select the resource, and select Resource > Monitor Node.
In the left pane of the IQ Node Level Monitor view, select Table Locks.
From the list, select the lock you want details about by highlighting the locking connection, name of user holding the lock or locked table.

Note:

Click a column header to sort the data by that column.
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 Locks	A list of all locked tables for the selected resource.
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 Locks

A list of all locked tables for the selected resource.

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.