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
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
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*/
/* 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.
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
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: