Implementing IBM Cognos Business Intelligence

򐂰 Content store

򐂰 Content Manager 򐂰 Application server 򐂰 Gateway server

To provide a scalable and robust environment for cloud computing, the server components can be installed on separate VMs using a distributed configuration. Use a transfer specification file (.ats) to install IBM Cognos Business Intelligence without being prompted for user input. If you do not use the regular installation wizard to generate an .ats file, you can use the .ats file that is available on the installation disk.

In a distributed environment, the sequence in which you configure computers is important. Use the following sequence:

1. Create the content store database.

2. Install, configure, and start the active Content Manager. 3. Install and configure the standby Content Manager. 4. Install and configure the application tier component.

5. Configure the gateway computer so that cryptographic keys are shared and secure communication can take place among the components. The server specified for the External Dispatcher URI property on the gateway computer must be the last server that you start.

3.3.1 Installing IBM Cognos Business Intelligence 10 silently

To perform a silent installation of IBM Cognos Business Intelligence on a Linux guest:

1. Create a Cognos Content Store. If you are using DB2 server, Example 3-18 illustrates how to create a Cognos Content Store with the DB2 commands.

Example 3-18 Commands to create a Cognos Content Store in DB2

DB2START;

CREATE DATABASE "csdb001" automatic storage yes on /csdb001data dbpath on /home/csuser001;

CHANGE DATABASE "csdb001" COMMENT WITH 'Cognos 10 Content Store for Client 1';

CONNECT TO "csdb001";

UPDATE DATABASE CONFIGURATION USING APPLHEAPSZ 1024 DEFERRED; UPDATE DATABASE CONFIGURATION USING LOCKTIMEOUT 240 DEFERRED; CONNECT RESET;

CONNECT TO "csdb001";

CREATE BUFFERPOOL "csdb001_08KBP" IMMEDIATE SIZE 1000 PAGESIZE 8K; CREATE BUFFERPOOL "csdb001_32KBP" IMMEDIATE SIZE 1000 PAGESIZE 32K; CONNECT RESET;

CONNECT TO "csdb001";

CREATE SYSTEM TEMPORARY TABLESPACE "TEMP_TSP_csdb001" IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32K MANAGED BY SYSTEM USING ('CNT_SYS_csdb001') BUFFERPOOL "csdb001_32KBP";

CREATE USER TEMPORARY TABLESPACE "USR_TSP_csdb001" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8K MANAGED BY SYSTEM USING ('/tempspace/db2cs001') BUFFERPOOL "csdb001_08KBP";

CREATE REGULAR TABLESPACE "REG_TSP_csdb001" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8K MANAGED BY SYSTEM USING

('CNT_REG_csdb001') BUFFERPOOL "csdb001_08KBP";

ALTER TABLESPACE "REG_TSP_csdb001" DROPPED TABLE RECOVERY ON; CONNECT RESET;

CONNECT TO "csdb001";

CREATE SCHEMA db2cs001 AUTHORIZATION db2cs001;

COMMENT ON SCHEMA db2cs001 IS 'Cognos 10 Content Store';

GRANT CREATETAB,BINDADD,CONNECT,IMPLICIT_SCHEMA ON DATABASE TO USER csuser001;

GRANT CREATEIN,DROPIN,ALTERIN ON SCHEMA db2cs001 TO USER csuser001 WITH GRANT OPTION;

GRANT USE OF TABLESPACE "USR_TSP_csdb001" TO csuser001; CONNECT RESET;

DB2STOP;

2. On the VM, insert the appropriate disk or copy the contents of the installation files.

3. The .ats file is ts-BISRVR-yyyymmdd_hhmm.ats. Copy it where you plan to install the IBM Cognos Business Intelligence server component.

Example 3-19 is a sample .ats file that installs all IBM Cognos Business Intelligence components.

Example 3-19 IBM Cognos Business Intelligence sample .ats file

; Licensed Materials - Property of IBM ; BI and PM: is

; (C) Copyright IBM Corp. 2004, 2011

; US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp [Dialog1]

Title=Welcome to the Installation Wizard DE=0 EN=1 FR=0 JA=0 ES=0 NL=0 SV=0 FI=0 IT=0 PT_BR=0 KO=0 ZH_CN=0 ZH_TW=0 [Dialog2]

