How to shrink database file size when Management UI is used to manage the DSAs?

Products

• CA Directory

Issue/Introduction

The procedure to increase the database file size when Management UI is used to manage the Data DSAs is relatively simple. See

How can I extend my DXgrid datastore when the DSA is managed through Management UI?

To decrease the datastore size for DSA managed using Management UI, however, can be challeging. 

Environment

Release: 14.1
Component: CA Directory

Cause

The management UI only pulls information from the configuration files when a DXagent is added to an Environment. It also does not allow an administrator to decreate the database file size the same as how dxentenddb can not decreate the size of a database store. 

Resolution

To decreate the size of a database file size when Management UI is used to manage a Data DSA, there are two main tasks:

1. To decrease the size of a database file from command line through a backup/restore process using ldif files
2. To bring the database size changes back to the Management UI

A Data DSA managed using a Management UI can continue to work even when the Management UI is offline. Recognize this, we can pretend that it is not managed thorugh a Management UI and follow the following article to decrease its database file size:

How to decrease CA Directory database file size

After the database file size has been decrease using the above article, we will have the dxgrid-db-size changed to a value that is smaller than before the change. The next task is to bring this change back to the Management UI repository, otherwise any changes later on involves the same Data DSA will revert the dxgrid-db-size back to before the change. This is because the Management UI repository still retain the original dxgrid-db-size of the Data DSA and changes that require updating the Data DSA will write the original value back out to the configuration file. To bring the new dxgrid-db-size back, following the following steps:

1. Login to the Management UI
2. Locate the Management UI Environment that is managing the Data DSA .
3. Record all the DXagents known as hosts in the Management UI Environment
4. Take an online backup for the Management UI DSA.
5. Delete the Management UI Environment object without changing/deleting any objects in it.
6. Re-create the same Management UI Environment using the same attributes.
7. Add he same set of the DXagents (hosts) back to cause the new dxgrid-db-szie to be pulled from the configuration files back to the Management UI repository along with all the other details.

Even though the above steps in a way is a workaround to the task at hand, administrators can actually create custom RestAPI scripts to help automate the steps.