Change a JDBC Data Source Configuration

Use the procedures on this page if you must change database connection information for Performance Management Advisors.

Advisors Platform and the Metric Graphing Data Source

There are two modules that contain JDBC data source configuration information for Advisors Platform and metric graphing:

• com.informiam.platform/platform-datasource-service/<version>/rar
• com.informiam.ea/metric-graphing-datasource/<version>/rar

There is no FA data source starting in release 8.5.0; earlier releases of Advisors included an FA data source.

You must re-deploy each instance of the preceding modules for which you modify the geronimo-ra.xml descriptor (see the following procedures).

Before you perform either of the procedures below, read the following carefully:

• Perform the following procedures offline; Geronimo must be fully stopped.
• After you stop Geronimo, Genesys recommends that you take a complete directory backup of <GCTI>/Advisors/ before you do any manual operations.
• Ensure that the Advisors service is not running.

Procedure: Changing Database Connection Parameters for Advisors Platform

Steps

1. Copy geronimo-ra.xml from
   **/GCTI/Advisors/geronimo-tomcat6-minimal-2.2.1/repository/com/ informiam/platform/platform-datasource-service/<version>/platform- datasource-service-<version>.rar/rar/META-INF
   to
   **/GCTI/Advisors/platform-datasource.
2. Edit the descriptor (geronimo-ra.xml that you copied to **/GCTI/Advisors/platform-datasource), as required.
3. Ensure the Advisors service is stopped before proceeding.
4. Open a command prompt window.
5. Navigate to the **/GCTI/Advisors/geronimo-tomcat6-minimal-2.2.1/bin directory.
6. Run the following command:
   java -jar deployer.jar --offline --user system --password manager redeploy ../../platform-datasource/platform-datasource.rar ../../platform-datasource/geronimo-ra.xml
   In the preceding command line, ../../platform-datasource/geronimo-ra.xml is the path to the recently-edited descriptor.
7. Start the Advisors service and verify that the reconfigured data source works.
8. If the database parameters require further updates, edit the data source descriptor file and run the command again to re-deploy it. For example:
   Edit ../../platform-datasource/geronimo-ra.xml and run the command again.

Procedure: Changing Database Connection Parameters for the Metric Graphing Data Source

Steps

1. Copy geronimo-ra.xml from
   **/GCTI/Advisors/geronimo-tomcat6-minimal-2.2.1/repository/com/Informiam/ea/metric-graphing-datasource/<version>/ metric-graphing-datasource-<version>.rar /rar/META-INF
   to
   **/GCTI/Advisors/metric-graphing-datasource.
2. Edit the descriptor (geronimo-ra.xml that you copied to **/GCTI/Advisors/metric-graphing-datasource), as required.
3. Ensure the Advisors service is stopped before proceeding.
4. Open a command prompt window.
5. Navigate to the **/GCTI/Advisors/geronimo-tomcat6-minimal-2.2.1/bin directory.
6. Run the following command:
   java -jar deployer.jar --offline --user system --password manager redeploy ../../metric-graphing-datasource/metric-graphing-datasource.rar ../../metric-graphing-datasource/geronimo-ra.xml
   In the preceding command line, ../../metric-graphing-datasource/geronimo-ra.xml is the path to the recently-edited descriptor.
7. Start the Advisors service and verify that the reconfigured data source works.
8. If the database parameters require further updates, edit the data source descriptor file and run the command again to re-deploy it. For example: Edit ../../metric-graphing-datasource/geronimo-ra.xml and run the command again.

Changing Database Connection Parameters for CCAdv XML Generator

You can change the database connection information for XML Generator after installation. The XML Generator database connection information is located in the following file:

• conf/XMLGen.properties

See also Modifying the XML Generator Configuration for information about ensuring XML Generator works properly with the metrics database.

Changing Database Connection Parameters for Advisors Genesys Adapter

You can change the database connection information for Advisors Genesys Adapter after installation. The Advisors Genesys Adapter database connection information is located in the following files:

• conf\inf_genesys_adapter.properties
• conf\inf_genesys_importer.properties

Changing Database Connection Parameters for Advisors Cisco Adapter

You can change the database connection information for Advisors Cisco Adapter after installation. The Advisors Cisco Adapter database connection information is located in the following file:

• conf\cisco_adapter.properties