Title=IBM License Agreement

;Failure to accept the license agreement and non-IBM terms, if any, will abort the installation.

;Please return the software to the point of acquisition and obtain a refund, if applicable.

I Agree=y [Dialog3]

Title=Non IBM License Agreement

;Failure to accept the license agreement and non-IBM terms, if any, will abort the installation.

;Please return the software to the point of acquisition and obtain a refund, if applicable. I Agree=y [Dialog4] Title=Installation Location APPDIR=/opt/ibm/cognos/c10_64 BACKUP=0

[Component List] C8BISRVR_APP=1 C8BISRVR_APPLICATION_TIER=1 C8BISRVR_GATEWAY=1 C8BISRVR_CONTENT_MANAGER=1 C8BISRVR_CONTENT_DATABASE=0

4. To perform a silent installation, edit the response file to meet your installation requirements. You can edit the following information:

– License Agreement

The product license must be accepted to continue with the installation. Change the value for the “I Agree” variable to y to accept the IBM License Agreement.

– Installation Location

You can change the installation path in the APPDIR variable. By default, the installation path for IBM Cognos Business Intelligence 64 bits on Linux is the /opt/ibm/cognos/c10_64 directory.

– Component List

You can customize the components that are to be installed by specifying a boolean value, 1 or 0. Example 3-20 identifies the features that you can add or remove from the installation program.

Example 3-20 Edit the features list variable to add or remove features

[Component List] C8BISRVR_APP=1 C8BISRVR_APPLICATION_TIER=1 C8BISRVR_GATEWAY=1 C8BISRVR_CONTENT_MANAGER=1 C8BISRVR_CONTENT_DATABASE=0

5. Install IBM Cognos Business Intelligence.

On UNIX or Linux systems, change to the directory where you copied the contents of the disk. In the directory for your guest operating system, type the following command, where location is the directory where you copied the transfer specification file and filename.ats is the name of the file:

./issetup -s location/filename.ats

6. If a return status other than zero (0) is returned, check the log files for error messages. Errors are recorded in the c10_location/instlog directory in a summary error log file.

3.3.2 Installing Cognos Framework Manager

You can install the IBM Cognos Business Intelligence modeling tool, Framework Manager, either on a virtual desktop or in the BI developer personal computer. This component requires a Windows operating system. To install Framework Manager:

1. Insert the Cognos Framework Manager disk or download the installation files from the Passport Advantage website. For more information about how to download the product, see:

http://www.ibm.com/support/docview.wss?uid=swg24029297

2. If you download the installation files, extract them into a directory. Go to the directory where you extract the files, and double-click the issetup.exe file. 3. Follow the directions in the installation wizard to copy the required files to

your computer.

4. When notified with an information message about installing the Supplementary Languages Documentation, click OK.

The Supplementary Languages Documentation contains translated versions of Guidelines for Modeling Metadata. If you want this guide available in languages in addition to English, install the contents of the disk. Otherwise your installation includes only the English version of the guide.

5. On the last page of the installation wizard, select Start IBM Cognos

Configuration to configure Cognos Framework Manager immediately. You

can choose to configure Cognos Framework Manager later by starting the configuration tool from the Windows Start menu shortcut in the IBM Cognos program folder.

6. Secure the installation directory from unauthorized access.

You must configure the modeling tool to communicate with the application tier components using one of these routes:

򐂰 Connect to the application tier components dispatcher using the Internal dispatcher URI. This route is the preferred route.

򐂰 Connect to an additional, dedicated gateway that is configured to connect to the dispatcher using the Internal dispatcher URI. You must configure

Directory names: Be sure to name the installation using only ASCII

characters. Some servers do not support non-ASCII characters in directory names. For example, installing Cognos Framework Manager in a directory that has an apostrophe in the path name might result in the help not opening properly.

appropriate security for this gateway. This method is useful when the modeling tool is outside a network firewall.

To ensure that the modeling tool can communicate with IBM Cognos Business Intelligence components on the computer where the tool is installed, configure cryptographic properties and the following environment properties:

򐂰 Gateway URI

򐂰 Dispatcher URI for external applications

To model DB2 data sources with Cognos Framework Manager, you must install and configure the DB2 Client on each Cognos Framework Manager computer. This installation allows for direct access from each system to the DB2 data source.