3 dot 3 "t" has escaped!


  • administrators

    ... and is available for download.

    Release notes are in etc/NOTES_3.3t but highlights include:

    Fixed an undocumented feature whereby the dashboard summarization of
    resource and latch waits was improperly initialized on every sample.

    Added "as of" to the ProTop version so that multiple builds with the
    same version id can be distinguished (this is for development builds).

    Modified the "*" screen to no longer "toggle" Client Statement Cache but rather explicitly
    turn it ON, OFF or not change it (?). Also made the warning text RED (see
    above).

    Fixed a couple of "quirks" in the profiling code (the "y" command) and
    made the warning text RED.

    Fiddled with bin/syncio.sh. Improved the formatting of the timing
    and suppressed messages if being run from cron so that it can be run
    automatically and log the results more usefully.

    Added syncIO to the dashboard - this is NOT updated continuously like
    ioResponse. But it will reflect the most recent value that has been
    logged in log/syncio.log so if you run bin/syncio.sh nightly (or more)
    the most recent value will be shown.

    Added index overlap report to the ^D/^R dictionary report. This report
    looks for indexes with common components in order to indentify redundant
    indexes that could potentially be eliminated. Two output files are created
    in the report directory:

    friendlyName.idxoverlap.rpt # analysis showing overlapping components
    friendlyName.redundant.rpt # completely redundant indexes

    (This actually predates the "Communities" thread -- really!)

    Fixed a bug where the new automatic .pf file detection in dbmonitor.p
    was being a bit over-exhuberent and adding extra pf file references for
    each additional resource being started. This doesn't hurt anything but
    it does look funny.

    Modified various fields on the "config" screen to reflect online
    parameter changes. There is more work to be done here but a lot of
    the big ones (-spin, -B...) are covered now.

    Added the "C" command to clear Client Statement Cache settings that
    this ProTop session has made. Users will be reminded on exit if uncleared
    sessions remain.

    Enriched the "dirty schema" alert to list the first 10 offending
    objects.

    Added a warning at startup if no dbanalys can be found. Included
    instructions for remedying the problem.

    Added hashPct metric to track the value of -hash as a percentage
    of the sum of -B and -B2. Added an alert if that percentage is less
    than 25%. (OEM has some bad UI behaviors.)

    Adjusted -pica to reflect the command line value. PROMON and the
    .lg file report MB, _dbParams reports bytes. The startup parameter is
    specified in KB.

    Added "L": Login Broker Config. This reports on 4gl and SQL broker
    configuration and helps you to ensure that you have properly set -Mn, -Mpb,
    -Ma, -SQL* etc. (requires VSTs for OE11.5+, so make sure you run "proutil
    dbName -C updatevsts"!)

    Added the many various operating system environment variables that
    control behaviors to bin/localenv.x and documented their usage. To use
    or modify these features copy the appropriate variable into bin/localenv
    (no ".x") and set accordingly. bin/localenv.x may be updated with new
    releases so do not use it directly - that's why it has a ".x". The
    proper script for localizations is /bin/localenv - the installer will
    not overwrite that.

    Added "&", "ProTop Properties" screen to show the current values of
    many of the variables described above. However, not all of those variables
    are used by protop.p or pt3agent.p and some are not globally available.
    Some of the variables can even be safely changed "on the fly" if you'd
    like to experiment.

    Updated the help screen ("?"), reassigned some of the more obscure
    command keys and added some previously "lightly documented" commands.

    Added an "ai info" screen for a detailed look at ai extent status.
    Use the control-a key to bring up this screen.

    Changed the default for PCTLASTX from yes to no. Basically nobody
    actually monitors full extents by default. If you really want to do
    that then just set it to "yes" in bin/localenv.

    Added some interesting columns to the app server data (first configure
    etc/appsrv.cfg and then use the the "@" command). MaxSrv is the maximum
    number of servers configured in ubroker.properties, Srvr% is the percentage
    of that maximum that you are using. Likewise MaxCli is the maximum number
    of client connections and Cli% the percentage of that maximum that you are
    at. An ActCli column has also been added to show the number of active
    clients.

    Shuffled around the functions of ^d and ^r -- ^d now generates dump
    & load scripts. ^r generates reports.


 

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