HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 9 SQLMON Command Reference

SET LOCKOBJECT
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

Specifies the objects that are displayed on the Lock Object screen

Scope

SQLMON Only

SQLMON Syntax

SET LOCKO [BJECT] [ Owner.Table [/Constraint] [/PageRowID ] 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


SET LOCKFILTER
  		 


SET LOCKTABFILTER  
Feedback to webmaster