progress-4glopenedgeprogress-db

How to know the number of records accessed by a program in Progress-4GL?

I'm trying to know how many records a running program is accessing. I found the VST _TableStat, but it doesn't group the number of records by program.

FOR  EACH _TableStat NO-LOCK
    WHERE _TableStat._TableStat-Create > 0
       OR _TableStat._TableStat-Delete > 0
       OR _TableStat._TableStat-Read   > 0
       OR _TableStat._TableStat-Update > 0,
    FIRST _File NO-LOCK
    WHERE _File._File-Number = _TableStat._TableStat-Id:

    DISPLAY
      /*_File._File-Name*/
        _TableStat-Create
        _TableStat._TableStat-Delete
        _TableStat._TableStat-Read  
        _TableStat._TableStat-Update
        WITH SIDE-LABELS 1 COLUMN 1 DOWN.
END.

This code shows me the tables and how many records are being accessed, but I want to know the program wich is accessing the table.

Is there a way to know this? Or is there a table like _TableStat with a PID or something like that?

Ps.: I'm using Progress 10.2B.

Thanks in advance, Rubinho Santos

Solution

  • What version of Progress?

    Somewhere around 10.1C _UserTableStat was introduced. It has table stats by user.

    There are also the "client statement cache" fields in the _connect VST. If the proper bits are enabled for a session then a stack trace is saved so that you can determine what line a session is executing and how it got there.

    Between them they may allow you to get what you need.

    BTW: ProTop shows you much of this data -- https://protop.com/

    You might also want to look at some of the "log-entry-types" features like 4gltrace and QryInfo if you need fine grained program by program stats.