Hitachi

JP1 Version 12 JP1/Service Support Configuration and Administration Guide


10.5.2 Expanding the Item storage database in a cluster environment

To expand the capacity of the Item storage database in a cluster environment:

  1. Switch the active node to the primary node.

    Use the cluster software to switch the nodes. You can skip this step if the primary node is already the active node.

  2. On the primary node, stop the services in the following order:

    • JP1/Service Support - Task Service service

    • JP1/Service Support - Web Service service

    • JP1/Service Support service

    Leave the JP1/Service Support - DB Server service and JP1/Service Support - DB Cluster Service service running.

  3. On the primary node, execute the jssdbbackup.bat command to back up the Item management database and Item storage database for recovery purposes.

    From the Start menu, select Programs, JP1_Service Support, and then JP1_SS Command Prompt. From the command prompt, execute the jssdbbackup.bat command with the -maint option specified to back up the Item management database and Item storage database. For details on the jssdbbackup.bat command, see jssdbbackup.bat (backs up databases) in Chapter 12. Commands.

    You can skip this step if a backup is already available.

  4. On the primary node, execute the jssdbstatchk.bat command to find out how many times the Item storage database has been expanded, and the location of its storage directories.

    For details on the jssdbstatchk.bat command, see jssdbstatchk.bat (checks the database status) in Chapter 12. Commands.

  5. Enter the required settings in the configuration file for expanding an Item storage database.

    For details on the configuration file for expanding an Item storage database, see Configuration file for expanding an Item storage database (jssitemstoredbexpandinfo.bat) in Chapter 13. Definition Files.

  6. Make sure that the shared disk has at least 64 GB of free space.

  7. On the primary node, execute the jssitemstoredbexpand.bat command to expand the capacity of the Item storage database.

    From the Start menu, select Programs, JP1_Service Support, and then JP1_SS Command Prompt. From the command prompt, execute the jssitemstoredbexpand.bat command with the -c online option specified to expand the database capacity on the primary node. You can expand the database to the desired size by executing the command multiple times. For details on the jssitemstoredbexpand.bat command, see jssitemstoredbexpand.bat (expands an Item storage database) in Chapter 12. Commands.

  8. Switch the active server from the primary node to the standby node.

    Use the cluster software to switch the nodes.

  9. On the secondary node, execute the jssitemstoredbexpand.bat command to expand the capacity of the Item storage database.

    From the Start menu, select Programs, JP1_Service Support, and then JP1_SS Command Prompt. From the command prompt, execute the jssitemstoredbexpand.bat command with the -c standby option specified to expand the database capacity on the secondary node. For details on the jssitemstoredbexpand.bat command, see jssitemstoredbexpand.bat (expands an Item storage database) in Chapter 12. Commands. Even if you expanded the database multiple times in step 7, you only need to execute the command once in this step.

  10. Switch the active server back to the primary node.

    Use the cluster software to switch the nodes.