Group Details Private


  • ProTop 3.1415 has escaped!

    ProTop 3.1415 is now available for download!

    Highlights include, but are not limited to:

    • Moved a lot of functions to different hot keys. You may want to study the help screen ("?") before you report that something is missing.

    • Improved the labelling of various fields on the dashboard and configuration screens.

    • Added self-monitoring. Uncomment the scheduled task in etc/schedule.cfg to enable self-monitoring of tmp/*.debug files.

    • Added quite a few color highlights to draw attention to interesting metrics. Yellow = warning, Red = alert, Green = Good job!.

    • Added a "dbIdle" column to "Active Transactions" (the "x" command). This field shows how long it has been since the session has accessed the database. This should help to identify long running transactions that are "just sitting there" (probably on a screen waiting for user input). The dbIdle can only be measured from the point where the "x" screen was invoked - so it is possible that a session that already had an active transaction could really be idle longer than is shown. (This is similar to the blocked session duration on the "b" screen.)

    • Improved the prompting for table and index names in the "users of" screens to prompt if the corresponding data has not been previously supplied when they are invoked.

    • Added a file viewer to enable viewing of reports from within ProTop ("v")

    • Finally figured out how to avoid the "selected" row on the browse widgets -- which means that there are now no more unhighlighted cells!

    • Added a localenv variable to let users control colors. Check it out! Take a look at "0" to fiddle with colors inside the UI in order to decide what you like. (The "0" key may change somewhere down the road, but I couldn't think of a better key to attach it to right now.)

    • Got to the bottom of the "error 49" problems when adding or removing panels to display. It turns out to be a Progress bug 😞 It is expected to be fixed in the next patch for 11.7 and 12.2. See NOTES, #28

    • Added bin\pt3win.bat. This script will run prowin.exe rather than _progres.exe (prowin.exe does not suffer from the bug above). It is less ugly than I expected. Do not expect any fancy GUI stuff to happen. There is no mouse support and if you get all clicky bad things are likely to happen. Do NOT use this as an excuse to make client-server connections.

    • Made the "dashboard", "configuration", and "osinfo" panels the same height. This makes it so that browse panels do not get resized when switching between "top of screen" viewer panels. This, in turn, makes the impact of error 49 (above) slightly less severe when using the default startup panels. Changed the command key for osInfo to lower-case "o" in order to make it consistent with "d"ashboard and "c"onfiguration.

    • Re-arranged the configuration panel to better group items. Added fields for -hashlatchfactor, -lkhash -cpterm. Removed 2PC and Failover Clusters. Changed from "excess" table and index to "unmonitored".

    • Messed around with osInfo. Since it got taller (see item #30) there is a lot of empty space so I added some fields. Thinking about adding more. Revisited AIX and HPUX and updated them.

    • Added 24 bit RGB colors to etc/protermcap.protop. (More details in NOTES file.)

    • Expanded the width of aiinfo "size" field to 1TB and added a "last op" field to show when extents have been switched, marked empty etc.

    • Added a new set of alerts for "slow after-image extent switching". If your IO subsystem is slow and klunky (i.e. SAN storage) and it sometimes takes a long time for the AIMGT daemon to copy FULL extents before marking them EMPTY then this alert is for you.

    • Added a "CSC Age" column on screens that show client-statement-cache information. This column tells you how old the CSC data is. (If the same statement is executed in a loop the CSC timestamp does not update - this is NOT a ProTop error.)

    • The default etc/schedule.cfg will now automatically purge and cleanup TMPDIR and LOGDIR weekly at 2 minutes past midnight Sunday.

    • Winnowing away as much conditional compilation code as possible. The number of &IF pre-processor statements in the code has been greatly reduced. This doesn't directly impact functionality but indirectly it means that the code is more resilient when things like "proutil updatevsts" have not been run since the usual alternative for things like &IF PROVERSION... is to switch to dynamic queries for the bits that are being handled conditionally.

    Additional gory details can be found in the NOTES files.

    posted in Announcements
  • RE: ProTop 3.1415 release candidate!

    tick, tick, tick...

    The time for pre-release feedback is drawing to a close!

    posted in Announcements
  • ProTop 3.1415 release candidate!

    ProTop 3.1415 is almost ready to escape into the wild! If you would like to test the release candidate you can easily obtain by using the (or pt3upd.bat) command like this:

    tom@protoptest> pt3.1415x
    Wed Apr 29 13:24:00 UTC 2020 Updating to pt3.1415x
    Wed Apr 29 13:24:00 UTC 2020 pt3.1415x-src.tar
    Wed Apr 29 13:24:00 UTC 2020 curl -L -o /home/tom/tmp/pt3.1415x-src.tar.gz
    29/04/2020 13:24:05.655+00:00 getfile:|/pt3upd/pt3.1415x-src.tar.gz|/home/tom/tmp/pt3.1415x-src.tar.gz
    29/04/2020 13:24:05.655+00:00 getURL(): newSocket( 80 ) size = 118
    29/04/2020 13:24:05.657+00:00 connect( -H -S 80 )
    29/04/2020 13:24:05.661+00:00 getURL(): newSocket( 80 yes )
    29/04/2020 13:24:07.171+00:00 HTTP/1.1 200 OK
    Wed Apr 29 13:24:12 UTC 2020 running silent install, detailed log is in pt3inst.log

    The release notes can be found in etc/NOTES_3.1415.

    Unless someone finds a really horrible bug this will probably be made available for general release next week!

    posted in Announcements
  • RE: ProTop Version 3.141 Crashs but F3 makes it work

    Thanks for that! (I had not noticed the scrollbar.)

    F3 seems like an odd key to be having any sort of impact at that point. I wonder if the "anykey" key also works 😉

    posted in ~~Bugs~~
  • RE: Installation Instructions

    Are you suggesting that something like:

    > protop
    Please specify a friendly name in etc/dblist.cfg or a full database pathname.
    For example:
        protop s2k
        protop /db/sports2000

    Would be a better error message?

    posted in Downloading and Installing ProTop
  • RE: ProTop Version 3.141 Crashs but F3 makes it work

    Is there more to this message? I'm just seeing one line showing what looks like the "as of" date of the usual screen header.

    posted in ~~Bugs~~
  • RE: Dashboard information

    @peter-whybrow said in Dashboard information: can I tell who and where a user is logged on from a Remote connection?

    The "W" (upper case) command will bring up a list of users and show the server IP address.

    If you need a specific user use the "#" command, set the usr# and then use the "U" command to look at that user's details.

    posted in Using ProTop
  • RE: Dashboard information

    It all comes from the _connect VST.

    The value "connections" on the dashboard screen is calculated as:

    for each dictdb._Connect no-lock where _Connect-usr <> ?:
        tt_Dashboard.con_total  = tt_Dashboard.con_total  + 1.

    So you can think of it as "total active connections".

    Generally speaking you will find many cases where "adding up the numbers" will not equal 100% (or the equivalent) because many connection types will be double counted.

    For instance, a remote connection could be either a 4gl connection or a SQL connection.

    To explain apparent discrepancies in the numbers I would need to see all of them.

    posted in Using ProTop
  • RE: Web portal | General Info | Connections

    if ( not _Connect-device matches "*batch*" ) and _connect-batch <> "yes" then tt_Dashboard.con_self = tt_Dashboard.con_self + 1.

    So "self" is counted for non-batch self-service connections. It (mostly) equates to local interactive connections.

    Somehow I suspect that you are going to suggest that that might be sub-optimal 😉

    posted in ~~Bugs~~
  • ProTop 3.141 is in the wild!

    It took longer than I expected (that pesky day job keeps getting in the way...) but ProTop 3.141 is now available to download!

    Pop on over to or your favorite dashboard and grab a fresh copy of the ProTop client.

    Highlights that I am willing to confess to include:

    • Updated db startup parameter discovery to accomodate the purging of _Startup and _Statbase with oe12.

    • Fixed a problem with etime exceeding the size of an integer in lib/zippy.p

    • Fixed a problem with non-default -basetable and -baseindex resulting in incorrect table and index stats in releases prior to oe11.7

    • Added logRd to logWr ratio to dashboard, reordered the left most column a bit.

    • Slightly reordered the right most dashboard column (connections).

    • Added a new data collector for Pro2. The "2" command will display data about Pro2 and adding "Pro2Activity" to pt3agent.cfg will send that data to the portal for trending purposes.

    • Added LOB activity (LOB data is not available prior to OE12)

    • Re-mapped some keys. Type ? to see the new assignments on the help screen.

    • Fixed user table and index activity issues when non-default base and range are in use on the "U" screen.

    • Added new fields for user locks, lock HWM, TRX activity, -Bp usage and more to "U" (user info). Also re-aligned screen.

    • Removed unnecessary internal temp-table indexes to improve performance.

    • Fixed an issue with "users of" tables or indexes inappropriately remembering the history of tables and indexes being examined.

    • Fixed an issue with non-existent "use an existing custId" program flow at install time.

    • Fixed some problems with OS Info due to off-brand shells spewing non-standard output for "ulimit -a".

    • Cleaned up some issues with user names and "flags" on the uio screen

    • Fixed a problem with settings via the "%" command needing two iterations before they would "stick".

    • Fixed a Windows localization issue with options to WMIC when getting "df" data.

    posted in Announcements

Looks like your connection to ProTop Community was lost, please wait while we try to reconnect.