Other ibi WebFOCUS Repository Utilities and Tasks

This section describes lesser used WebFOCUS Repository related information, utilities, and tasks.

ibi WebFOCUS Repository Table Creation

The table creation utility creates or drops and creates all repository tables. To drop and re-create only specific table groups, you can use utilities available with your database software. This is useful if you wish to remove all library data, but keep your schedules and address books.

Changing the ibi WebFOCUS Repository

If you wish to change repositories, you must adjust the connection parameters:

  • CLASSPATH. The parameter that specifies the location of the JDBC driver used for the selected WebFOCUS database.
  • JDBC CLASS. Stored in install.cfg parameter: IBI_REPOS_DB_DRIVER
  • JDBC URL. Stored in install.cfg parameter: IBI_REPOS_DB_URL
  • Credentials. Stored in install.cfg parameters: IBI_REPOS_DB_USER and IBI_REPOS_DB_PASSWORD
  • Update the JDBC path stored in \utilities\sertenv\utiluservars.bat\utilities\sertenv\utiluservars.sh

If you are using the same database server and just wish to change repositories, you normally only need to change the JDBC URL or credentials. If you are moving between database types (going from WebFOCUS to Db2), you must also adjust the JDBC CLASS and change the driver in CLASSPATH.

Change Connection Information

    Procedure
  1. Ensure the JDBC driver for the new database server is installed on the WebFOCUS Client and the Distribution Server machines.

    The JDBC driver information is stored in the drive:\utilities\setenv\utilsetvars.bat file under the JDBC_PATH parameter.

    Note: The value must be enclosed in double quotation marks (") if the path contains a space.

  2. If this is a different driver, add the JDBC driver path to the CLASSPATH of the application server.

    For example, for Apache Tomcat, you can use the Start menu by selecting Tomcat Configuration Utility, under the Information Builders app. Then, select the Java tab and add a semicolon (;) plus the full path of the file to the end of the Java Classpath field.

  3. Restart your application server.
  4. Modify the install.cfg file and provide updated values for JDBC CLASS, JDBC URL, and Credentials.

    Note: The database password will get encrypted after restarting the application server.

  5. Optionally, sign in to the WebFOCUS Administration Console to review repository configuration information.
  6. Click the Configuration tab, expand Application Settings, and then select Repository.

    The Repository pane opens, as shown in the following image.

    This allows you to see the values entered for the following:

    • Database Driver
    • Database URL
    • Database User ID
    • Database Password

    Only the Database Password can be changed through the Administration Console. The password will get encrypted and written to the install.cfg file.

  7. If this is a different driver, update the JDBC driver path to the following ReportCaster configuration file: 
    drive:\ibi\WebFOCUS93\ReportCaster\bin\classpath.bat

    and to the following value in the registry:

    \HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Apache Software Foundation\Procrun 2.0\WF93\Parameters\Java\Classpath
  8. Restart the WebFOCUS web application and the Distribution Server.

    Note: You do not have to restart the entire application server which may have other applications deployed on it.