WebFOCUS Repository Post-Installation Tasks

In this section:

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 then see the WebFOCUS Security and Administration manual.


Top of page

x
WebFOCUS Repository Table Creation

This section explains how to create the WebFOCUS Repository.

Caution:


Top of page

x
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/WebFOCUS80/Utilities/WFReposUtil
  3. Execute the following command:
    sh WFReposUtilCMDLine.sh

    The following prompt is displayed:

    Please select mode option for WFReposUtil:
    1\) create             - create non-existing tables
    2\) insert             - insert data into tables.
    3\) create_insert      - combo of above
    4\) update             - update table data
    5\) drop               - drop tables
    6\) drop_create        - drops and recreates tables
    7\) drop_create_insert - drop, create, and insert
    8\) extract            - export database data to xml files
    9\) create_ddl         - generate SQL scripts but not execute them
    Q\) To Quit
        Enter selection (default:3):
  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.

    If you want to begin using WebFOCUS and do not want to migrate from a previous version, but your repository contains data that is no longer required and can be discarded, select option 7.

    Alert: Selecting option 7 will delete all existing repository content.

    The other options typically apply when you intend to migrate from another WebFOCUS release. For more information, see the WebFOCUS Migration Guide.

    Note: If you intend to use WebFOCUS, but will not migrate from a previous version, you must choose an option that will load initial values into the WebFOCUS Repository.

  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/WebFOCUS80/Utilities/WFReposUtil

    This utility uses the connection and logon 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/WebFOCUS80/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