HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET LOCKTABFILTER 

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 

MPE/iX 5.0 Documentation