16.4 Reorganizing databases

This chapter describes how to reorganize a database by using a database manager.

Tip: To reorganize a database, you must stop the management server. Therefore, choose a day or time of day for the reorganization that is during a time when the management server is not used.

Tip: The time required for reorganization depends on the disc capacity. The dialog box that indicates that reorganization is being processed displays the elapsed time, which you can use to measure the progress status.

Important note

If you are using a Windows 8 computer, do not specify the following folders when setting the folders:

In the Database Manager view, from Maintenance, click the Reorganize button.
In the Database Reorganization view, select a range that you want to reorganize.

If All is selected:

All data in the database will be reorganized.

If Select a range is selected:

Select the items that you want to reorganize. Database usage is displayed for each item. Items with 80% or more database usage are automatically selected.
Specify a work folder.

Specify for Temporary Folder a work folder to be used during reorganization.

Important note

For Temporary Folder, if 10,000 devices are managed, specify a folder on a local drive that has at least 30 GB of free space. If you specify a folder on a network drive, the reorganization will fail. If you are using a cluster configuration, specify a folder on a shared disk.

If you have reorganized the database before, the work folder specified for the previous time is displayed.

If specifying a work folder directly, use a character string not exceeding 150 single-byte characters, which can consist of alphanumeric characters, spaces, and the following symbols:

Sharp signs (#), brackets (( and )), periods (.), @, backslashes (\)

# ( ) . @ \

By default, the following folder is specified:

All User profile application data folder\Hitachi\jp1itdmm
Click the Execute button.

A dialog box that shows the processing status is displayed until reorganization is complete.

The reorganization is complete.

Tip: You can also reorganize a database by using the reorgdb command. For details about the reorgdb command, see 17.25 reorgdb (reorganizing the database).

Related Topics: