Friedrich Harasleben wrote:
 > LOCKED ENTITY  /  ( - waiting process )             PATH    NAME
 > JOBNUM
 > ------------------------------------------------------- ------- --------
 > ------
 > DATA SET VNPOL-D  . . . . . . . . . . . . . . . . . . .   138/1 JDBCSRVR
 > #J1020
 > DATA SET VN-D . . . . . . . . . . . . . . . . . . . . .   138/1 JDBCSRVR
 > #J1020
 > DATA SET RISZUINF-D . . . . . . . . . . . . . . . . . .   416/1 QUICK
 > #S495
 > DATA SET KUNDLIST-D . . . . . . . . . . . . . . . . . .   110/1 QUICK
 > #J1175
 > DATA SET ANBOPOS1-D . . . . . . . . . . . . . . . . . .   417/1 QTP
 > #J1197
 >
 > ANBAK-M: ANBAHNNR = 11013 . . . . . . . . . . . . . . .   138/1 JDBCSRVR
 > #J1020


Boy, I had a hard time using query to reproduce a waiting lock.
Finally went into debug to change the dblock mode to 5 (unconditional).

Anyways, here's my test output from DBUTIL,

show scdb locks

   For database SCDB

                                                          PIN/    PROGRAM
       LOCKED ENTITY  /  ( - waiting process )             PATH    NAME
   JOBNUM
------------------------------------------------------- ------- --------
------
DATA SET CALENDAR-MONTH . . . . . . . . . . . . . . . .    66/1 QUERY    #S2
-waiting for above data set unlocked: . . . . . . . . .    68   QUERY    #S3



In your sample above, I see no contention. I thought a waiting lock
would show the set name so that you would see the name twice.
With the held locks shown first, then the waiting list following.

Keven Miller

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *