9.4 Extending the size of the Item management database in a cluster system

To extend the size of the Item management database in a cluster environment:

1. Switch the active server from the secondary node to the primary node.

   Switch the nodes by using the cluster software. This operation is not necessary if the primary node is already running as the active server.

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

   • JP1/Service Support - Task Service

   • JP1/Service Support - Web Service

   • JP1/Service Support

   Keep JP1/Service Support - DB Server running.

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

   From the Start menu, select Programs, JP1_Integrated Management - Service Support, and then JP1_IM-SS Command Prompt. Execute the jssdbbackup.bat command with the -maint option specified as an argument to back up the Item management database. For details on the jssdbbackup.bat command, see jssdbbackup.bat (backs up databases) in Chapter 11. Commands.

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

   From the Start menu, select Programs, JP1_Integrated Management - Service Support, and then JP1_IM-SS Command Prompt. Execute the jssdbbackup.bat command with the -expand option specified as an argument to back up the Item management database. For the -f option, specify a backup file name that is different from the one specified in step 3. For details on the jssdbbackup.bat command, see jssdbbackup.bat (backs up databases) in Chapter 11. Commands.

5. On the primary node, use the cluster software to stop the services in the following order:

   • JP1/Service Support - DB Server

   • JP1/Service Support - DB Cluster Service

6. On the primary node, execute the jsshadbinit.bat command to extend the size of the Item management database.

   For details on the jsshadbinit.bat command, see jsshadbinit.bat (initializes the database in a cluster environment) in Chapter 11. Commands.

7. From Service Control Manager on the primary node, stop the JP1/Service Support - DB Server service on the Item management database server.

8. On all secondary nodes, execute the jsshasetup.bat command for setup.

   Switch each of the secondary nodes to the active node, and then execute the jsshasetup.bat command with the -c standby option specified as an argument. For details about the jsshasetup.bat command, see jsshasetup.bat (sets up JP1/IM - Service Support in a cluster environment) in Chapter 11. Commands.

9. From Service Control Manager on the secondary node, stop the JP1/Service Support - DB Server service on the Item management database server.

10. On the primary node, use the cluster software to start services in the following order:

    • JP1/Service Support - DB Cluster Service

    • JP1/Service Support - DB Server

11. On the primary node, execute the jssdbrecovery.bat command to recover the backup file obtained in step 4.

    Execute this command with the -expand option specified as an argument. For details on the jssdbrecovery.bat command, see jssdbrecovery.bat (recovers a database) in Chapter 11. Commands.

12. On the primary node, execute the jssrefaclsetup command.

    Set up the function that sets view permissions for individual Items. You can skip this step if you do not intend to use this function. For details on the jssrefaclsetup command, see jssrefaclsetup (sets up view permission settings for individual Items) in Chapter 11. Commands.

To Page Top