Setting up the report server

Set up the Web application server to host the report server, and the database client to enable access from the report server to the data warehouse. If you want to host the content store on the same system, install the database server. Also, install the required libraries and create links to an .so file so that you can install Rational® Common Reporting.

About this task

The report server is a Java™ Web application server that runs on WebSphere® Application Server. The report server is used for accessing the following databases:

Procedure

  1. If you want to run the report server on an existing instance of WebSphere Application Server, ensure that the existing instance is version 6.1.0.21 or later.
  2. If you are installing the report server on an existing instance of WebSphere Application Server, see if the [WebSphere_installation_directory]/AppServer/java/jre/lib/ext/ directory has the bcprov-jdk14-134.jar file. If the jar file is present, before you run the installer in automatic mode, back up the jar file and delete it from the directory.
  3. Before you install the content store database:
    • If you are hosting the content store locally, install the database server and client.
    • If your content store is hosted remotely, install the database client if the database server installation did not include the client services.
  4. If the data warehouse and content store do not use a database from the same vendor, install the database client of the data warehouse database.
  5. Make sure that the following packages are installed:

    libXp stands for X Print Client Library, openmotif stands for Open Motif.

    • libXp-1.0.0-8*.rpm
    • libXp-devel-1.0.0-8*.rpm
    • openmotif-2.3.0-0.5*.rpm
    • openmotif-devel-2.3.0-0.5*.rpm
    To check if these packages are installed, run the following command from the console:
    rpm –qa | grep [PACKAGENAME]
    If the packages are not installed, install them through the following command:
    rpm –ivh [PACKAGENAME]
    Typically, these packages are available on the Linux® installation media.
  6. Install the libXm.so.3 file in the /usr/lib folder. To check if you have this .so file, run the following command in your console:
    ls /usr/lib/libXm.* -l 
    If there is no .so file, install the following libraries:
    • libXp-devel-1.0.0-8.1.el5
    • libXp-1.0.0-8.1.el5
    • openmotif-2.3.0-0.5.el5
    • openmotif-devel-2.3.0-0.5.el5
  7. Link a new .so file through the following command:
    ln -s libXm.so.4.0.0 libXm.so.3
  8. Link another .so file through the following command:
    cd /usr/lib
    ln -s libfreetype.so /usr/lib/libfreetype.so.6 

What to do next

For current information about installing and configuring databases, see the product documentation.

Feedback