Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

developerWorks Community:

  • Close [x]

Recommended practices for using Cognos with Informix, Part 2: Deploy Informix with IBM Cognos BI Server 10

Install and get up and running

Sreeni Paidi, Enablement Consultant, IBM
Sreeni Paidi photo
Sreeni Paidi is an Enablement Consultant with the IBM Information Management Technology Ecosystem organization. Sreeni has about 15 years of experience working on DB2, Informix, Oracle, PostgreSQL, and SQL Server database servers as a Database Programmer, DBA and an Integration Architect. Sreeni is part of a worldwide team that provides technical skills and consulting services to help business partners and customers accelerate the integration of IBM data management software with their applications.
Jeffrey Williamson (jeffrey.williamson@jcbpartners.com), Senior Consultant, JCB Partners
A picture of the author Jeffrey Williamson
Jeffrey Williamson is a Senior Consultant and Southern California Market Lead for JCB Partners. Jeffrey has 4 years of experience implementing IBM Cognos Analyst, IBM Cognos Contributor and IBM Cognos TM1 as both a builder and a design architect. He has worked with clients in a wide range of industries including pharmaceutics, gaming and hospitality, retail, and restaurants. He is part of a team that helps organizations optimize the resources they have and better align their time and skills with the value of the organization.

Summary:  Connecting your Informix® databases to Cognos® Business Intelligence software gives you a way to unleash the power of your data with expanded query, reporting, and analysis capabilities. If you're ready to take that step, this two-part tutorial series gives you the information you need to install, configure, and deploy the necessary components to achieve the best results. Part 1 showed how to get started with using IBM Cognos Express V9 together with IBM® Informix V11.5 as a content store and data source. Now in Part 2, you'll find the same level of detail for deploying Informix with IBM Cognos BI Server V10. The tutorials include recommended practices for each step along the way, based on lessons learned from real-world deployments on the Microsoft® Windows® operating system.

View more content in this series

Date:  07 Jul 2011
Level:  Intermediate PDF:  A4 and Letter (2044 KB | 40 pages)Get Adobe® Reader®

Activity:  20739 views
Comments:  

Installing and configuring Informix software on the Informix server

In this section we walk you through the procedure to install and configure Informix software on the remote host which will be hosting the Informix datamarts / data sources.

Prerequisites

Make sure that the following software is installed on the Informix server / node1 before installing Informix server software:

  • Microsoft Windows Server 2003 for x86 64-bit
  • Service Pack 2 for Microsoft Windows Server 2003

Install Informix server software

This tutorial assumes that you have decided on the edition and version of Informix Server software that you will be installing on the database server and you also have access to the software installation media.

Read the release notes, machine notes, and fixed and known defects list, which are on your product media and in the information center.

  1. Launch the IDS installer program by double-clicking the setup.exe file in the IIF folder of the installation media.
  2. From the welcome screen, click Next.
  3. Read and accept the license terms and conditions, and then click Next.
  4. Choose Custom installation, and then click Next.
  5. Choose the default destination path for IDS installation, and then click Next.
  6. On the following screen you are given options to select features that you want to install, as well as the option to clear the features that you don't want to install. Select the features that you want to install and then click Next.
  7. On the following screen you are asked to enter and confirm the password of user Informix. Installer creates the Informix user with the given password. Enter the password and click Next.
  8. On the following screen, you are asked to enter the Informix server details such as server name, server number, service name, port numbers, and others. Enter the server name of your choice and click Next. The following values are used in this tutorial, and are also shown in Figure 1.
    • Server Name: cbiwin
    • Service Name for SQLI connections: cbiwin
    • Port number for SQLI: 9088
    • Server number: 0
    • Server Alias for DRDA support: cbiwin_drda
    • Port number for DRDA support: 9089

Figure 1. Informix server information
Informix server information

