I am using PROGRESS 8.3A on a Sun machine running Solaris 2.5.1. Sometimes I get the following entries in the PROMON's "Record Locking Table" option.
Record Locking Table:
Usr Name Chain # Rec-id Lock Flags
260 UOPDMKIA REC 2285 13464166 SHR
201 REC 2606 80900451 EXCL U Q
245 REC 2606 80900451 EXCL U Q
233 B5ZAXIPX REC 2607 84990306 SHR
232 B5CSLIPX REC 2705 73007265 EXCL
Whenever entries with Flag "U Q" appears, my application users will not be able to log in to the database. Usually, I have to kill these users to solve the problem.
Can anyone tell me what does the flag "U Q" means, what causes it & how to solve this problem ?