12.6 Database maintenance (cluster configuration)

To optimize a JP1/AO database, execute the hcmdsdbtrans and ajsembdbrorg commands to reorganize the database.

Important note

When a task is archived automatically, free segments of a database are reclaimed. Fragmentation that cannot be resolved by reclaiming free segments of a database can be resolved by reorganizing that database. Consider reorganizing the database when JP1/AO is stopped for regular maintenance, or once a year.

For details about how to reorganize a database, see Database maintenance (non-cluster configuration).

For details about the time when tasks are archived automatically, see Property file (config_user.properties) in the Job Management Partner 1/Automatic Operation Configuration Guide.

Tip

Commands beginning with ajs are stored in the storage location folder of the system file for the task processing engine. For details, see List of folders in the Job Management Partner 1/Automatic Operation Configuration Guide. Specify AJSROOT1 for the -F option of the commands that will execute.

Who can perform this task:

Domain user with Administrator permissions for the OS and administration permission for the cluster

To perform a database maintenance (cluster configuration):

1. Make sure that there are no tasks in In Progress, Waiting for Response, Abnormal Detection, or Terminated status. If there are such tasks in the system, either stop the tasks, or wait until they enter Completed or Failed status.

2. Take the following services and scripts registered in the cluster software offline:

   • stopcluster command

   • HAutomation Engine logical-host-name

   • HAutomation Engine Web Service

   • Services of Hitachi Command Suite products

   • HiRDB/ClusterService _HD0

   • HBase Storage Mgmt Web Service

   • HBase Storage Mgmt Common Service

3. Start the database by executing the hcmdsdbsrv command with the /start option specified.

4. Export the JP1/AO database by executing the hcmdsdbtrans command with the following options specified:

   • /export option

   • /workpath option

     Specify the path of the work folder.

   • /file option

     Specify the path for the archive file.

5. Import the JP1/AO data by executing the hcmdsdbtrans command with the following options specified:

   • /import option

   • /type option

     Specify Automation.

   • /workpath option

     Specify the path of the work folder.

   • /file option

     Specify the path of the archive file.

6. In the service manager, start HAutomation Engine Database _JF1.

7. Start the database of the task processing engine by executing the ajsembdbstart command with the following option specified:

   • -id option

     Specify _JF1.

8. Execute the ajsembdbreclaim command to reclaim free segments.

   ajsembdbreclaim -m scheduler -F AJSCLUSTER -mh logical-host-name

9. Execute the ajsembdbrorg command to reorganize the database.

   Secure the required free space in the folder that will be specified for the -d option of the ajsembdbrorg command, and then execute the ajsembdbrorg command in the following order:

   1. ajsembdbrorg -k unld -F AJSCLUSTER -mh logical-host-name -d arbitrary-folder^#

   2. ajsembdbrorg -k reld -F AJSCLUSTER -mh logical-host-name -d arbitrary-folder^#

   #

   To use the data obtained using ajsembdbrorg -k unld to execute ajsembdbrorg -k reld, specify the two folders identically.

   Important note

   If an error occurs during execution of ajsembdbrorg -k unld and a file is created, do not use the file to execute ajsembdbrorg -k reld. If you do so, the database might be corrupted.

10. Stop the database by executing the hcmdsdbsrv command with the /stop option specified.

11. Bring the following services and scripts registered in the cluster software online:

    • stopcluster command

    • HAutomation Engine logical-host-name

    • HAutomation Engine Web Service

    • HBase Storage Mgmt Web Service

    • HBase Storage Mgmt Common Service

    • Services of Hitachi Command Suite products

    • HiRDB/ClusterService _HD0

The JP1/AO database and the task-processing engine database are reorganized.

Important note

If the database is damaged and cannot be repaired by the restoresystem and hcmdsdbtrans commands, use the hcmdsdbrepair command to restore the database.

Related topics

• 1.6.9 Archiving tasks and removing histories automatically

• ajsembdbrorg command in the Job Management Partner 1/Automatic Job Management System 3 Command Reference 1

To Page Top