HP 3000 Manuals HP 3000 Manuals
Lock Object Screen This screen identifies the sessions in the lock queue for a particular table, page, or row.To invoke the Lock Object screen, use the o command from the Lock subsystem or the /loc o command from other subsystems. By default, the LOCKOBJECT variable is set to ALL. Therefore, by default, the LOCK OBJECT screen displays all the lock objects that qualify under the LOCKFILTER and LOCKTABFILTER variables. If LOCKOBJECT is set to OFF, you must specify a lock or ALL when you invoke the Lock Object screen. For example, to view information about all the qualified locks, you can enter SQLMONITOR OVERVIEW => /loc o ALL To view information about a single lock on a table, you must provide the table name: SQLMONITOR OVERVIEW => /loc o PurchDB.Parts If the lock is on a page or row, you must provide the table name and the page or row id, separating the two fields with a slash: SQLMONITOR OVERVIEW => /loc o PurchDB.Parts/0:1:5:28 SQLMONITOR OVERVIEW => /loc o PurchDB.Parts/0 1 5 28 As shown in the last two examples, you can use either spaces or colons to delimit the numbers in the page or row id. Field Definitions REFRESH The screen refresh rate, in seconds. LOCKFILTER If the lock object is ALL, the current setting of the LOCKFILTER variable. The LOCKFILTER variable determines the type of lock information that is provided. For more information, see the description of the SET LOCKFILTER command. G The granularity of the lock, either table (T), page (P), or row (R). OWNER.TABLE The name of the table or referential constraint that is [/CONSTRAINT] locked. PAGE/ROW ID The identifier of the page or row that is locked. If the lock object is a table, this field is blank. GWC The lock status, either granted (G), waiting (W), or converting (C) to a stronger mode. MOD The mode of lock that has been granted, as listed below: S Share X Exclusive s Intent share x Intent exclusive 6 Share + intent exclusive R Recovery exclusive r Recovery intent exclusive v Recovery share + intent exclusive If the session is waiting for a lock, this field is blank. If the session is converting a lock, this field displays the old value. NEW The lock mode the waiting session is attempting to acquire. If the lock has been granted, this field is blank. CID The DBEnvironment connection identification number. PIN The MPE/iX process identification number. USER@ACCT The MPE/iX user name and account name. XID The transaction identifier, equivalent to the XID column of the SYSTEM.TRANSACTION pseudotable. ISO The isolation level, equivalent to the ISOLATION LEVEL column of the SYSTEM.TRANSACTION pseudotable. See the "Concurrency Control through Locks and Isolation Levels" chapter in the ALLBASE/SQL Reference Manual for more information. PRI The transaction priority, equivalent to the PRIORITY column of the SYSTEM.TRANSACTION pseudotable. The lowest transaction priority is 255 and the highest is 0. LABEL The transaction label, equivalent to the LABEL column of the SYSTEM.TRANSACTION pseudotable. To assign a label to a transaction, use a BEGIN WORK or a SET TRANSACTION statement. PROGRAM NAME The name of the program being run. Display Conventions Sessions waiting for locks appear on the screen in inverse video. If the session is converting the lock to a stronger mode, the fields are in inverse video and underlined. The absence of inverse video and underlining indicates that the lock has been granted. Related SET Commands The SET commands in the following table affect this screen. ---------------------------------------------------------------------------------------------- | | | | | Command | Description | Example | | | | | ---------------------------------------------------------------------------------------------- | | | | | SET REFRESH | Controls the refresh rate of the | SET REFRESH 5 | | | screen. | | | | | | ---------------------------------------------------------------------------------------------- | | | | | SET LOCKOBJECT | Specifies the lock object | SET LOCKOBJECT | | | displayed. When set to ALL, the | PurchDB.Parts | | | screen displays all lock objects | | | | that qualify under the LOCKFILTER | | | | and LOCKTABFILTER variables. | | | | | | ---------------------------------------------------------------------------------------------- | | | | | SET LOCKFILTER | Filters the lock information | SET LOCKFILTER | | | provided. | /U/TP/W/SXx/5 | | | | | ---------------------------------------------------------------------------------------------- | | | | | SET LOCKTABFILTER | Filters lock information by object | SET LOCKTABFILTER | | | name. | PurchDB.Orders | | | | | ----------------------------------------------------------------------------------------------
![[]](../../pic3k/M012926/FFN603c50.gif)