Active Transactions can be viewed through PROMON:
Any transaction that is
Active and has a
"transaction start time" that infers that the transaction has been running for longer than 10 minutes, is considered worth further investigation.
PROMON > R&D > 1. Status Displays > 4. Processes/Clients > 3. Active Transactions
Status: Active Transactions by user number for all tenants
Usr Name Domain Type Login time Tx start time Trans id BI RReads BI RWrites Trans State
5 usr1 -3 SELF/ABL 07/08/19 15:37 07/08/19 16:38 33172 0 11887 Active FWD
The following ABL code sample lists all active transactions that are older than two minutes (120 seconds) along with their user numbers and time duration:
DEFINE VARIABLE iTimeInSeconds AS INTEGER NO-UNDO INITIAL 120.
FOR EACH _Trans WHERE _Trans._Trans-State EQ "Active" AND
_Trans._Trans-Duration GT iTimeInSeconds NO-LOCK:
DISPLAY _Trans-Num _Trans-UsrNum _Trans-Duration.
END.
The following variation on the above ABL code sample, also lists the users names:
DEFINE VARIABLE iTimeInSeconds AS INTEGER NO-UNDO INITIAL 120.
FOR EACH _Trans WHERE _Trans._Trans-State EQ "Active" AND
_Trans._Trans-Duration GT iTimeInSeconds NO-LOCK:
FIND FIRST _Connect WHERE _Connect._Connect-Usr = _Trans._Trans-UsrNum NO-LOCK NO-ERROR.
DISPLAY _Trans-Num _Trans-UsrNum _Trans-Duration _Connect._Connect-Name.
END.
