iX V6.5 (30391-90011)

Chapter 8 457

Using the Database Utilities

>>SHOW

Example 2 (Show Locks)

Here is another example of a locking list that might appear when the >>SHOW LOCKS

command is entered.

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

For database ORDERS

PIN/ PROGRAM

LOCKED ENTITY - ( - waiting process) PATH NAME JOBNUM

1 DATABASE (PENDING) 22 BROWSE #S118

-waiting for zero locks within database:22 BROWSE #S118

2 DATA SET INVENTORY 29/1 INVENTRY #S115

3 SALES: QUANTITY<= 50 28/1 BROWSE #S112

4 CUSTOMER: CUST-NAME = DON'S MERCANTILE 31/1 ORDENTRY #S117

Example 2 Discussion

1 Indicates process 22 (program BROWSE, session 118) has requested a lock

on the database and yet it cannot continue until existing locks held in the

database are released. In this example, the reason for the pending lock is

listed on the line below.

2 Indicates process 29 (program INVENTRY, session 115, access path 1) has

the INVENTORY data set locked.

3 Indicates that process 28 (program BROWSE, session 112, access path 1)

has all entries in the SALES data set with QUANTITY less than or equal

to 50 locked.

4 Indicates process 31 (program ORDENTRY, session 117, access path 1)

has all entries in the CUSTOMER data set with LAST-NAME equal to

DON'S MERCANTILE locked.

All subsequent requests for locks must be made to wait until process 22 releases its

database lock.