Quick Start for installing Rational Common Reporting and DB2 on separate servers (RQM Specific)

If you want to install Rational® Common Reporting and DB2 on separate servers, you need to perform some extra steps during setup.

About this task

Complete all of the steps in the referenced topics:

Procedure

  1. Install Rational Common Reporting, selecting the Manual for database installation mode.
  2. After the Rational Common Reporting installation completes, copy the directories, [RCR_Install_Directory]\reportal\contentstore and [RCR_Install_Directory]\datawarehouse\dw, from your Rational Common Reporting server to the DB2 server machine, where RCR_Install_Directory is your installation directory.
    Note: The default for the installation directory is C:\Program Files\IBM\Rational Insight.
  3. In the DB2 server machine, create a content store database (RIDW):
    1. Copy the lang folder from \datawarehouse\dw to reportal\contentstore.
    2. Open the DB2 command window, and run the Install.bat file in the reportal\contentstore directory to create the content store database. Type the following prompts while running the install.bat file:
      1. Enter DB2 instance to use: DB2
      2. Enter name of database to create: RICM
      3. Enter user name to use to connect to the database: <your DB2 admin ID>
      4. Enter password for this user: <DB2 admin password>
  4. In the DB2 server machine, create a data warehouse database (RIDW) by opening the DB2 command window, and running the Install.bat file in the datawarehouse\dw directory. Type the following prompts while running the install.bat file:
    1. Enter DB2 Instance to use: DB2
    2. Enter name of the database to create: RIDW
    3. Enter user name to use to connect to the database: <your DB2 admin ID>
    4. Enter password for this user: <DB2 admin password>
    5. Enter schema under which the operational data store will be built: RIODS
    6. Enter schema under which the star schema will be built: RIDW
    7. Enter user name that will connect and run the reports: <user ID for reading from the database for report queries>
    8. Specify a base directory for the table space files: <directory path>
    9. Enter earliest year to populate the date dimension with: <year previous to data in the database>
    10. Enter latest year to populate the date dimension with: <reasonable end year for use of the database>
  5. Copy the following DB2 drivers from the [DB2_installation_directory]\java\ directory in the DB2 server to the [rational_insight_installation_directory]\cognos\webapps\p2pd\WEB-INF\lib directory in the Rational Common Reporting server:
    • db2java.jar or db2java.zip
    • db2jcc*.jar
    • db2policy.jar
    Note: If the db2java.jar file is missing and db2java.zip is present, rename db2java.zip to db2java.jar.
  6. In the Rational Common Reporting server, create a content store to reference the DB2 content database:
    1. Open the Cognos administration console, by clicking Start > Programs > IBM Rational Common Reporting > IBM Cognos 8 > IBM Cognos Configuration (Windows).
    2. Click Data Access > Content Manager, and then double-click Content Store.
    3. In the Database name field, enter the name of the content store database that you created in step 3.
    4. Select the User ID and password row, click the Edit icon, and create a user name and password for the database content store that you created at step 3.
    5. Select Local Configuration, and the click Save configuration.
  7. In Rational Common Reporting server, install the DB2 client (Configuration Assistant), and then create the database catalog for the content store and data warehouse database.
  8. In Rational Common Reporting server, copy db2java.jar, db2jcc*.jar, db2policy.jar from folder [rational_insight_installation_directory]\cognos\webapps\p2pd\WEB-INF\lib to the [rational_insight_installation_directory]\AppServer\profiles\RationalInsight\installedApps\Node01Cell\IBM Cognos 8.ear\p2pd.war\WEB-INF\lib folder.
  9. Start the Rational Common Reporting service, IBM Websphere Application Server V6.1 - IBM Rational Quality Manager Custom Reporting, and log into Rational Common Reporting by pointing your browser to http://RCRhostname:port/insight.
    Note: The port default is 9080, but if that port is being used by another process, an alternative port is 9081.
  10. Import the report package by pointing your browser to http://RCRhostname:port/insight, and logging into the Rational Common Reporting server. Follow the steps in Importing reports into Rational Common Reporting (RQM Specific).
  11. Configure the data source connections by following the steps in Setting up the datasource connections.
  12. Change database users:
    Note: Database users need to be defined in the Rational Common Reporting administration in order to read data from the data warehouse and update data using the ETL.
    1. Configure a DB2 ID for administrative access to the database by following the steps in Changing database users (RQM Specific).
    2. Configure a DB2 ID for read-only access to the database by again following the steps in Changing database users (RQM Specific); however, in this case, use the RIDW data source connection and the read-only access DB2 ID.
  13. Follow steps 5 through 8 in Quick Start for installing the Rational Common Reporting server with default settings (RQM Specific).

Results

You can now run your reports in Rational Common Reporting.

Feedback