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):
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.
Shut down the JP1/AO system by executing the hcmds64srv command with the stop option specified.
Start the database by executing the hcmds64dbsrv command with the start option specified.
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.
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.
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.