7.8 Database maintenance (Windows 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:
Domain users who have Administrators 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 services and scripts offline in the cluster software:
HAutomation Engine Web Service
Services associated with Hitachi Command Suite products
HiRDB/ClusterService _HD1
HBase 64 Storage Mgmt Web Service
HBase 64 Storage Mgmt SSO Service
HBase 64 Storage Mgmt Web SSO 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 services and scripts online:
HAutomation Engine Web Service
HBase 64 Storage Mgmt Web Service
HBase 64 Storage Mgmt SSO Service
HBase 64 Storage Mgmt Web SSO Service
Services associated with Hitachi Command Suite products
HiRDB/ClusterService _HD1
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.