iX V6.5 (30391-90011)

456 Chapter8

Using the Database Utilities

>>SHOW

Example 1 (Show Locks)

>>SHOW ORDERS LOCKS OFFLINE

List the status of locks requested and held in

the ORDERS database on the line printer.

The line printer listing looks similar to this:

HP30391C.00.00 TurboIMAGE/XL: DBUTIL THURS, SEP 21, 1989, 5:06 PM

For database ORDERS

PIN/ PROGRAM

LOCKED ENTITY - ( - waiting process) PATH NAME JOBNUM

1 DATA SET SALES 30/1 BROWSE #S126

2 -waiting for data set unlock: 17 INVENTRY #S128

-waiting for data set unlock: 32 ORDENTRY #S129

-waiting for data set unlock: 21 ORDENTRY #S118

3 DATA SET CUSTOMER 30/1 BROWSE #S126

DATA SET INVENTORY 30/1 BROWSE #S126

Example 1 Discussion

1 Indicates process 30 (program BROWSE executing in session 126) has the

SALES data set locked through access path 1.

2 Shows a queue of processes waiting for the SALES data set to unlock. For

example, in the ﬁrst line, process 17 (program INVENTRY executing in

session 128) is waiting. Because it is listed ﬁrst in the queue, it will be the

next process to resume execution after the SALES data set is unlocked. It

could be waiting to place a lock on the data set or entries in the set.

3 Indicates process 30 (program BROWSE, session 126, access path 1) has

the CUSTOMER data set locked. No processes are waiting for the lock to

be released.