SET LOCKFILTER

Filters lock information so that only certain information is displayed

Scope

SQLMON Only

SQLMON Syntax

SET LOCKF [ILTER] [TableType] [...]/ [Granularity] [...]/ [LockStatus] [...]/ [LockMode] [...]/ [QueueLength] [...]

Parameters

TableType

Displays only the locks related to the table types you specify. The allowed values are

S: System tables, those tables whose owner is HPRDBSS, DBCORE, or STOREDSECT
U: User tables, those tables that are not system tables

Granularity

Limits the display of locks according to the granularity of the lock object. The allowed values are

T: Table
P: Page
R: Row

LockStatus

Displays the locks that have the status you specify. The allowed values are

G: Locks that have been granted
W: Locks for which at least one session is waiting
C: Locks that are being converted to a stronger mode

LockMode

Limits the display of locks according to the mode of the lock. The allowed values are

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

This parameter is case sensitive.

QueueLength

Represents the number of sessions in the lock object queue.

Description

SET LOCKFILTER affects only the Lock, Lock Object, and Lock Session screens.
The default value for LOCKFILTER is
SU/TPR/GWC/SXRsxr6v/1
This value causes all locks to be displayed.
You must use all four delimiting slashes in the parameter list, but you can omit any or all of the parameters. If you omit all of the parameters, you set the lock filter to the default value. If you omit some of the parameters, the settings for the missing parameters are unchanged.

Examples

To set the lock filter to the default value, you would enter

   SQLMONITOR LOCK => SET LOCKFILTER ////

To display only those locks for which one or more sessions are waiting, enter

   SQLMONITOR LOCK => SET LOCKFILTER //WC//

The next example displays only those locks that

are for user tables
are table locks or page locks
are held by sessions that are waiting to acquire or convert locks
are either exclusive, intent exclusive, or share plus intent exclusive

   SQLMONITOR LOCK => SET LOCKFILTER U/TP/WC/Xx6/1

Since you can enter the characters within a filter parameter in any order, the two commands in the following example are equivalent:

   SQLMONITOR LOCK => SET LOCKFILTER ///SX6/



   SQLMONITOR LOCK => SET LOCKFILTER ///6SX/

If you omit the last parameter, SQLMON prompts for it, as follows:

   SQLMONITOR LOCK => SET LOCKFILTER



               PRESS <RETURN> TO SELECT ALL ITEMS FOR EACH PROMPT



TABLES       <(S)ystem       (U)ser                       > : U

GRANULARITY  <(T)able        (P)age         (R)Row        > : T P

LOCK STATUS  <(G)ranted      (W)aiting      (C)onverting  > : W

LOCK MODES   <(S)Share       (X)Exclusive   (R)ecovry Excl

              (s)IS          (x)IX          (r)RIX

                             (6)SIX         (v)RSIX       > :

QUEUE LENGTH <integer value greater than 0                > : 2





The current setting for the LOCKFILTER is:



TABLES       : (U)SER

GRANULARITY  : (T)ABLE        (P)AGE

LOCK STATUS  : (W)AITING

LOCK MODES   : (S)SHARE       (X)EXCLUSIVE   (R)ECOVRY EXCL

               (s)IS          (x)IX          (r)RIX

                              (6)SIX         (v)RSIX

QUEUE LENGTH : 2

SET LOCKFILTER

Technical documentation

» Table of Contents

» Index

Scope

SQLMON Syntax

Parameters

Description

Examples