How can I reduce the size of my DXgrid datastore?

Products

• CA Directory

Issue/Introduction

Should you find that the current size of your DXgrid datastore is too large, and contains a lot of free space, there is a method that you can use to reduce its size.

Resolution

Assuming DSA name is ‘democorp’, the process to reduce the size of a DXgrid datastore is:

1. Stop the DSA (i.e. dxserver stop dsaName)
   Example: dxserver stop democorp
2. Dump the datastore to LDIF (i.e. dxdumpdb -f {filename}.ldif dsaName)
   Example: dxdumpdb -f democorp.ldif democorp
3. Edit the DSAs initialization file to edit the "dxgrid-db-size" to reduce it to what they want, and save the file.
   Example: %DXHOME%\config\servers\democorp.dxi (on Windows) and $DXHOME/config/servers/democorp.dxi (on Linux/UNIX)
   Note: The size is specified in MB
4. Reload the data using DXloaddb along with '-s' option (i.e. dxloaddb -s dsaName {filename}.ldif)
   Example: dxloaddb -s democorp democorp.ldif

When the data is reloaded, the datastore will be the new size.