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

SET LOCKTABFILTER
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

Filters lock information according to the object specified

Scope

SQLMON Only

SQLMON Syntax

SET LOCKT [ABFILTER] [ Owner.Table [/Constraint] OFF ]

Parameters

Owner.Table

Displays only table lock information about Owner.Table.

Constraint

Displays only constraint lock information about Constraint.

OFF

Default value.

Description

  • This command affects the following screens:

    • Lock

    • Lock Object

    • Lock Session

Example

Only the locks associated with the PurchDB.Parts table are displayed:

   SQLMONITOR LOCK => SET LOCKTABFILTER PurchDB.Parts

SQLMON prompts for the parameters when they are omitted, as follows:

   SQLMONITOR LOCK => SET LOCKTABFILTER



   OWNER.TABLE[/CONSTRAINT]: PurchDB.Parts

Display only those locks associated with the Members_FK referential constraint:

   SQLMONITOR LOCK => SET LOCKTABFILTER RecDB.Members/Members_FK


SET LOCKOBJECT
  		 


SET MENU  
Feedback to webmaster