Hitachi

JP1 Version 12 JP1/Automatic Operation Administration Guide 


7.7 Database maintenance (non-cluster configuration)

To ensure that the JP1/AO database remains optimized, you need to use the hcmds64dbtrans command to reorganize the database.

Important
  • JP1/AO reclaims free segments of the database when it automatically archives tasks. Fragmentation that cannot be resolved by the day-to-day reclamation of free segments can be remedied by reorganizing the database. Consider reorganizing the database when JP1/AO is stopped for regular maintenance, or on a regular schedule such as once a year.

  • For details on the timing with which tasks are automatically archived, see the topic on the user-specified properties file (config_user.properties) in the JP1/Automatic Operation Configuration Guide.

Who can perform this task:

Users who have Administrators or root permission for the OS

To perform database maintenance (non-cluster configuration):

  1. Make sure that there are no tasks in execution status (In Progress, Waiting for Input, In Progress (with Error), In Progress (Terminating), or Long Running). If there are such tasks in the system, either stop the tasks, or wait until they enter Completed or Failed status.

  2. Shut down the JP1/AO system by executing the hcmds64srv command with the stop option specified.

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

  4. Export the JP1/AO database by executing the hcmds64dbtrans 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 database by executing the hcmds64dbtrans 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 for the archive file.

  6. Start the JP1/AO system by executing the hcmds64srv command with the start option specified.

Result of operation:

The JP1/AO database is reorganized.

Important

If the database is corrupted and cannot be repaired by the restoresystem and hcmds64dbtrans commands, use the hcmds64dbrepair command to repair the database.