Postgres Not Vacuuming properly and dsp parameters

Products

• Mainframe Operational Intelligence

Issue/Introduction

Postgres is not vacuuming properly.   As a work-around, users can remove the underlying data for Postgres and going through the re-learn process. Then monitor the new instance to see if the vacuuming process properly vacuums itself up after the daily model build process.  What else can be done to tune the DSP parameters for the Postgres database?

Environment

Release : 2.1

Resolution

Attached to this document is a PFA script which can tune DSP to reduce the load on the Postgresql Database.

Steps to run the script dsp_disable_pg_save.sh:
-  Copy the attached script to the target MOI system
-  Run it:  sh dsp_disable_pg_save.sh

Note:  To confirm the change is applied with script "dsp_disable_pg_save.sh" correctly, run the following command:
docker exec -it dsp_dsp_1 cat /opt/CA/itoa/dsp/dsp.env | grep KDE_BUILD_GH