Procedure
1. Ensure that the database server is available and/or started.
2. From the UNIX shell, navigate to the following WebFOCUS Utilities directory:

   install_directory/ibi/WebFOCUS93/utilities/WFReposUtil

3. Run the following command:

   WFReposUtilCMDLine.sh

   The following prompt displays:

   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. If this is a new installation and you need to create a new WebFOCUS Repository, press Enter to use the default option, 4 create_insert.

   This option will create tables and load initial values into the WebFOCUS Repository, which are required to begin using the product.

5. If you typed option 3, insert, or option 4, create_insert:
   1. When you receive a prompt to enter the Database Repository Username, type the name of a valid user that has permission to create and alter tables in your Database Repository, and then press Enter.
   2. When you receive a prompt to enter the Database Repository Password, type the Password associated with the valid Database Repository user that you typed in sub-step a, and then press Enter.

      These values give the utility the authority to open the Database Repository and run the insert or create insert commands.

   3. When you receive a prompt to enter the WebFOCUS Administrator ID, type a new User ID, and then press Enter.
   4. When you receive a prompt to enter a Password for the ID entered, type a new Password, and then press Enter.

      These values become the new WebFOCUS Administrator User ID and Password. Be sure to type a User Name and Password that you can refer to in future operations.

      Note: The special characters " and $ are not permitted in the WebFOCUS Administrator User ID and Password during the create process.

6. If you typed any other option:
   1. When you receive a prompt to enter the Database Repository Username, type the name of a valid Database Repository user that has permission to create and alter tables in your database, and then press Enter.
   2. When you receive a prompt to enter the Database Repository Password, type the Password associated with the valid Database Repository user that you typed in sub-step a, and then press Enter.

      These values give the utility the authority to open the Database Repository and run the command you selected in step 3. Therefore, the User ID you type must have permission to create and alter tables in your database.

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

   /install_directory/ibi/WebFOCUS93/application_logs

   This utility uses the connection and sign-in information provided during the installation of WebFOCUS.

8. If you receive a message listing an error and stating that the creation of the WebFOCUS Repository failed, open the WFReposUtilCMDLine.log file and review the log to identify the specific error messages that occurred at the time the utility terminated.

   Error messages can be generated by connection failures, the presentation of invalid database credentials, or failed attempts to connect to an inaccessible database.

9. If you receive a message stating that the creation of the WebFOCUS Repository completed successfully, you can type Exit to close the UNIX shell.

   Note:

   • If the utility cannot connect to the database, ensure that the proper path to the JDBC driver appears in the following CLASSPATH value:

     /install_directory/ibi/WebFOCUS93/ReportCaster/bin/classpath

   • If the WebFOCUS installation program installed and configured Derby, this driver may be located as follows:

     /install_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 that the ID you typed for the database during the WebFOCUS installation has create permissions. You can change this User ID, as explained in Postinstallation Verification and Configuration.

Create the Repository Tables

Procedure
1. Navigate to the following directory:

   install_directory/ibi/WebFOCUS93/utilities/WFReposUtil

   Note: During installation, if the Create WebFOCUS Repository checkbox is selected, then the installer will run the WFReposUtilCMDLine.bat file in CREATE_INSERT mode. If any errors occur during this process, you can view the WFReposUtilCMDLine.log file for details. If the Create WebFOCUS Repository checkbox is not selected during installation (in the case of an existing Repository), then you must manually run the WFReposUtilGUI.bat file in DROP_CREATE_INSERT mode. Alternatively, you can run the WFReposUtilCMDLine.bat file in DROP_CREATE_INSERT mode.

2. Run the WFReposUtilCMDLine.bat file by right-clicking the file and selecting the Run as Administrator option.

   This utility creates a .log file with the same name under the application_logs directory after running it.

   /install_directory/ibi/WebFOCUS93/application_logs

   A Command Window opens, which allows you to create tables or to drop and re-create tables.

3. Enter a selection from the list of available options:
   • create
   • create_or_extend
   • insert
   • create_insert
   • update
   • drop
   • extract
   • create_ddl
   • quit
4. Press Enter to continue.

   A prompt for credentials displays. These are credentials for the database connection.

   Note:

   • If updates are performed, the User ID needs to have permissions to create and alter tables.
   • Depending on the option selected, you may be prompted for WebFOCUS Administrator credentials.

   A message appears if any errors occur during the Repository creation or re-creation process.