WebFOCUS Repository Setup

Topics:

The ReportCaster repository structure has changed from previous 7.7.x releases and is now a part of the WebFOCUS repository. Therefore, you cannot use a repository from an early release without migrating its contents or creating a new repository. The ReportCaster tables in WebFOCUS 8.2 are now part of the WebFOCUS repository, and a database repository must store ReportCaster scheduling data. If you want to use the Report Library, the database can be any supported database with an available JDBC driver.

Depending on the platform used, the WebFOCUS Repository can be stored in a Derby, Microsoft SQL Server, Oracle, DB2, MySQL®, or PostgreSQL database. For more information, see Installing the WebFOCUS Client.

Repository Options

Review the information below and decide on the database server to use:

  • DB2. To use a DB2 repository, a DB2 JDBC driver must be on the machine or machines that run the WebFOCUS Client and the ReportCaster Distribution Server.

    Note:

    • The DB2 collation must be set to case sensitive for the WebFOCUS database. Case-insensitive collation is not supported.
    • If you are using DB2 as the WebFOCUS Repository, the database needs to be created with a pagesize of 16K.

    For more information on using a DB2 repository, see Additional WebFOCUS Repository Topics and Tasks.

  • Derby 10.9.1.0. If you choose, Derby can be installed with WebFOCUS. If you are also installing Tomcat, the required JDBC driver (derbyclient.jar) will be added to the Tomcat configuration file.
  • Microsoft SQL Server 2016, 2014, 2012, or 2008. To use SQL Server, the appropriate SQL Server JDBC driver must be on the machine or machines that run the WebFOCUS Client and the ReportCaster Distribution Server. You can download and install the specific driver from the Microsoft website.

    Note: The latest version of sqljdbc4.jar or sqljdbc41.jar is required. sqljdbc42.jar is not supported.

    If you are unfamiliar with the JDBC driver and its requirements, information is provided in Additional WebFOCUS Repository Topics and Tasks.

    Note:

    • The Microsoft SQL Server collation must be set to case sensitive for the WebFOCUS database. Case-insensitive collation is not supported.
    • The SQL Server collation sequence default is case insensitive.
  • MySQL 5.0. To use a MySQL Server repository, the MySQL driver should be installed on the machine or machines that run the WebFOCUS Client and the ReportCaster Distribution Server. This is typically named mysql-connector-java-nn-bin.jar, where nn is the version number. MySQL Repository Set Up contains information on installing and configuring the MySQL database server and this driver.

    Note:

    • The collation for MySQL must be set to case sensitive for the WebFOCUS database. Case-insensitive collation is not supported.
    • The default character set and collation for MySQL is latin1 and latin1_swedish_ci, so non-binary string comparisons are case insensitive, by default.
    • For use with WebFOCUS, the collation needs to be set as latin1_general_cs or latin1_swedish_cs, depending on the character set required.
    • WebFOCUS Release 8.2 does not support the MySQL utf8 encoding character set.
  • Oracle™ 12c. To use an Oracle repository, the Oracle JDBC™ Thin Client 9.0.1 driver must be on the machine or machines that run the WebFOCUS Client and the ReportCaster Distribution Server. This is typically named ojdbc7.jar depending on the Java release.
    Note:
    • The WebFOCUS repository requires character semantics. When creating a database for use with WebFOCUS, it needs to be done with CHAR semantics. This is applicable when using the following character sets:
      • UTF8
      • JA16SJISTILDE - Japanese
      • ZHS16CGB231280 - Simplified Chinese
      • ZHT16BIG5 - Traditional Chinese
      • KO16KSC5601 - Korean

      This is not needed when using the following character sets:

      • Western European: WE8ISO8859P15 or WE8MSWIN1252
      • Eastern European: WE8ISO8859P2 or EE8MSWIN1250
    • Oracle database blocks (db_block_size) require 8K or higher.
    • The maximum number of open cursors (open_cursors) must be set to 500 or higher when all tables are created and inserted.
    • Tablespace requirements depend on customer usage.
    • WebFOCUS requires case-sensitive collation. For Oracle, string comparisons are case sensitive, by default.
    • Comparison and sort can be configured through the sort system parameters NLS_COMP and NLS_SORT.
    • The RDBMS user account privileges used by WebFOCUS need to have the ability to change a schema that belongs to that account. The privileges must also be allowed to create tables, modify tables, execute queries, and insert and delete records.
  • Other JDBC-Compliant Databases. To use other JDBC-compliant databases, you need their JDBC drivers. You must also know the JDBC Path to connect to the database.
  • PostgreSQL. Java 1.7 or higher is required when using a PostgreSQL database for the WebFOCUS repository. This is a requirement of the PostgreSQL JDBC driver, as it is not compatible with Java 1.6.

For more information about repositories, see Additional WebFOCUS Repository Topics and Tasks.

WebFOCUS Repository Pre-Installation Tasks

How to:

During the WebFOCUS installation, you are prompted for information that WebFOCUS and ReportCaster need to access your repository. After WebFOCUS receives this information, you can use the WebFOCUS utilities to create repository tables and perform other repository-related tasks.

Additional information on ReportCaster repositories is available in Additional WebFOCUS Repository Topics and Tasks.

Procedure: How to Prepare for a WebFOCUS Repository

For additional background information and sizing guidelines for DB2 on z/OS, see Additional WebFOCUS Repository Topics and Tasks.

Ask your DBA to perform the following tasks:

  1. Install the JDBC driver for your WebFOCUS repository database on the WebFOCUS Client and ReportCaster Distribution Server machine or machines. You will be prompted for the path to the driver during the WebFOCUS and ReportCaster installation.
  2. Create or assign a user ID and password that will own the repository. You will be prompted for this information during the WebFOCUS and ReportCaster installation.

    For SQL Server, the database must use SQL Server authentication rather than Windows authentication, and the user ID must have db_owner rights to the repository database.

  3. If applicable, create a database within your database server for the WebFOCUS repository and ensure the user ID you created is the database owner. You will need the name of this database during the ReportCaster installation.
Note: Database collation must be case sensitive for WebFOCUS. The installation program and the database load utilities check for the database collation. If a case-insensitive database is detected, a message displays and the database creation does not take place. You can do either of the following:
  • Continue with the installation and correct the database collation post-install. Then, run the WFReposUtilCMDLine.
  • Exit the installation, correct the database collation, and rerun the installation.

WebFOCUS

Feedback