When we take a look at a screen of locks in promon via menu option 4 I'm seeing EXCL locks with a Tran State of FWD on them and I cannot find what that means or what combinations of letters that may be. Anyone know?
There was a new transaction state column added to promon in OpenEdge 11.3. It existed in the VSTs as _trans._Trans-Flags but was not available in promon.
The values for this new column are
FWD, UNDO, 2PC, INDOUBT, COORD and FORCE.
They are intended to tell you more about the state of the currently active transaction.
FWD indicates it is in "regular" forward processing.
UNDO means that the active transaction is rolling back (that is performing an UNDO).
An "Active" transaction (associated with a lock) can be in different states such as forward processing or undo processing so the new column was added to help clarify.
You used to see only
Dead, Begin, Active and rarely: Prep, Phase 1, Phase 2
"Dead" has since been replaced by "None" in OpenEdge 10.2b08 since the term "Dead" was confusing to many. Also, there was a bug where if a lock was obtained outside a transaction, the transaction would be labeled as "Dead" even after the transaction became active. This was also fixed in OpenEdge 10.2b08 and beyond.
There was a new transaction state column added to promon in OpenEdge 11.3. It existed in the VSTs as _trans._Trans-Flags but was not available in promon.
The values for this new column are
FWD, UNDO, 2PC, INDOUBT, COORD and FORCE.
They are intended to tell you more about the state of the currently active transaction.
FWD indicates it is in "regular" forward processing.
UNDO means that the active transaction is rolling back (that is performing an UNDO).
An "Active" transaction (associated with a lock) can be in different states such as forward processing or undo processing so the new column was added to help clarify.
You used to see only
Dead, Begin, Active and rarely: Prep, Phase 1, Phase 2
"Dead" has since been replaced by "None" in OpenEdge 10.2b08 since the term "Dead" was confusing to many. Also, there was a bug where if a lock was obtained outside a transaction, the transaction would be labeled as "Dead" even after the transaction became active. This was also fixed in OpenEdge 10.2b08 and beyond.