SHow

Use the SHOW command to get status of the LOCK mechanism and the LOCK database. The format of the SHOW command is:

SH[OW] [-qualifier...]

The optional qualifiers are:

-A[LL]
-L[OCK] 
-[NO]C[RIT] 
-O[UTPUT]="file-name"
-P[ID]=pid 
-R[EGION]=region-name 
-W[AIT]
-ALL

Specifies all current LOCKs.

-L[OCK]=resource_name

resource_name specifies a single lock.

-[NO]C[RIT]

Allows the SHOW command to work even if another process is holding a critical section.

-O[UTPUT]="file-name"

Directs the reporting of all specified LOCKs to a file.

-P[ID]=pid

Specifies the process identification number that holds a LOCK on a resource name.

-R[EGION]=region-name

Specifies the region that holds the locked resource names.

-W[AIT]

Displays the LOCK resource name and the process state information of all processes waiting for the LOCK to be granted.

Use the following procedure to display all LOCKs active in the database(s) defined by the current global directory.

LKE> SHOW -ALL -WAIT

This produces an output like the following:

No locks were found in DEFAULT 
AREG 
^a Owned by PID=2080 which is an existing process 
BREG 
^b(2) Owned by PID= 2089 anonexistent process 
Request PID= 20400630 which is HIB 
No locks were found in CREG