Linking user DB session to locks

Good Morning,

one quick basic question. Is there any link between what "promon" displays in the Lock menu to the DB session id? Here is an example:

Locking list screen:
Code:
Locking and Waiting:
Type   Usr:Ten   Name           Domain                 Record                Trans               Schema
Wait    74       rp080.p50           0                    0                    0                    0
Lock    75       rp080.p51           0                  733                   15                    0

And the DB sesssions:
Code:
[root@accordrush pack]# proshut /bcp/pack/package -C list | grep rp080
 68  16180 Sun Oct 24 14:50:09 2021   rp080.p38   BAT   batch                no
 69  16189 Sun Oct 24 14:50:14 2021   rp080.p39   BAT   batch                no
 70  16199 Sun Oct 24 14:50:19 2021   rp080.p40   BAT   batch                no
 71  16242 Sun Oct 24 14:50:24 2021   rp080.p47   BAT   batch                no
 72  16259 Sun Oct 24 14:50:29 2021   rp080.p48   BAT   batch                no
 73  16268 Sun Oct 24 14:50:34 2021   rp080.p49   BAT   batch                no
 74  16290 Sun Oct 24 14:50:39 2021   rp080.p50   BAT   batch                no
 75  16299 Sun Oct 24 14:50:44 2021   rp080.p51   BAT   batch                no
 76  16313 Sun Oct 24 14:50:49 2021   rp080.p52   BAT   batch                no


Thanks
Richard
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
Yes, the user number shown in the "Usr:Ten:" (user/tenant) column in screen 2 is the database user number assigned when the client connected to the database.

It is also reflected in many other promon screens such as 1,1 (User Control), and in the output of proshut list. You will also see these numbers in the database log.
 
Top