HP 3000 Manuals HP 3000 Manuals
SET LOCKOBJECT
Specifies the objects that are displayed on the Lock Object screen
Scope
SQLMON Only
SQLMON Syntax
[Owner.Table[/Constraint] [/PageRowID]]
SET LOCKO[BJECT] [ALL ]
[OFF ]
Parameters
Owner.Table Displays only table lock information about
Owner.Table.
Constraint Displays only constraint lock information about
Constraint.
PageRowID Displays only page lock or row lock information
about the page or row you specify. PageRowID
consists of four digits delimited by either
blanks or colons, as in the following examples:
0 1 5 20
0:1:5:20
ALL Displays all of the lock objects that qualify
under LOCKFILTER and LOCKTABFILTER. The default
value.
OFF Causes SQLMON to prompt you for the locked object
when you invoke the Lock Object screen.
Description
* This command affects only the Lock Object Screen.
* If LOCKOBJECT is set to OFF, SQLMON prompts you for parameters
when you invoke the Lock Object screen.
Examples
To display only the sessions that are requesting a table level lock on
PurchDB.Parts, you would enter
SQLMONITOR LOCK => SET LOCKOBJECT PurchDB.Parts
If you omit the last parameter, SQLMON prompts for it, as follows:
SQLMONITOR LOCK => SET LOCKOBJECT
OWNER.TABLE[/CONSTRAINT]: PurchDB.Parts
PAGE/ROW ID: 0 1 5 20
To display only the lock information for the Members_FK referential
constraint, enter
SQLMONITOR LOCK => SET LOCKOBJECT RecDB.Members/Members_FK