8.7.2 hcmdsdbrepair (re-creating the database)
Description
This command forces all the databases to be deleted, re-creates them, and then recovers them using the backup data obtained by the hcmdsdbtrans command. You use this command if any of the databases is corrupted and using the restoresystem command and the hcmdsdbtrans command with the /import option specified cannot restore the database.
Syntax
hcmdsdbrepair /trans backup-data
Arguments
- /trans backup-data
-
This option specifies the backup data obtained using the hcmdsdbtrans command. Make sure that you specify the path specified in the /workpath or /file option of the hcmdsdbtrans command.
Located in
Common-Component-installation-folder\bin
Execute permission
Execute the command as a user with Administrator permissions.
Remarks
-
Stop the JP1/AO system before executing the hcmdsdbrepair command.
-
Start the JP1/AO system after executing the hcmdsdbrepair command.
-
The command uses the Common-Component-installation-folder\tmp hcmdsdbrepair folder to extract the backup data. Make sure that the hard drive has enough space to extract the backup data depending on the size of the data.
-
After the command execution, the password of the built-in account (System account) is initialized. Change the password if necessary.
-
In a cluster system, execute this command on the executing host. This command cannot be executed on the standby host.
Return code
The following table lists the return codes from the command.
Return code |
Description |
---|---|
0 |
The command succeeded. |
1 |
The argument is invalid. |
245 |
Importing the database failed. |
246 |
The definition file is invalid. |
247 |
An attempt to undo setup of the database failed. |
248 |
Stopping a service or database failed. |
249 |
The command cannot be executed on the standby node. |
250 |
The backup data is invalid. (Some files are missing or extracting the archive file failed.) |
251 |
The command has been interrupted due to inconsistency in the product or product version. |
252 |
Setting up the database failed. |
253 |
Starting the service for database failed. |
254 |
The database cannot be re-created due to its incomplete setup. |
255 |
The command terminated abnormally. |
Example
The following command shows an example of how to force all the databases to be deleted, re-create them, and then recover them using backed up data:
hcmdsdbrepair /trans C:\bkfile1
Related topics
-
Topic Starting a JP1/AO system (non-cluster configuration) in the Job Management Partner 1/Automatic Operation Administration Guide
-
Topic Starting a JP1/AO system (cluster configuration) in the Job Management Partner 1/Automatic Operation Administration Guide
-
Topic Stopping a JP1/AO system (non-cluster configuration) in the Job Management Partner 1/Automatic Operation Administration Guide
-
Topic Stopping a JP1/AO system (cluster configuration) in the Job Management Partner 1/Automatic Operation Administration Guide
-
8.6.3 hcmdssrv (starting and stopping JP1/AO, and displaying the status of JP1/AO)