Hitachi

JP1 Version 12 JP1/Service Support Configuration and Administration Guide


11.2.15 Recovery procedure when the Item storage database is used

You need to recover the Item storage database to the environment in which the database was backed up. If you recover the Item storage database and Item management database separately, data inconsistency such as duplication or loss of registered Items might occur. The following describes the recovery procedures to resolve such problems.

Organization of this subsection

(1) How to recover the environment when using the Item storage database

The extension conditions of the Item storage database to be recovered must match the extension conditions (number of extensions, setup information, and the directory where the database is expanded) specified when the database was backed up.

To recover the extension conditions of the Item storage database when the database was backed up:

  1. Stop the JP1/Service Support services.

    Stop all the JP1/Service Support services.

  2. From the Start menu, select Programs, JP1_Service Support, and then JP1_SS Command Prompt.

  3. Execute the jssdbstatchk.bat command.

    Execute the jssdbstatchk.bat command to check the statuses of the Item management database and the Item storage database. For details about the jssdbstatchk.bat command, see jssdbstatchk.bat (checks the database status) in Chapter 12. Commands.

  4. Check the extension conditions of the Item management database and Item storage database.

    Based on the statuses of the databases you checked in step 3 and the dbpath.txt file created during backup, make sure that the current environment matches the environment where the database was backed up. The dbpath.txt file is stored in the backup file output directory for the Item storage database.

  5. Extend the domain of the Item storage database.

    If the number of extensions for the Item storage database is different in the environments compared in step 4, expand the Item storage database to match the expansion conditions when the database was backed up. The expansion conditions include the number of expansion s and the path to the directory where the database is expanded. For details about how to expand the Item storage database, see 11.2.12 Expanding the Item storage database.

    If the path to the directory in which the Item storage database is created or the path to the directory where the database is expanded does not match, delete the Item storage database. Then re-create the Item storage database in the same environment where the database was backed up. For details about how to delete the Item storage database, see jssunsetup.bat (performs unsetup of JP1/Service Support) in Chapter 12. Commands. For details about how to re-create the Item storage database, see 11.2.10 Setting up the Item storage database.

(2) How to recover databases when the Item storage database is used

You can separately recover the Item management database and Item storage database. However, if you use different backup files (created before or after Items were stored) to recover each database, data inconsistency such as duplication or loss of registered Items might occur. To recover the Item storage database, specify the backup file for the Item management database. At this time, make sure that the backup file is created after a backup file was created for the Item storage database to be recovered and before Items are stored the next time. The following figure shows the combinations of backup files that do not cause data inconsistency during recovery of the Item storage database.

Figure 11‒2: Combinations of backup files that do not cause data inconsistency during recovery of the Item storage database

[Figure]

To recover the Item storage database by using Item management database backup file 4 and Item storage database backup file 1 in the above figure:

  1. Stop services in the following order:

    • JP1/Service Support - Task Service service

    • JP1/Service Support - Web Service service

    • JP1/Service Support service

    Do not stop JP1/Service Support - DB Server service.

  2. From the Start menu, select Programs, JP1_Service Support, and then JP1_SS Command Prompt.

  3. Execute the jssdbrecovery.bat command.

    Recover the Item management database and the Item storage database in a batch based on Item management database backup file 2 and Item storage database backup file 1. Specify the -i and -ALL options as arguments. For details about the jssdbrecovery.bat command, see jssdbrecovery.bat (recovers a database) in Chapter 12. Commands.

  4. Execute the jssdbrecovery.bat command.

    Recover the Item management database based on Item management database backup file 4. Specify the -i and -mdb options as arguments. For details about the jssdbrecovery.bat command, see jssdbrecovery.bat (recovers a database) in Chapter 12. Commands.