Configuring a new IBM Cognos BI service
When you install IBM® Business Monitor, you can optionally install a new IBM Cognos® Business Intelligence service. You can configure the new IBM Cognos BI service in the following ways: create a deployment environment, run the configuration wizard from the administrative console, use the wbmDeployCognosService command, or create an IBM Business Monitor stand-alone profile in the Profile Management Tool. You must also create an IBM Cognos BI database and user name for the content store.
IBM Business Monitor copies database drivers and application files to the IBM Cognos BI installation directories during the creation or augmentation of an IBM Business Monitor deployment manager or stand-alone profile. IBM Business Monitor also creates the IBM Cognos BI enterprise application (EAR file) to have it available for deployment of the IBM Cognos BI service.
Cluster requirements
For cluster members, at least 1 GB of extra disk space is required for IBM Cognos BI because a runtime instance must be created on each cluster member.
It is important to start only one of the cluster members at a time and wait for IBM Cognos BI to initialize fully before starting the next cluster member. IBM Cognos BI requires extra time when it is started for the first time, because the runtime instance must be created and the content store database must be initialized.
Starting another cluster member before the content store is fully initialized can cause corruption to the database. If this corruption occurs, it will be noted in the cogserver.log file for the IBM Cognos BI runtime instance. To recover, drop the content store database, re-create the database, and then restart a single cluster member. The DDL script to create the database is located in the /dbscripts/Cognos directory on the deployment manager.
Database requirements
The IBM Cognos BI service requires a separate database for its content store repository (called, by default, the COGNOSCS database). You can create this database while configuring a stand-alone or deployment manager profile, or manually create the database by using the scripts provided by IBM Business Monitor.
The IBM Cognos BI service creates tables in the IBM Cognos BI content store database the first time it is started. Because the database user provided for accessing the content store database must have privilege to create tables in the database, it is recommended that you create a new database user for the content store database only.
Systems where the IBM Cognos BI server is running must have the database client installed. The WebSphere® Application Server environment must have access to the client and the client must be configured to connect to the MONITOR database. See the "Database considerations" page and the information for your specific database.
Security requirements
When IBM Cognos BI is first deployed, the preconfigured group named Everyone belongs to several built-in groups and roles in the IBM Cognos BI namespace, including the System Administrators role. You must remove the Everyone group from all built-in groups and roles, and replace it with groups, roles, or users authorized to restrict access to IBM Cognos BI software and administration.
See "Configuring IBM Cognos BI security" for more configuration settings.
When IBM Cognos BI and Business Space are not running on the same cluster member, you must add the IBM Cognos BI host name and port number to the list of trusted servers in IBM Cognos BI. Otherwise, you will not be able to view the pages in Business Space. See step 4 in "Configuring IBM Business Monitor and Business Space to use an existing IBM Cognos BI service."
IBM Cognos BI system compatibility
When you create or augment an IBM Business Monitor deployment manager profile, the configuration files are copied and an enterprise archive (EAR) file is generated for IBM Cognos BI. The IBM Cognos BI EAR file is specific for the platform architecture (operating system and bit mode). When IBM Business Monitor deploys the IBM Cognos BI service, it uses the EAR file that was generated on the deployment manager for all nodes in the cell that are running IBM Cognos BI. To successfully run the EAR file, all nodes must be of the same type. If you have nodes that are of a different type from the deployment manager, you must generate an EAR file on one of the nodes. See "Generating an EAR file for IBM Cognos BI on a custom IBM Business Monitor node."
Locating your runtime IBM Cognos BI root directory
Because IBM Cognos BI configuration settings and binaries are for a single runtime instance, IBM Business Monitor might have to create a new copy for each runtime instance during deployment of the service. IBM Business Monitor checks on startup for updates to the base installation of IBM Cognos BI and applies those to the copy made for each runtime instance. Therefore, if service is required for IBM Cognos BI, only the base installation must be updated.
The copy for each runtime instance is placed under the profile running the IBM Cognos BI service. All configuration, runtime binaries, and log files are kept in unique directories for each runtime instance. The following table shows the location of the IBM Cognos BI root directory for the IBM Cognos BI runtime instance:
Server type | Directory |
---|---|
First stand-alone server | app_server_root/cognos |
Second stand-alone server | profile_root/profile_name/cognos/server_name |
Cluster member server | profile_root/profile_name/cognos/server_name |
Updating the IBM Cognos BI configuration
IBM Business Monitor saves updates to the IBM Cognos BI configuration each time the AdminTask wbmDeployCognosService command is run. For example, if the security setting changes from Federated to Stand-alone LDAP, or the Content Manager database settings change, run the wbmDeployCognosService command to reconfigure IBM Cognos BI, based on the parameters you pass to the command as well as the current WebSphere Application Server settings for the database and user registry.
The changes to the runtime instance of the IBM Cognos BI configuration are made during the server startup based on the changes from wbmDeployCognosService. IBM Business Monitor checks for changes to the IBM Cognos BI configuration each time the server is started.
- User registry changes
- Database changes to either IBM Business Monitor or IBM Cognos BI
- Host name, IP address, and HTTP port address changes
- IBM Cognos BI Content Store database user name or password
- IBM Cognos BI administrative user name or password
Manually updating the IBM Cognos BI configuration
When the IBM Business Monitor preconfigured configuration settings for IBM Cognos BI are not sufficient for complex configurations, you must manually configure IBM Cognos BI using the IBM Cognos BI Configuration application. Use the IBM Cognos BI Configuration application to set the host and port addresses of systems running Business Space to the valid domains or host settings of the IBM Cognos BI firewall settings.
- cogconfig.bat
- cogconfig.sh
Use Table 1 to find the cognos_installation_root directory.
For each unique configuration, there is a unique start script (cogconfig.bat or cogconfig.sh) located in the cognos_installation_root/bin64 directory. Use Table 1 to find the cognos_installation_root directory.
- SET JAVA_HOME=C:\WAS85\java
- export JAVA_HOME=/opt/IBM/WebSphere/AppServer/java
The IBM Cognos Administration client is located at http://host_name:port_number/p2pd/servlet/dispatch/ext.
Manually setting the IBM Cognos BI address that IBM Business Monitor uses
Use the wbmSetCognosDispatcher command to set the address of a remote or an existing IBM Cognos BI service, or to modify the address of a locally installed IBM Cognos BI service. To allow single sign-on for interactions between IBM Cognos BI and IBM Business Monitor, make sure that the IBM Cognos BI address ends with /ext (the full IBM Cognos BI external dispatcher address).
After changing the address, restart all IBM Business Monitor servers.