Recommended practice: Make sure that Initialize Server and Enable DRDA Support check boxes are selected. Make a note of the values entered on this screen. The port numbers do not have to be 9088 and 9089 but be sure to make a note of them.

  1. On the next screen, you can choose location and size of data dbspace and smart BLOB space. Enter 1024 as the size of dbspace and sbspace and click Next.
  2. On the next screen, you are given the summary of what you are going to install. Click Next to begin installation.
  3. Click Finish once the installation is completed.

Recommended practice: After the installation is done, verify that the Informix Server instance is running by checking the Windows services. You can also verify this by running the onstat - and onstat -d Informix commands from the Informix command Window.

Any Informix database that Cognos BI Server can connect has to be a UTF8 database. Before creating the Informix database that you are going to use as a data source with Cognos BI, make sure that the DB_LOCALE and CLIENT_LOCALE environment variables are set to en_us.UTF8. In addition to this, set DB_LOCALE and CLIENT_LOCALE environment variables to en_us.UTF8 using the setnet32 program. The Setnet32 program is part of Informix Client SDK (CSDK) and Informix Connect (IConnect) software. Install either CSDK or IConnect software in addition to Informix server software on the Informix host. CSDK and IConnect are part of the Informix Server install media. Refer to the instructions in the section titled Installing 32-bit Informix client software for more information on installing IConnect software. After the client software is installed, follow the procedure below to set some environment variables for UTF8 databases.

  1. Start Setnet32 by clicking Start -> All Programs -> IBM Informix Connect 3.50 -> Setnet32.
  2. From the Server Information tab, select the IBM Informix server cbiwin.
  3. Click the Environment tab and set the following environment variables:
    • CLIENT_LOCALE=en_us.utf8
    • DB_LOCALE=en_us.utf8
    • INFORMIXSERVER=cbiwin
  4. Click OK.

Create a sample Informix data source database

Now we are going to setup a sample gosales database called gsdb. Later on, you will configure this database as a data source for the Cognos BI Server and connect to it from the Cognos Framework Manager. To setup a gsdb database on the Informix Server, do the following steps:

  1. Download the compressed dbexport file GSDBv1.2_ids.zip to the C:\gosales folder on the Informix database server.
  2. Uncompress the dbexport file at C:\gosales. You will see a directory created with the name GSDBv1.2_ids, which contains the database dump.
  3. Open a command window for informix instance (cbiwin in our example) by clicking Start -> All Programs -> Informix Dynamic Server 11.50 -> < instance_name >.
  4. At the command prompt, change the directory to C:\gosales\GSDBv1.2_ids
  5. At the command prompt, run the following commands shown in Listing 1 to set the environment variables for CLIENT_LOCALE, DB_LOCALE, and DBDATE.

Listing 1: Setting environment variables
set CLIENT_LOCALE=en_us.utf8
set DB_LOCALE=en_us.utf8
set DBDATE=Y4MD

  1. Make sure that the SBSPACENAME parameter in the ONCONFIG.cbiwin parameter file (%INFORMIXDIR%\etc\%ONCONFIG%) is set to sbspace. If you followed the instructions in this tutorial and created the Informix instance at the time of Informix software installation, it will be automatically set to sbspace. If it is not already set, set the SBSPACENAME parameter to sbspace. Please note that this is not a requirement of Cognos BI but the sample gosales database uses an SBSPACE with the name sbspace.
  2. Recycle (stop and restart) the Informix instance service (Informix IDS - cbiwin) in the windows services.
  3. Execute createGSDBv1.2.bat batch command at the cbiwin command window that was previously opened. This batch command will create the gsdb database, create all the tables, and load the sample data into the tables.

3 of 10 | Previous | Next

Comments



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Business analytics, Information Management
ArticleID=696949
TutorialTitle=Recommended practices for using Cognos with Informix, Part 2: Deploy Informix with IBM Cognos BI Server 10
publish-date=07072011
author1-email=spaidi@us.ibm.com
author1-email-cc=
author2-email=jeffrey.williamson@jcbpartners.com
author2-email-cc=