Kbase P48708: What is the meaning of the column without a label in the Pro
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/10/2003 |
|
Status: Unverified
GOAL:
What is the meaning of the column without a label in the Promon User Control screen ?
FIX:
The PROGRESS Database Monitor (promon) has a missing column label in the User Control screen (Option 1). The unlabelled column is between the "Wait" and "Trans" columns. The value shown in this column depends on the values of other columns.
When the "Wait" column shows "REC", the unlabelled column reports the RECID that the user is waiting for.
Here is a sample output for the situation mentioned. The user number 2 is waiting for the user number 1 to release the record with RECID 3245.
User Control:
Usr Name Type Wait Trans PID Sem Srv Login Time
0 BROK -- 0 0 11240 3 0 11/08/99 13:31
1 SELF -- 0 401 11261 4 0 11/08/99 13:31
2 SELF REC 3245 402 11267 5 0 11/08/99 13:32
3 SELF -- 2 0 11290 6 0 11/08/99 13:32
When the "Wait" column shows "--" then the connection is NOT waiting for anything and the unlabelled column has whatever was there at the last previous wait.
Within the above sample the user number 3 is not waiting anymore but its last wait was for a transaction end lock (type of lock identified by "2").