Reclaiming Disk Space in CentraSite Database
To reclaim space in the CentraSite internal database through the CentraSite Command Line (.cmd) Interface, you must have the CentraSite Administrator role.
Within the CentraSite internal database a considerable amount of data may be stored temporarily, for example, log data that is purged regularly or metrics data stored by other webMethods sub systems. When such data is stored the space required for the database increases. However, after deleting such data the space allocated remains. Although the allocated space is re-used when additional data of the same type is stored again, the administrator may prefer to reorganize the database so that unused space can be reclaimed.
CentraSite provides a command tool named reorganize for this purpose.
The tool reduces the disk space by returning blocks that are no longer used to the file system.
The reorganize function uses a temporary backup to defragment the free space. Thus it is a pre-requisite that the space required for one CentraSite backup is available on the backup location. This temporary backup is deleted when the reorganize function completes successfully.
Important: The command tool can be used only on an inactive database. Attempting to reorganize an active database is not allowed.
To reclaim database space
1. Stop the database you want to reorganize.
2. Ensure that there is enough space on the database backup location to hold one full backup of the CentraSite database. This space is required because the reorganize command creates a temporary backup while it defragments the database. The temporary backup is deleted when the reorganize command completes successfully.
3. To check the available free disk space, run the command reorganize with evaluate parameter.
The syntax is of the format: inoadmin reorganize <server> evaluate
Example:
inoadmin reorganize CentraSite evaluate
The output from this command shows the current amount of free disk space.
INODSI1183: 161.84 MB empty data space found.
4. To start database reorganization, run the command reorganize.
The syntax is of the format: inoadmin reorganize <server>
Example:
inoadmin reorganize CentraSite
5. If the reorganize command completes successfully, restart the database.