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.
This section explains how to create the WebFOCUS Repository.
Caution:
To create the Repository tables:
/installation_directory/ibi/WebFOCUS80/Utilities/WFReposUtil
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):
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.
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:
/installation_directory/ibi/WebFOCUS80/ReportCaster/bin/classpath
/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.
WebFOCUS |