Job Management Partner 1/Integrated Management - Manager Administration Guide

1.2.1 Database reorganization

Organization of this subsection

(1) Reorganization of the command execution log

(2) Reorganization of the monitored object database and the host information database

(3) Reorganization of the event database

(4) Reorganization of the IM database

(1) Reorganization of the command execution log

There is no need to reorganize the command execution log.

(2) Reorganization of the monitored object database and the host information database

There is no need to reorganize the monitored object database or the host information database.

(3) Reorganization of the event database

There is no need to reorganize the event database.

(4) Reorganization of the IM database

This subsection explains the procedure for reorganizing the IM database.

When data is repeatedly added or deleted, fragmented free spaces are created in the IM database. This condition may prevent new registration even before the number of hosts or properties reaches its upper limit, or you may find that registration, updating, and deletion take an excessively long time.

To prevent such things from happening, reorganize the IM database at a time such as the following:

When JP1/IM - Manager is stopped for regular backup operations

During annual creation and implementation of a reorganization execution plan

When the message KFPH00212-I or KFPH00213-W is output to the integrated trace log or Windows Event Log (syslog)

If new registration is prevented even before the number of hosts or properties has reached its upper limit, or if you find that registration, updating, and deletion are taking an excessively long time, use the following procedure to release free space in the database.

To release the free space in the database:

Using the jimdbreclaim command, release the free space in the database.

Check whether any host information or profiles registered in the IM database are unnecessary, and delete those that are not needed.

If this procedure does not eliminate the occurrence of problems, you need to reorganize the IM database. The following describes the procedures for reorganizing the IM database on a physical host, and in a cluster environment.

(a) Reorganizing the IM database on a physical host

To reorganize the IM database on a physical host:

Stop the JP1/IM - Manager service.

Using the jimdbrorg command, reorganize the database.
For details about the jimdbrorg command, see jimdbrorg (1. Commands) in the manual Job Management Partner 1/Integrated Management - Manager Command and Definition File Reference.

Start the JP1/IM - Manager service.

(b) Reorganizing the IM database in a cluster environment

In a cluster environment, execute the reorganization process on the executing host. Furthermore, the shared directory must be accessible.

To reorganize the IM database in a cluster environment:

Stop the JP1/IM - Manager service and the cluster database service.

Using the jimdbrorg command, reorganize the database.
For details about the jimdbrorg command, see jimdbrorg (1. Commands) in the manual Job Management Partner 1/Integrated Management - Manager Command and Definition File Reference.

Start the JP1/IM - Manager service and the cluster database service that you stopped in Step 1.

[Contents][Back][Next]

[Trademarks]