To reorganize an Embedded RDB database in a cluster system environment:

1. Place the following generic-service resources offline:
   
   • Asset Information Synchronous Service^#
   • Microsoft Internet Information Services^#
   • Remote Install Server
2. Using Database Manager, reorganize the database from Reorganize the database.
   For details about Database Manager, see 7.4.6 Reorganizing the database in the manual Setup Guide.
   
3. Place the following generic-service resources online:
   
   • Remote Install Server
   • Microsoft Internet Information Services^#
   • Asset Information Synchronous Service^#

#: This item is required when Asset Information Manager Subset is used.

If you use a Microsoft SQL Server or Oracle relational database, see the RDBMS documentation for details about reorganizing the database.

This subsection describes how to upgrade a database in a cluster system environment. You must upgrade the databases on both the active server and the standby server.

To upgrade a database:

1. Place the following generic-service resources offline:^#
   
   • Asset Information Synchronous Service
   • Microsoft Internet Information Services
2. Delete the Registry Copy setting for the generic-service resource for Remote Install Server.
3. Place the generic-service resources for Remote Install Server offline.
4. Using Database Manager, upgrade the database from Upgrade database.
   In the Cluster System Environment Settings dialog box, specify the same settings as for new creation.
   If this is a Microsoft SQL Server or Oracle database, go to step 14. Steps 5 through 13 are required for an Embedded RDB database.
   
5. Execute the netmdb_stop.bat command that is stored in JP1/Software-Distribution-Manager-installation-directory \BIN.
   Check the message to make sure that Embedded RDB has terminated.
   
6. Place the generic-service resource for HiRDB/ClusterService_JN1 offline.
7. Execute the jamemb_dbstop.bat command that is stored in JP1/Software-Distribution-installation-directory\jp1asset\exe.^#
   Check the message to make sure that Embedded RDB has terminated.
   
8. Place the generic-service resources for HiRDB/ClusterService_AM1 offline.^#
9. Use the cluster system administrator to move the group and set the owner as the standby server.
10. Place the generic-service resource for HiRDB/ClusterService_JN1 online.
11. On the standby server, perform steps 4 through 8.
12. Use the cluster system administrator to move the group and set the owner as the active server.
13. Place the following generic-service resources online:
    
    • HiRDB/ClusterService_AM1^#
    • HiRDB/ClusterService_JN1
14. Place the generic-service resources for Remote Install Server online.
15. Enter the Registry Copy setting for the generic-service resource for Remote Install Server.
16. Place the following generic-service resources online:^#
    
    • Microsoft Internet Information Services
    • Asset Information Synchronous Service

#: This step is required when Asset Information Manager Subset is used.