Kbase P135202: How to find out which program is locking records on the server?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/09/2008 |
|
Status: Unverified
GOAL:
How to find out which program is locking records on the server?
GOAL:
Which program is a user running that is locking lots of records?
GOAL:
How to use promon to find out which program and user is locking many records in the database?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1C
FIX:
A new promon R&D option has been added in OpenEdge 10.1C ("Client Database-Request Statement Caching") that allows client database request information to be cached on the server and displayed via Promon. Typically this will display the program name a user is executing at any particular time, perhaps in response to a investigating why so many records are being locked by a single user, or to find out where a client session is hanging. Typically this would look like:
12/18/07 OpenEdge Release 10 Monitor (R&D)
13:39:02 View Client Statement Cache
User number : 6
User name : user1
User type : SELF
Login date/time : 09/16/08 13:34
Statement caching type : SQL Statement or Single ABL Program Name
Statement caching last updated : 09/16/08 13:34
Statement cache : 4 : progs\test1a.p
Enter user number, P, T, or X (? for help):
Several new fields have been added to the _Connect table to support this functionality (e.g. _Connect-CacheInfoType).