I had a case that I want to share with you, I had a DCA deployment and I notice disk space used by NFS and my DB server is getting decreased (near full in other terms).

So to understand the problem, I have connected to my Postgres DB server, and run the following query to list the database sizes.

SELECT d.datname as Name,  pg_catalog.pg_get_userbyid(d.datdba) as Owner,
    CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
        THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))
        ELSE 'No Access'
    END as Size
FROM pg_catalog.pg_database d
    order by
    CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
        THEN pg_catalog.pg_database_size(d.datname)
        ELSE NULL
    END desc -- nulls first
    LIMIT 20;

You can see from the result above that my OO_DB is consuming 12 GB..

DCA OO includes the following content that helps you reduce the database size. you can simply connect to your oo server https://dca-master-server/oo and login with oo_admin user then launch Purge Execution Summary workflow that is located under this path Library/Integrations/Micro Focus/Operations Orchestration/10.x/Database

Change the following workflow inputs:

ParameterNew value
password<oo_admin password>

Note: Disk space will be claimed immediatly, that depends on your DB vacuum settings it will take time to be reflected.

A quick tip for that, you can do vacuum your self by Posgres psql command as the following:

Connect to your OO database by typing \c and your database name

Force vacuum operation to start by typing VACUUM Full;

You will start to realize disk space reclamation, you can rerun the query I posted earlier to see the current size after vacuum.

I hope this was useful!

Mahmoud Ibrahim (admin)

About the Author

Mahmoud Ibrahim has technology experience with over 18 years of IT industry. He'd worked in many organizations in many roles and expanded his knowledge across technology stacks, and he is enjoying sharing his expertise whenever possible :).
He is working as a presales expert in Micro Focus serving the international community.

View all posts by Mahmoud Ibrahim (admin)
Previous Article
Next Article