Thanks Lynn for initiating this.
- Files are called "prune_db.bat/sh", by the way, last time I checked.
Also, some would experience an error like below (from Linux) when running it:
./pg_ctrl: error while loading shared libraries: libqp.so.5: cannot open
shared object file: No such file or directory
I'd suggest adding
PGDATA=$PGDATA/opt/introscope/apm_analysis_server/cots/pgsql/data
LD_LIBRARY_PATH=/opt/introscope/apm_analysis_server/cots/pgsql/lib
export LD_LIBRARY_PATH
export PGDATA
PATH=$PATH:$LD_LIBRARY_PATH
export PATH
to a profile (ie. "caas" as documented, and its profile, ~/.bash_profile file) before running it on shell (or via crontab) to avoid such error.