What are the Unix scripts delivered with ProTop, and what do they do?

Here is a list of scripts delivered with ProTop for Unix/Linux, a short description, and links to other documentation.

NOTE: Files that end with "(x)" are source scripts that can be overwritten during an update to ProTop.  Copy the source script to the file name without the "x".  That file is safe to customize as ProTop will not overwrite it.

 script  Description
 256colors.sh

It displays 256 colors, useful when investigating and setting colors for your ProTop session.  See also Colors.

 8colors.sh

Like 256colors.sh above, displays 8 foreground colors.

 99rb.sh

 An example Custom Application Monitoring batch file.

 aiinfo.sh  Formats rfutil -C image list output for consumption by ProTop.
 aipurge.sh(x)  You can use this script to purge your archive AI files so they do not fill the disk.
 aixdisks.sh  Format AIX disk info output for use by ProTop.
 build.sh(x)  See Dump & Load Scripts (^d).
 cmp.sh Part of Dump & Load Scripts (^d); compares dumped value to loaded value and reports if they do not match.
 colors.sh  ProTop RT command key "0" saves colors here. See Color Picker (0) for more info.
 dbaenv.x  Fix for: ${TMPDIR}/*.err about not knowing your own PID and thus refusing to create a bogus flag file.
 dbanalyscsv.sh  Produces a tabulated version of dbanalys output, especially for ProTop support of multi-tenant dbs.
 dbanalys.sh  Produces the all-important database analysis used by ProTop.
 dbmonitor.sh  Installed as a Windows service during installation.  It runs the ProTop scheduler and (re)starts agents for resources defined in etc\dblist.cfg.
 dbname.dumpsql.sh(x)  Dumps SQL Views and Grants. Companion to dbname.loadsql.sh(x) below.

dbname.loadsql.sh(x)

Contains sqlexp commands to load SQL views and grants. Companion to dbname.dumpsql.sh(x) above.

debug.sh

Runs lib/debug.p and consumes -param parameters.

df.sh 

Runs "df' in the background.

dirtymem.sh

See How to find processes using too much memory for more information.

disconnect

See trxmon for more information.

disconnectx

See trxmon for more information.

dlmon.sh

See Dump & Load Scripts for more information.
 foreachdb.sh  Used by the Scheduler to run commands for active databases.

 getaix.sh(x)

 Grab various kernel parameters and similar info and record them in a sub-directory of $LOGDIR.

 hc.sh

 Automated Health Check using a friendlyName.

 hcz.bat

 Automated Health Check using a database name.

idlx.sh

Show the distribution of active users on the system

idxbuild.sh(x)

See Dump & Load Scripts.

 idxcompact.*.sh

 Produced by hc.bat or by running the "^r" command key in ProTop RT.

killprosession.sh(x)

See trxmon for more information.

lgrot.sh

See Database Log Archiving and Filtering.

 lincoln.bat

 An example Custom Application Monitoring batch file.
 linuxdisks.sh  Lists Linux file system names and usage.

load.shx

See Dump & Load Scripts.

 localenv(.x)

 Localized environment variables. 

localenv.nfs

 Useful when ProTop is installed on a shared filesystem.

logmon.sh.

See Log File Monitor.

 logrotate.sh

 See Database Log Archiving and Filtering.

lvinfo.sh

Report interesting information about AIX filesystems and logical volumes.

 maintenance.sh

 See Stopping ProTop ...

masterblock.sh

Reads the values of the fields in master block of the Progress database.

pasoehc.sh(x)

Executes the Progress pasoe health check script.

picamon.sh

Gather promon pica stats.

 portalenv

 Contains portal-related environment variables.

private_dirty.sh

See How to find processes using too much memory for more information.

 protop 

 Starts ProTop Real Time (RT).

pt3

Starts ProTop Real Time (RT).

 protopenv

 Sets up most of the environment variables used by ProTop.

 pt3inst.sh(x)

 Stub for creating the complete pt3inst.bat that lives in %PROTOP%.

 pt3upd

 Updates the currently installed version of ProTop to the latest or the version you name as the only input parameter.

pt9

 Related to ProTop Real Time (RT) for OE9

ptrace.sh

 Shows the top of the stack from the latest protrace file in the directory.

quiet.sh

Un/sets a quiet point in the given database friendly name.

reaper.sh

Monitor for disconnected _progres sessions.

replsource.sh

Provides replication status given an explicit source repl database name.

repltarget.sh

Provides replication status given an explicit target repl database name.

 restart.sh

 Forces a restart of ProTop processes by removing the tmp\*.flg files.

 sendalert.sh

 See Send Custom Alerts for more information.

setportal

 Creates a new bin/portalenv with the given portal domain.

sqlwidth.sh

Runs the Progress dbtool to correct SQL widths in the given database [table [area]].

startsql.sh(x)

Script to start a SQL broker for the given database for testing purposes.

stopmon.sh

Stops ProTop monitoring by removing tmp/*.flg.

syncdblist.sh

Synchronizes etc\dblist.cfg with resources for this site on the ProTop Portal.

 syncio.sh

 Please take a look at syncio for more information.

tailor.sh

 Change all instances of string1 to string2 in the list of files provided.

tmppurge.sh(x)

 Purge the directory that -T points to.

trxmon.sh

See Removing Old Transactions for more information.

uemacs

MicroEMACS editor.

weekly.sh(x)

Weekly task script. See also Scheduler.

wssenv.sh

WSS working preferences.

 zipenv.sh(x)

 Please take a look at User Experience for more information.

 zippyng.sh

 Please take a look at User Experience for more information.

 zOldTRXDetails.sh(x)

 This script is run when the zOldTRXDetails alert enhancer runs. If the .sh exists, it will try to dump a stack trace for the process holding the old transaction and include it in the alert sent to the ProTop Portal. Please take a look at Alert Configuration for more details.