Kbase P24529: How to find the table name from the table number listed in
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/08/2006 |
|
Status: Unverified
GOAL:
How to find the table name based on the table number reported from promon
FIX:
Using promon to display the locking table (option 4 on the promon main screen):
PROGRESS MONITOR Version 9
Database: /tmp/sports2000
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
Choosing option 1 to Display all Entries
The following is an example of the screen if you were to have a lock
Record Locking Table:
Usr Name Chain # Rec-id Table Lock Flags
24 user1234 REC 226 224 2 EXCL
To find what table this user is locking use the following code and replace the number 2 with the appropriate table number from your promon output.
FOR EACH _file WHERE _file-num=2.
DISP _file-name.