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
- Install Rational Common Reporting, selecting the Manual for database installation mode.
- 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.
- In the DB2 server machine, create a content store database
(RIDW):
- Copy the lang folder from \datawarehouse\dw to reportal\contentstore.
- 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:
- Enter DB2 instance to use: DB2
- Enter name of database to create: RICM
- Enter user name to use to connect to the database: <your DB2 admin ID>
- Enter password for this user: <DB2 admin password>
- 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:
- Enter DB2 Instance to use: DB2
- Enter name of the database to create: RIDW
- Enter user name to use to connect to the database: <your DB2 admin ID>
- Enter password for this user: <DB2 admin password>
- Enter schema under which the operational data store
will be built: RIODS
- Enter schema under which the star schema will be
built: RIDW
- Enter user name that will connect and run the reports: <user ID for reading from the database for report queries>
- Specify a base directory for the table space files: <directory path>
- Enter earliest year to populate the date dimension
with: <year previous to data in the database>
- Enter latest year to populate the date dimension
with: <reasonable end year for use of the
database>
- 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.
- In the Rational Common Reporting server, create a content store to reference the DB2 content
database:
- Open the Cognos administration console, by clicking (Windows).
- Click , and then double-click Content Store.
- In the Database name field, enter
the name of the content store database that you created in step 3.
- 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.
- Select Local Configuration, and
the click Save configuration.
- 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.
- 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.
- 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.
- 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).
- Configure the data source connections by following the
steps in Setting up the datasource connections.
- 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.
- Configure a DB2 ID for administrative access to the
database by following the steps in Changing database users (RQM Specific).
- 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.
- 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.