Kbase P13912: How to use promon to determine which records are being locked by a user?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to use promon to determine which records are being locked by a user?
FIX:
Promon can be used to determine what records are being locked in a database. The types of locks and user information associated with these records are also available via promon.
Steps to identify locked records:
1) promon databasename
2) Select number 4 from promon Main Menu:
PROGRESS MONITOR Version 9
Database: /users/ts/osborne/poo
1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database
T. Transactions Control
L. Resolve Limbo Transactions
C. Coordinator Information
M. Modify Defaults
Q. Quit
Enter your selection: 4
3) The Record Locking Table Menu is:
1. Display all entries
2. Match a user number
3. Match a range of user numbers
4. Match a record id
Q. Return to main menu
Enter your selection:
4) Make your selection from above, depending upon your needs.
Example output from selecting number 1. Display all entries:
Record Locking Table:
Usr Name Chain # Rec-id Table Lock Flags
5 osborne REC 100 98 2 SHR
RETURN - repeat, U - continue uninterrupted, Q - quit: