Kbase 15685: TRAN wait in V6 promon
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
TRAN wait in V6 promon
Occasionally a customer may see a wait type of "TRAN" in the User
Control section of V6 promon. This is an undocumented promon feature.
This user is waiting for a transaction to end -- the transaction
number it is waiting for is in the next column of the promon report.
This occurs whenever a user is scanning records via an index
(which is the only way one can scan records in Progress) and
encounters what is called a delete lock entry in a unique index.
Whenever an index entry is deleted in a unique index a lock is left in
the index for the deleted value to make sure that the value is not
re-used until the transaction that deleted the value commits. This is
so that should the transaction roll back and have to restore the value
to the index the undo won't fail for attempting to add a duplicate
value to an unique index. When a user encounters such an entry in
the index, it must wait until the transaction that put it there
commits -- thus the wait on TRAN you see in promon.
Progress Software Technical Support Note # 15685