Hitachi

JP1 Version 12 JP1/IT Desktop Management 2 Administration Guide


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

If your computer is running Windows Server 2019, Windows Server 2016 or Windows Server 2012, do not specify the following folders when setting folders.

  • system-drive:\program files\folders-in-WindowsApps

  • Storage folders created by using thin provisioning

Important

When executing database reorganization, if the database are being accessed from Remote Install Manager or JP1/IT Desktop Management 2 - Asset Console, the database reorganization may fail. The following measures should be taken before executing database reorganization.

  • Terminate the remote installation manager.

  • Check whether the command of the distribution function using the Remote Install Manager is not running.

  • Check whether JP1/IT Desktop Management 2 - Asset Console is not acquiring management information.

  1. In the Database Manager view, from Maintenance, click the Reorganize button.

  2. 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.

    [Figure]

  3. Specify a work folder.

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

    Important

    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

  4. 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.27 reorgdb (reorganizing the database).

Related Topics: