7.9 Database maintenance (Linux 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 a 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 root permission for the OS and cluster management permission
To perform database maintenance (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.
Take the following resources offline in the cluster software:
Common component database
HBase 64 Storage Mgmt SSO Service
HBase 64 Storage Mgmt Web SSO Service
HBase 64 Storage Mgmt Web Service
HAutomation Engine Web Service
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.
Stop the database by executing the hcmds64dbsrv command with the stop option specified.
In the cluster software, place the following resources online:
Common component database
HBase 64 Storage Mgmt SSO Service
HBase 64 Storage Mgmt Web SSO Service
HBase 64 Storage Mgmt Web Service
HAutomation Engine Web Service
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.