Configuring the report server: Tasks for DB2

Linux 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 files.

About this task

To configure the report server:
Note: Steps 2 to 9 are needed only if you chose the manual installation method.

Procedure

  1. Configure the report server to connect to the content store by registering the database instances to be automatically started during system reboots.
    1. Run the following command:
      db2iauto -on <instance name> 
    2. Open the /etc/inittab file in an editor.
    3. Locate the following code string:
      fmc:2345:respawn:/opt/ibm/db2/V9.1/bin/db2fmcd #DB2 Fault Monitor Coordinator 
    4. Move the code string and place it just after the id:5:initdefault: command.
  2. Create a content store database.
    Note: Ensure that you, as the current user, have the necessary administrative privileges to create databases and table space containers. The current user is the one that can connect at run time to the Cognos® content store. If you want other users to connect at run time to the Cognos content store, see the IBM Cognos 8 Business Intelligence Installation and Configuration Guide for instructions.
    1. Start the DB2 command window using a valid DB2 database administrator account. By default, the user is db2inst1.
    2. If you have an existing content store from a previous installation, delete it.
    3. Go to the /opt/IBM/RCPR/reportal/contentstore directory.
    4. Switch to the root user by running the su command. If prompted, type the root password.
    5. Set the permissions for the files and folders by running the following command:
      chown db2inst1.db2iadm1 /opt/IBM/RCPR/reportal/contentstore -R
      where db2inst1 is the DB2 instance owner and db2iadm1 is the DB2 group.
    6. Return to the database administrator console and run the install.sh shell script through the following command:
      [db2inst1@VEGAVM contentstore]$ ./install.sh
    7. 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.
    8. Expand the All Databases folder and verify that the database you added is listed.
  3. Set up the Java™ Runtime Environment (JRE) so that Cognos and the report server run on the same JRE instance.
    1. Export JAVA_HOME=[WASDIR]/java/jre
    2. Export PATH=$JAVA_HOME/bin:…
    3. Copy the [INSTALLDIR]/cognos/bin/jre/1.5.0/lib/ext/bcprov-jdk14-134.jar file to the [WASDIR]/java/jre/lib/ext folder.
    4. Ensure that the following DB2 drivers are installed in the [INSTALLDIR]/cognos/webapps/p2pd/WEB-INF/lib directory:
      • db2java.jar
      • db2jcc.jar
      • db2jcc_license_cu.jar
      • db2policy.jar

      If the db2java.jar file is missing and db2java.zip is present, rename the db2java.zip folder to db2java.jar. If you see that the db2jcc4.jar is present, remove it.

    5. Copy the libdb2.so file from the [DB2 INSTALLDIR]/lib32 or [DB2 INSTALLDIR]//lib64 directory to /usr/local/lib directory.
  4. Delete the Tomcat-based IBM Cognos 8 service.
    1. Start the Cognos administration console (run the cogconfig.sh command under /opt/IBM/RCPR/cognos/bin).
    2. Right-click the IBM Cognos 8 node, select Delete, and click Yes.
    3. Click Save and click Close.
  5. Create a new content store in Rational Common Reporting to reference the DB2 content store database.
    1. Start the Cognos administration console (run the cogconfig.sh command under /opt/IBM/RCPR/cognos/bin).
    2. Click Data Access > Content Manager, right-click Content Store, and click New Resource > Database.
    3. In the Database name field, enter the name of the database created in step 1.
    4. 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.
    5. Select Local Configuration, and click Save configuration.
  6. 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.
  7. Configure the WebSphere Application Server instance to host the report server.
    1. Restart WebSphere Application Server if you have changed the Cognos Configuration.
    2. Open the WebSphere Application Server administrative console (open a Web browser and point to http://localhost:9060/ibm/console/). If 9060 is not the port number recorded from the WebSphere Application Server Profile Management tool, replace 9060 with any other port number.
    3. Log on to the WebSphere Application Server administrative console (point the browser to http://localhost:portnumber/ibm/console/login.do, and enter your user name and password).
    4. Expand the Servers node on the left sidebar, and select Application servers.
    5. Click the server1 link, and expand the Java and Process Management node.
    6. Click the Process Definition link and click the Java Virtual Machine link.
    7. Enter the initial and maximum JVM heap size as 256 and 768.
    8. Click Apply (at the bottom of the page), and click the Save link.
    9. Click the Environment Entries link.
    10. Click New, and add the following property:
      LD_LIBRARY_PATH=[INSTALLDIR]/cognos/bin
    11. Click OK, click New, and add the following property:
      PATH=[INSTALLDIR]/cognos/bin
    12. Click Apply, and click Save.
    13. Restart WebSphere Application Server.
  8. Build and deploy the report server enterprise archive file.
    1. Start the Cognos administration console (run the cogconfig.sh command under /opt/IBM/RCPR/cognos/bin).
    2. Select Environment, and change all the ports from 9300 to the port number of the WebSphere Application Server profile which, by default, is 9080.
    3. Select Portal Services, and change all the ports from 9300 to the port number of the WebSphere Application Server profile.
    4. Click Save and click Close.
    5. Select Actions > Build Application Files.
    6. Click Next, accept the default values, and click Next.
    7. Click Finish and click Close.
  9. Install the report server enterprise archive file.
    1. Log on to the WebSphere Application Server administrative console (point the browser to http://localhost:portnumber/ibm/console/login.do, and enter your user name and password).
    2. Expand the Applications node on the left sidebar, and select Install New Application.
    3. Click Browse, go to the [Rational_Common_Reporting_installation_directory]/cognos folder, and select the p2pd.ear file.
    4. Accept the default options and click Next. Do this step four times.
    5. Click the Save link, click Enterprise Applications in the left sidebar, and if Default Application is listed, uninstall it.
    6. Select the IBM Cognos 8 application, and click Start. The application takes a few minutes to load fully and to start.
    7. Open a browser and point it to http://server: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. 
    8. Point the Web browser to http://server:port/insight. You should see the home page of the Rational Common Reporting portal.
  10. Import the Rational Common Reporting sample reports.
    1. Copy the [Rational_Common_Reporting_installation_directory]/reportal/deployment/Rational_Example_Reports.zip file to the [Rational_Common_Reporting_installation_directory]/cognos/deployment/ directory.
    2. Open the Rational Common Reporting Web application at http://server:port/insight.
    3. Open the Cognos administration page.
    4. Click Configuration.
    5. Click Content Administration, click the New Import icon.
    6. Ensure that your product archive is listed as a deployment archive, and click Next twice.
    7. To import all packages and folders, select the box in the table header, and click Next four times.
    8. Click Finish, click Run, and click OK.
    9. Click the Home icon and verify that all packages and folders are listed in Public Folders.
  11. Test the data source connections for the data warehouse and the product sources.
    1. Open the Rational Common Reporting Web application at http://server:port/insight.
    2. Open the Cognos administration page (click Launch > IBM Cognos Administration.
    3. Click Configuration > Data Source Connections > RIDW.
    4. Click the Set properties action for the RIDW data source.
    5. Click the Connection tab.
    6. Click Test the connection.
    7. Click Test.
    8. Click Close twice, and then click OK.
    9. Click Configuration > Data Source Connections > [your_product].
      Note: To return to the list of data source connections, you might need to click Cognos above the Name field.
    10. Click the Set properties action for the product data source; for example, ClearQuest.
    11. Click the Connection tab.
    12. Click Test the connection.
    13. Click Test.
    14. Click Close twice, and then click OK.
  12. Test-run the Rational Common Reporting sample reports.
    1. Open the Rational Common Reporting Web application at http://server:port/insight.
    2. Click the [your_product] folder.
    3. Run the reports.

Feedback