There is no explicit tool available for BI file parsing. However the information written to the BI file is also written to the AI file. When there is an implicit need to see what transaction activity is being written to a BI file, one could configure a database to make use of After Imaging (AI). Refer to example in Article:
Open transactions can be found online by using:
1. The PROMON utility through the
R&D options:
1. Status Displays > 4. Processed/Clients > 3. Active Transactions.
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.
2. VST tables,
_Trans and
_Connect can be employed to give more explicit detail through customization to your particular needs. Below is an example of how this may be constructed.
/* test1 run against sports database*/
CREATE customer.
UPDATE NAME.
/* the transaction that test1 above has just started */
FOR EACH _trans WHERE _Trans._Trans-State EQ "Active"
BY _Trans._Trans-Duration DESCENDING:
FIND _Connect WHERE _Connect._Connect-id = _Trans._Trans-Usrnum + 1.
DISP
STRING(TIME,"HH:MM:SS") LABEL "TIME NOW"
_Trans._Trans-Txtime FORMAT "X(40)"
_Connect._Connect-Name FORMAT "X(20)"
_Connect._Connect-PID FORMAT 99999
_Trans._Trans-Usrnum
_Trans._Trans-Num.
END.
Against a production situation, the transaction at the top of the list will be the longest running one. The above example code can be further modified to fit requirements by adding the
_Lock VST for example. Refer to the example ABL code in Article:
