10.5.1 Setting up the Item storage database in a cluster environment

To set up 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. Enter the required setup information in the configuration file for setting up an Item storage database.

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

5. Make sure that the shared disk has at least 128 GB of free space.

6. On the primary node, execute the jssitemstoredbsetup.bat command to set up 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 jssitemstoredbsetup.bat command with the -c online option specified to set up the Item storage database on the primary node. For details on the jssitemstoredbsetup.bat command, see jssitemstoredbsetup.bat (sets up an Item storage database) in Chapter 12. Commands.

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

   Use the cluster software to switch the nodes.

8. On the standby node, execute the jssitemstoredbsetup.bat command to set up 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 jssitemstoredbsetup.bat command with the -c standby option specified to set up the Item storage database on the standby node. For details on the jssitemstoredbsetup.bat command, see jssitemstoredbsetup.bat (sets up an Item storage database) in Chapter 12. Commands.

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

   Use the cluster software to switch the nodes.

To Page Top