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

Top of page

WebFOCUS Repository Table Creation

This section explains how to create the WebFOCUS Repository.


Top of page

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:
  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:


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


    • If the utility cannot connect to the database, ensure that the proper path to the JDBC driver appears in the following CLASSPATH value:
    • If the WebFOCUS installation program installed and configured Derby, this driver may be located as follows:

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


      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.