
The steps needed to configure the DB2® database for the report server depend on
the options you chose for the Insight Server feature during the installation
process. You might need to create the DB2 content
store database, configure the
IBM® WebSphere® Application
Server instance to
host the report server, and build, deploy, and install the enterprise
archive (EAR) files.
About this task
The following list gives the steps to configure the report
server.
- If you chose the automatic method for the installation, steps
1 to 11 are not needed.
- If you chose to install the Content Store Database feature on
a different system than the Reporting Server feature, steps 4 to 11
and step 13 and thereafter are needed. This is irrespective of the
method you chose for the installation, whether automatic or manual.
- Create a content store database. Ensure that
you, as the current user, have the necessary administrative privileges
to create databases and their components. The current user is the
one that can connect at run time to the content store. If you want
other users to connect at run time to the content store, see the IBM Cognos® 8
Business Intelligence Installation and Configuration Guide for instructions.
- If you have an existing content store from a previous
installation, delete it.
- Go to the DB2 command
window (In Windows®, click ,
enter db2cw, and click OK).
- Go to the C:\Program Files\ibm\Rational Insight\reportal\contentstore directory.
- Run the install.bat batch file.
- When prompted, specify the parameters for the content
store. To see a list of parameters and their explanations, see the
related links at the bottom of this page.
- Set up the Java™ Runtime
Environment (JRE) so that Cognos and
the report server run on the same JRE instance. Copy the
following DB2 drivers from the [DB2_installation_directory]/java/ directory
to the [rational_insight_installation_directory]/cognos/webapps/p2pd/WEB-INF/lib directory.
- db2java.jar or db2java.zip
- db2jcc*.jar
- db2policy.jar
If the db2java.jar file is missing and db2java.zip is
present, rename db2java.zip to db2java.jar.
- Create a content store in Rational® Insight to reference
the DB2 content database.
- Go to the Cognos administration
console (In Windows, click ).
- Click , right-click Content
Store, and click .
- In the Database name field, enter
the name of the database created in step 1.
- Select the User ID and password row,
click the Edit icon, and enter a user name and password that can be
used to access the database content store created at step 1.
- Select Local Configuration, and
click Save configuration.
- Create a new WebSphere Application Server instance
to host the report server. This step is not required if you had chosen
to install WebSphere Application Server through
the Rational Insight installer.
- Configure the WebSphere Application Server instance
to host the report server.
- Open the WebSphere Application Server administrative
console (open a browser to point to http://localhost:9060/ibm/console/).
Replace port 9060 with another port number if it differs from what
you recorded from the WebSphere Application Server Profile
Management tool.
- Expand the Servers node on the
left sidebar, and select Application servers.
- Click the server1 link, and expand
the Java and Process Management node.
- Click the Process Definition link,
and click the Java Virtual Machine link.
- Enter the initial and maximum JVM heap size as 256 and 768.
- Click Apply (at the bottom of
the page), and click the Save link.
- Click the Environment Entries link.
- Click New, and add the following
property:
LD_LIBRARY_PATH=[INSTALLDIR]\cognos\bin
- Click OK, click New,
and add the following property:
PATH=[INSTALLDIR]\cognos\bin
- Click Apply, and click Save.
- Open the Windows Services
control panel and restart the IBM WebSphere Application Server
V6.1 – Rational Insight service.
- Build and deploy the report server EAR file.
- Go to the Cognos administration
console (In Windows, click ).
- Select Environment, and change
all the ports from 9300 to the port number of the WebSphere Application Server profile.
- Select Portal Services, and change
all the ports from 9300 to the port number of the WebSphere Application Server profile.
- Click Save and click Close.
- Select .
- Click Next, accept the default
values, and click Next.
- Click Finish and click Close.
- Install the report server EAR file.
- Log on to the WebSphere Application Server administrative
console (point the browser to http://localhost:portnumber/ibm/console/login.do).
If prompted, enter your user name and password.
- Expand the Applications node
on the left sidebar, and select Install New Application.
- Click Browse, go to the [rational_insight_installation_directory]/cognos folder,
and select the p2pd.ear file.
- Accept the default options and click Next.
Do this step 4 times.
- Click the Save link, click Enterprise
Applications in the left sidebar, and if the Default Application
is listed, uninstall it.
- Copy the static Cognos Web
content files from [rational_insight_installation_directory]\cognos\webcontent\*.* to
the expanded Web archive directory of the application. An example
of a Web archive directory is: [WebSphere_installation_directory]\profiles\RationalInsight\installedApps\vega9Node01Cell\IBM
Cognos 8.ear\p2pd.war.
- Select the IBM Cognos 8 application,
and click Start. The application takes a few
minutes to load fully and to start.
- Open a browser and point it to http://host:port/insight/servlet.
If Cognos Content Manager
is working correctly, you see something similar to the following text
on the Web page:
IBM Cognos 8
Content Manager
Build: 8.4.2519.0
Start time: Tuesday, November 18, 2008 3:00:41 PM PST
Current time: Tuesday, November 18, 2008 3:01:25 PM PST
State: Running.
- Point the Web browser to http://server:port/insight.
You should see the home page of the Rational Insight portal.
- Deploy the Web archive (WAR) file for the help documents.
- Start the WebSphere Application Server administrative
console. The default URL is http://localhost:9060/ibm/console/login.do.
- Select .
- Click Browse and locate the WAR
file INSIGHThelp.war. The default location is C:\Program
Files\IBM\Rational Insight\UA. Specify the context root
to be help and click Next.
- On the Select installation options page,
click Next.
- On the Map modules to servers page,
click Next.
- On the Map virtual hosts for Web modules page,
click Next.
- On the Summary page, click Finish.
- Click Save.
- Install the Rational Insight skin.
- Open the Cognos Web
application at http://host/cognos8/cgi-bin/cognos.cgi.
- Open the Cognos administration
page ().
- Click the Configuration tab.
- On the navigation pane at the left of the screen, click Styles.
- Click New Style.
- In the Name field, enter Rational Insight and
click Next.
- In the Style resource location field,
enter vega.
- In the Preview resource field,
enter preview.htm.
- Click Finish.
- Select the Rational Insight skin.
- Open the Cognos home
page at http://host/cognos8/cgi-bin/cognos.cgi.
- Click My Area and click My
Preferences.
- In the Style box, select Rational Insight and
click OK.
- Set the Rational Insight skin
as the default skin.
- Open the Cognos home
page at http://host/cognos8/cgi-bin/cognos.cgi.
Ensure that you have administrator rights.
- Click Security.
- Click Cognos.
- Click the Edit Default User Profile icon
(to the left of the search button).
- Click Preferences.
- In the Style box, select Rational Insight and
click OK.
- Import the Rational Insight sample reports.
- Copy the [rational_insight_installation_directory]\reportal\deployment\Rational_Example_Reports.zip file
to the [rational_insight_installation_directory]\cognos\deployment\ directory.
- Open the Cognos Web
application at http://server:port/insight.
- Open the Cognos administration
page ().
- Click Configuration.
- Click Content Administration,
click the New Import icon.
- Ensure that Rational_Example_Reports is
listed as a deployment archive, and click Next.
- In the Name field, change the name from Rational_Example_Reports to Rational_Reports,
and click Next.
- To import all packages and folders, select the box in
the table header, and click Next four times.
- Click Finish.
- Click Run.
- Click OK.
- Click the Home icon.
- Verify that all packages and folders are listed in Public
Folders.
- Change the URLs of the XML data configuration files to
match your environment.
The sample data configuration
files define the default mappings for all templates and sample data
for each product. Take a backup of the sample XML data configuration
files, and then edit the files to match your environment. Resource
groups are defined at the following levels:
- Rational RequisitePro®: At the project level
- Rational ClearQuest®: At the user database level
- Rational ClearCase®: At the view level
- Rational TestManager:
At the project level
- Rational Quality Manager:
At the REST Service root
- Microsoft® Project:
At the project level
- Start XML Data Configuration (click ).
- Click , go to the directory where
the data configuration files are located, and open the product data
configuration file; for example clearcase.xdc. The default location
is the C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations directory.
When prompted to create an ETL project, click OK.
- In the XML Data Explorer, expand the tree structure
until the resource groups are visible (). The resource groups are represented by the data source
icons.
- Delete all resource group definitions that are not applicable.
- Double-click the applicable resource group and click Edit.
- In the Data Service field, enter
the URL of the resource group on the server where IBM Rational Insight
Data Services is installed.
The syntax of the URL is http://host:port/Data
Services/Name of adapter/name
of resource, where host is
the name of the Rational Insight
Data Services server, port is
the port used by Rational Insight
Data Services, Data
Services is the root directory where Rational Insight
Data Services is
installed, Name of adapter is the name of the product
for the data source, and name of resource is the
name of the product resource.
For example: http://host:9088/DataServices/ClearQuest/ALM/SAMPL.
To see how to find out the URL of the resource group, see the General
tasks for the product sources section.
- Click .
- Repeat steps e to g for all resource groups
for the product data source.
- Repeat steps b to h for all other products.
- Test the data source connections for the data warehouse
and the Rational products.
- Open the Rational Insight Web application
at http://server:port/insight.
Note: If
you do not know the URL, see [rational_insight_installation_directory]\AppServer\profiles\RationalInsight\logs\AboutThisProfile.txt file.
- Open the Cognos administration
page (Click , or if you are at the default home page of Rational Insight, click
the Administration link in the banner).
- Click .
- Click the Set properties action
for the RIDW data source.
- Click Connection, select the Connection
string field, and click Edit icon (the pencil icon at
the right end of the field).
- In the DB2 Connection string field,
ensure that SAMPLEDW is the database name,
and jdbc:db2://localhost:50000/SAMPLEDW is
the connect string.
- Test the connection.
- Click OK twice.
- Click .
- Click the Set properties action
for the product data source; for example, ClearQuest.
- Click Connection, select the Connection
string field, and click Edit icon (the pencil icon at
the right end of the field).
- Click OK twice.
- Test-run the Rational Insight sample reports.
- Open the Rational Insight Web application
at http://server:port/insight.
- Click the Sample Report Definitions folder.
- Run the reports.
- Create a user for accessing the data source.
- Open the Cognos administration
page (click or if you are at the Rational Insight Welcome page,
click the Administration link in the banner).
- Click .
- Click RIDW.
- Click New Signon, enter a name,
and click Next.
- Enter the user ID and password to access the data source.
To run reports, a user must have at least read privileges to the data
source.
What to do next
If you have upgraded to
Rational Insight Multilingual,
you need to deploy the WAR files for the Performance Measurement Practices
application. For instructions to do so, see the Related tasks link
at the bottom of this page.