CA Tech Tip: ABA Server Database disk space management
The ABA server has a backend PostgreSQL database which grows in size over time. However, you can use the following utility to prune the database of data older than 10 days:
Linux: <Analysis_server_home>/ctl/admin/prune_db.sh
Windows: <Analysis_server_home>\ctl\admin\prune_db.bat
To prevent excessive disk space usage and maintain good performance it is strongly recommended that this utility be scheduled to run nightly using Linux cron or Windows Task Manager as appropriate. To do this, use the account that installed the ABA software.
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.