Adding an installed APS to a cluster

In these steps, the independent APS refers to the one that you want to add to a cluster. You will add the independent APS to your production APS cluster. By adding an independent APS to a cluster, you disconnect the independent APS from its own database and instruct it to share the system database that belongs to your production APS.

Before starting this procedure, ensure that you have a database user account with Create, Delete, and Update rights to the database storing the Crystal Enterprise tables. Ensure also that you can connect to the database from the machine that is running the independent APS (through your database client software or through ODBC, according to your configuration).

Note:    Back up your current APS database before beginning this procedure. If necessary, contact your database administrator.

To add an installed APS to a cluster on Windows

1. Use the CCM to stop the independent Crystal APS.
2. With the APS selected, click Specify APS Datasource on the toolbar.

   The APS Database Setup dialog box appears.

   

3. Click Select a Data Source; then click OK.
4. In the Select Database Driver dialog box, specify whether you want to connect to the production APS database through ODBC, or through one of the native drivers.
5. Click OK.
6. The remaining steps depend upon the connection type you selected:
   • If you selected ODBC, the Windows "Select Data Source" dialog box appears. Select the ODBC data source that corresponds to your production APS database; then click OK. If prompted, provide your database credentials and click OK. The CCM connects to the database server and adds the new APS to the cluster.
   • If you selected a native driver, you are prompted for your database Server Name, your Login ID, and your Password. Once you provide this information, the CCM connects to the database server and adds the new APS to the cluster.

     The SvcMgr dialog box notifies you when the APS database setup is complete.

7. Click OK.
8. Start the Crystal APS.

To add an installed APS to a cluster on UNIX

Use the apsdbsetup.sh script. For reference, see apsdbsetup.sh.