Setting up a remote Db2 database for Reporting Services

Reporting Services requires a Db2® database to store its data. If the database is on a different server, you must configure the database before installing Reporting Services.

Ensure that you have at least 17GB of free space in the location where you want to install Reporting Services.

To set up a remote Db2 database for Reporting Services, complete the following steps.

  1. Install Db2.
    Db2 is entitled as part of Network Manager. For information on how to set up a Db2 instance, see your Db2 documentation at http://www.ibm.com/support/knowledgecenter/SSEPGG/welcome.
  2. Download the compressed file for the most recent version of Reporting Services from Passport Advantage®. If you want to run reports, and you install Network Manager Reports, you also require the following versions of Reporting Services:
    For example, download a file similar to the following: 3.1.2.1-TIV-JazzSM-TCR-COGNOS-platform.tar.gz. Make a note of the download location.
  3. Decompress the installation package.
  4. Copy the TCR_generate_content_store_db2_definition.sh script to the server where Db2 is installed.
  5. Run the following command to create the data store: 
    ./TCR_generate_content_store_db2_definition.sh database_name db2_username

    Where database_name is the name you want for the Reporting Services database, and db2_username is the user name to connect to the content store, that is, the database owner.

  6. Run the following command: 
    db2 -vtf ./tcr_create_db2_cs.sql
Now install Reporting Services.