HP 3000 Manuals HP 3000 Manuals
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