Kbase 20179: Interpret SQL-92 Client Connection within PROMON
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How to interpret a SQL-92 client connection within PROMON
FACT(s) (Environment):
Progress 9.1x
FIX:
When a SQL-92 client connects to a Progress database Promon will displays the start of a transaction. SQL clients must always have a transaction open. This is also true at connection, thus the transaction shown in PROMON. This open transaction will not cause the bi file to grow due to the delayed transaction begin/write feature that is implemented in Progress 9.1x.
The key in the PROMON display is the -l, which stands for Limbo Lock. It indicates the record is not being modified and is only used to maintain a transaction as required by SQL.