Installation > Post-Installation Verification and Configuration > WebFOCUS Repository Post-Installation Tasks

WebFOCUS Repository Post-Installation Tasks

Topics:

How to:

This section explains how to create the WebFOCUS Repository and verify the WebFOCUS Client configuration.

For NLS configuration information, review this section and consult the WebFOCUS Security and Administration manual.

WebFOCUS Repository Table Creation

This section explains how to create the WebFOCUS Repository.

Caution:

  • If you specified an existing repository during the Distribution Server installation, this utility will erase all of its data. If you wish to preserve this information, run the extract utility, as explained in the Migration manual.
  • This utility drops, creates, and/or updates tables using the connection information you specified during the installation. To change this information, see ReportCaster Configuration.

Procedure: How to Create the WebFOCUS Repository Tables

To create the Repository tables:

  1. Ensure that the database server is available and/or started.
  2. From qshell, navigate to the following WebFOCUS Utility directory:
    installation_directory/ibi/WebFOCUS82/Utilities/WFReposUtil
  3. Execute the following command:
    WFReposUtilCMDLine.sh

    The following prompt is displayed: 

    Please select mode option for WFReposUtil:
1\) create            - create non-existing tables
2\) create_or_extend  - create tables or add missing columns to tables
3\) insert            - insert data into tables
4\) create_insert     - combo of above
5\) update            - update table data
6\) drop              - drop tables
7\) extract           - export database data to xml files
8\) create_ddl        - generate SQL scripts but not execute them
Q\) Quit
    Enter selection [default=4] :
  4. Select the default option and press Enter.

    If you are installing WebFOCUS for the first time, select option 3. This will load initial values into the WebFOCUS Repository, which are required to begin using the product. This is the default value.

  5. You are prompted to choose a logging level for the utility
    Please select logging level option for WFReposUtil:
1) off
2) severe
3) warning
4) info
5) config
6) fine
7) finer
8) finest
Q) To Quit

    If selected, the log file named WFReposUtilCmdLine.log will be created in the following directory: 

    /installation_directory/ibi/WebFOCUS82/Utilities/WFReposUtil

    This utility uses the connection and sign-in information provided during the installation of WebFOCUS. The utility creates .sql files that contain the instructions.

    Note:

    • If the utility cannot connect to the database, ensure that the proper path to the JDBC driver appears in the following CLASSPATH value:
      /installation_directory/ibi/WebFOCUS82/ReportCaster/bin/classpath
    • If the WebFOCUS installation program installed and configured Derby, this driver may be located as follows:
      /installation_directory/ibi/derby/lib/derbyclient.jar

      If you are using a DB2 repository, then an appropriate driver may be located as follows: 

      /QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar

      Consult your database documentation for additional information.

    • If you can connect to the database, but cannot create tables, ensure the ID you entered for the database during the WebFOCUS installation has create permissions. You can change this user ID, as explained in WebFOCUS Client Verification and Configuration.

WebFOCUS

Feedback