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 when any of the databases is corrupted and the restoresystem and hcmdsdbtrans commands 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.

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

• 8.3 Valid characters for arguments in a command
• 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)