
The steps needed to configure the DB2® database for the report server depend on
the options you chose for the
Rational® Common Reporting 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.
Note: - If you chose the automatic method for the installation, steps
1 to 9 are not needed.
- If you chose the automatic method for installation, the URL for
the main page is http://host:port/insight.
- If you chose the automatic method for installation, the URL for
the main web page is http://host:port/p2pd/servlet/dispatch.
Procedure
- 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_Common_Reporting_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 database by following the steps
at Creating the content store. 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.
- Create a content store in Rational Common Reporting to reference the DB2 content database by following the steps at Adding the content store object.
- 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 Common Reporting installer.
- Copy the [Rational_Common_Reporting_installation_directory]\cognos\bin\jre\1.5.0\lib\ext\bcprov-jdk14-134.jar file to the [WebSphere_installation_directory]\java\jre\lib\ext directory, and then restart the WebSphere Application Server.
- 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 Common Reporting service.
- Delete the Tomcat-based IBM Cognos 8 service.
- Launch the IBM Cognos Configuration
tool by clicking .
- Right-click the IBM Cognos 8 node, select Delete, and click Yes.
- Click Save, and click Close.
- Build and deploy the report server EAR file.
- Launch the IBM Cognos Configuration
tool by clicking .
- 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_Common_Reporting_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_Common_Reporting_installation_directory]\cognos\webcontent\*.* to the
expanded Web archive directory of the application.
Tip: An example of a Web archive directory is: [WebSphere_installation_directory]\profiles\RCPR\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.
Note: If you chose the manual method for installation,
point the browser to http://host:port/p2pd/servlet.
If the 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 Common Reporting portal.
Note: If you chose the manual method
for installation, point the browser to http://host:port/p2pd/servlet/dispatch.
- Import the Rational Common Reporting sample reports.
- Copy the [Rational_Common_Reporting_installation_directory]\reportal\deployment\Rational_Example_Reports.zip file to the [Rational_Common_Reporting_installation_directory]\cognos\deployment\ directory.
- Open the Cognos Web application at http://server:port/insight.
Note: If you chose the manual method for installation,
point the browser to http://host:port/p2pd/servlet/dispatch.
- Open the Cognos administration page ().
- Click Configuration.
- Click Content Administration,
click the New Import icon.
- Ensure that your product archive 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.
- Test the data source connections for the data warehouse
and the Rational products.
- Open the Rational Common Reporting Web application at http://server:port/insight.
Note: If you chose the manual method for installation,
point the browser to http://host:port/p2pd/servlet/dispatch.
Note: If you do not know the URL, see [Rational_Common_Reporting_installation_directory]\AppServer\profiles\RCPR\logs\AboutThisProfile.txt file.
- Open the Cognos administration page (Click , or if you are at the default home page of Rational Common Reporting, click the Administration link
in the banner).
- Click .
- Click the Set properties action
for the RIDW data source.
- Click the Connection tab.
- Click Test the connection.
- Click Test.
- Click Close twice, and then click OK.
- Click .
Note: To return to the list of data source
connections, you might need to click Cognos above the Name field.
- Click the Set properties action
for the product data source; for example, RationalQualityManager, RationalRequirementsComposer, or RationalTeamConcert.
- Click the Connection tab.
- Click Test the connection.
- Click Test.
- Click Close twice, and then click OK.
- Test-run the Rational Common Reporting sample reports.
- Open the Rational Common Reporting Web application at http://server:port/insight.
Note: If you chose the manual method for installation,
point the browser to http://host:port/p2pd/servlet/dispatch.
- Click the [your_product] folder.
- Run the reports.
- Create a user for accessing the data source.
- Open the Cognos administration page (Click IBM Cognos Administration or
if you are at the default home page of IBM Cognos, click ).
- 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 should have at least read privileges to the
data source.