Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    3 dot 3 "t" has escaped!

    Announcements
    1
    1
    1390
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • tom
      tom administrators last edited by

      ... 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.

      1 Reply Last reply Reply Quote 0
      • First post
        Last post