Monday 25 August 2014

IBM Cognos BI Installation & Configuration on Redhat Linux


Those who normally work with Cognos BI on Windows Server, find it difficult to install and configure on Linux. In this blog we’ll see steps involved in this installation and configuration on RHEL. There are three parts to it.

1)      Meet the pre-requisites (Hardware & Software)
2)      Install and configure Cognos BI Server components
3)      Install and configure HTTP server

Cognos Framework Manager and Transformer are client tools and must be installed on Windows.

Meet the pre-requisites (Hardware & Software)

Let’s start with step -1. You can go thru standard supported environment specification on IBM site (http://www-01.ibm.com/support/docview.wss?uid=swg27037784). Here I am going to install Cognos BI V 10.2.1 on RHEL 6.4 system with the specification shown in below screenshot.


 We need to ensure installation of required patches before we start Cognos installation:

  • glibc-2.12-1.80.el6 (both ppc and ppc64 packages) - 32 and 64 bit glibc libraries
  • libstdc++-4.4.6-4.el6 (both ppc and ppc64 packages) - 32 and 64 bit libstdc++ libraries
  • nspr-4.9-1.el6 (both ppc and ppc64 packages) - 32 and 64 bit nspr library for CAM ldap provider
  • nss-3.13.3-6.el6 (both ppc and ppc64 packages) - 32 and 64 bit nss library for CAM ldap provider
  • openmotif-2.3.3-4.el6 (both ppc and ppc64 packages) - 32 and 64 bit openmotif libraries

One way to get these libraries is to download them independently from various Linux websites and install them. The other and probably the better way is to use your OS (RHEL 6.4 in this case) disk or .ISO image for the process. I am going to use the second option here. First I copied “RHEL6.4-20130130.0-Server-x86_64-DVD1.iso” file in /data folder (newly created) then mounted it as /media and update repository.

mount -oloop RHEL6.4-20130130.0-Server-x86_64-DVD1.iso /media
vi /etc/yum.repos.d/server.repo
rpm --import /media/*GPG*
yum clean all
  

Now to check if glibc package is already installed or not, use below command:

rpm –qa | grep glibc

If package is installed you’ll get file list (name ending with .x64_64 or .i686) in return otherwise we need to install it including dependencies using below command:

 yum install glibc.i686    // For 32-bit
 yum install glibc.x86_64  // For 64-bit

Repeat the same process for libstdc++, nspr, nss, openmotif.

We also need to have JDK 7 installed as prerequisite. I am downloading IBM JDK 7 from IBM site (http://www.ibm.com/developerworks/java/jdk/linux/download.html ) for Linux 64-bit environment and install it as shown below.

./ibm-java-x86_64-sdk-7.1-1.1.bin

It is installed in /opt/ibm/java-x86_64-71. Now we are ready for step-2.

Install and configure Cognos BI Server components

As shown below in snapshot, I have copied these 5 server components –
·         Cognos BI Server 10.2.1
·         Cognos BI Samples (optional)
·         Cognos SDK (optional)
·         Cognos Mobile (optional)
·         Cognos Dynamic Query Analyzer (optional)



 First unzip the package using below command –

  tar –xvf bi_svr_10.2.1_l86_ml.tar.gz
     cd linuxi38664h
     ./issetup

  It would open GUI based installation wizard, as shown below -


From here steps are self explanatory. I am selecting all four components from ‘Component Selection’ screen as I want all on my single server. By default ‘Cognos Content Database’ is not selected. In case, you plan to create content store somewhere else you can go ahead without it.


 Once the installation is over you can go ahead with Cognos Samples, SDK, Mobile and other server components. Add the bcprov-jdk14-134.jar  from  /cognos/c8_64/bin64/jre/1.5.0/lib/ext/bcprov-jdk14-134.jar to the $JAVA_HOME/lib/ext path

 cp /opt/ibm/cognos/c10_64/bin64/jre/7.0/lib/ext/bcprov-jdk14-145.jar /opt/ibm/java-x86_64/jre/lib/ext

We also need to add JAVA_HOME in cogconfig.sh file before opening Cognos Configuration tool.

vi /opt/ibm/cognos/c10_64/bin64/cogconfig.sh

And add below line as first executable command of cogconfig.sh file.

 Export JAVA_HOME=/opt/ibm/java-x86_64/jre

Save it and run it to start Cognos service.

./opt/ibm/cognos/c10_64/bin64/cogconfig.sh



Just test if Cognos BI service is running successfully by opening “http://localhost:9300/p2pd/servlet” on browser.



Install and configure HTTP server

You can choose your choice of HTTP server here. I am using IBM HTTP Server (32-bit). It is no-charge and can be downloaded from –

Unzip downloaded package, update JAVA_HOME in “IHS/install” file and run it.

tar –xvf ihs.7000.linux.ia32.tar
cd IHS
vi install
./install

It’ll open GUI wizard for installation.


 After successful installation we’ll add necessary virtual directories in configuration file.

 vi /opt/IBM/HTTPServer/conf/httpd.conf

Add below lines in httpd.conf

# Cognos #
# Load Cognos Apache 2.2 Module
LoadModule cognos_module "/opt/ibm/cognos/c10_64/cgi-bin/lib/mod2_2_cognos.so"

# Add WebDAV lock directory, make sure the LoadModule dav_module modules/mod_dav.so and LoadModule dav_fs_module modules/mod_dav_fs.so are uncommented
DAVLockDB /tmp/DBLOCK

# Alias for the cgi scripts
ScriptAlias /ibmcognos/cgi-bin "/opt/ibm/cognos/c10_64/cgi-bin/"

<Directory "/opt/ibm/cognos/c10_64/cgi-bin">

AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>

# Alias for the Cognos webcontent folder
Alias /ibmcognos "/opt/ibm/cognos/c10_64/webcontent"

<Directory "/opt/ibm/cognos/c10_64/webcontent">
Options Indexes FollowSymLinks MultiViews IncludesNoExec
AddOutputFilter Includes html
AllowOverride None
Order allow,deny
Allow from all
DAV on
</Directory>

Find out below lines and add ‘#’ in the beginning to comment them.

# LoadModule was_ap22_module /opt/IBM/HTTPServer/Plugins/bin/32bits/mod_was_ap22_http.so
# WebSpherePluginConfig /opt/IBM/HTTPServer/Plugins/config/webserver1/plugin-cfg.xml

We can save it now. We’ll create two file – one two start the server and another to stop it.

Create startIHS.sh with below code –
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/ibm/cognos/c10_64/cgi-bin:/opt/ibm/cognos/c10_64/cgi-bin/lib
./apachectl start

And stopIHS.sh with –
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/ibm/cognos/c10_64/cgi-bin:/opt/ibm/cognos/c10_64/cgi-bin/lib
./apachectl stop

Copy both files in /opt/IBM/HTTPServer/bin and run startIHS.sh to start the server.
  cd /opt/IBM/HTTPServer/bin
./startIHS.sh

Here’s your Cognos BI server ready for use. Open “http://localhost:80/ibmcognos” on local machine or use IP address/hostname instead of ‘localhost’. In my case, HTTP server is running on 80 port number (default).


 If you want to upgrade it with fix pack 3 which is latest please get it from below link and install it.

References:

IBM Cognos 10.2.1 official documentation (Knowledge Center)

Business Intelligence Installation and Configuration Guide

Business Intelligence Architecture and Deployment Guide


33 comments:

  1. Thanks for sharing this informative blog. If you are looking for best PHP Training Institute in Chennai visit FITA IT training and placement academy

    ReplyDelete
  2. Thanks for Share If you are looking for best Pega and Cognos Training in Chennai.
    Visit Us, Pega Training in Chennai | Cognos Training in Chennai

    ReplyDelete
  3. Thanks for sharing this excellent post. Its really very informative and interesting. Keep update your blog. For a best Android training in Chennai please refer this site.
    Regards....
    Android Training in Chennai

    ReplyDelete
  4. Business analytics can be considered as the future of business. This method includes effective utilization of various software and tools that helps in analyzing, designing and tracking the business of a company. Business analytics certification in India

    ReplyDelete
  5. very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
    sap hana Training in Chennai

    ReplyDelete
  6. Thanks for nice topic. Very useful information.
    IthubOnlineTraining are good in giving the <a href=" http://www.ithubonlinetraining.com/red-hat-linux-online-training/ redhatlinux onlineTraining</a>

    ReplyDelete
  7. Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog. Cognos BI Online Training

    ReplyDelete
  8. nice posts about ibm installations..
    SAS Institute introduced the SAS Certified Professional Program,training proper understanding of how the SAS software works.
    SAS online training in hyderabad

    ReplyDelete
  9. Great stuff provided by the Admin here… look into this for Cognos online training

    ReplyDelete
  10. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Ibm Cognos, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Ibm Cognos. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.

    For Free Demo Contact us:
    Name : Arunkumar U
    Email : arun@maxmunus.com
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –http://www.maxmunus.com


    ReplyDelete
  11. I am really happy with your blog because your article is very unique and powerful for new reader.
    Click here:
    Selenium Training in Chennai | Selenium Training in Bangalore | Selenium Training in Pune | Selenium online Training

    ReplyDelete
  12. I was curious if you ever considered changing the layout of your site? It’s very well written;
    safety course in chennai

    ReplyDelete
  13. I am happy for sharing on this blog its awesome blog I really impressed. thanks for sharing. Great efforts.

    Become an Expert In Python Training in Bangalore ! The most trusted and trending Programming Language. Learn from experienced Trainers and get the knowledge to crack a coding interview, @Softgen Infotech Located in BTM Layout.

    ReplyDelete
  14. Awesome,Thank you so much for sharing such an awesome blog...
    Informatica Training in Bangalore

    ReplyDelete
  15. It is really explainable very well and i got more information from your site.Very much useful for me to understand many concepts and helped me a lot. Congratulations! This is the great things. Thanks to giving the time to share such a nice information.
    Salesforce Training in Chennai | Certification | Online Course | Salesforce Training in Bangalore | Certification | Online Course | Salesforce Training in Hyderabad | Certification | Online Course | Salesforce Training in Pune | Certification | Online Course | Salesforce Online Training | Salesforce Training

    ReplyDelete
  16. Very nice blog,Keep sharing more blogs with us.

    Really this blog helps me alot.
    Thank you...

    cognos online training

    ReplyDelete
  17. Thanks a lot very much for the high quality and results-oriented help. I won’t think twice to endorse your blog post to anybody who wants and needs support in this area. same as your blog i found another one Web Analytics .Actually I was looking for the same information on internet for Web Analytics and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  18. Virtual events are naturally more inclusive than in-person events in many respects but there are still a lot of things that planners can do to make them more accessible to people with disabilities. event marketing and thank you for hosting event

    ReplyDelete
  19. Very Informative blog thank you for sharing. Keep sharing.

    Best software training institute in Chennai. Make your career development the best by learning software courses.

    rpa uipath training in chennai
    Docker Training in Chennai
    blue prism training in chennai

    ReplyDelete
  20. Good one, I really love reading these kinds of blogs. Keep updating and write something on Analytics Visualization and other things also.

    ReplyDelete
  21. Hey, I view as cognizant part concentrating on this text a delight. it's miles really pleasurable to prepared and intriguing and profoundly tons looking take care of to perusing extra of your trademark.. MS Office 2019 Free Download With Crack 64 Bit

    ReplyDelete
  22. What's an astounding message! wiped out be help (to right to apply more conspicuous of your substance material). much gratitude to you for the nudge! Thumbs occurring! Connectify Me Pro Crack

    ReplyDelete
  23. First class data, modify everybody mind basically reference designate assistance to it. I could be placed in a larger invincible state. XXClone Serial Video Download

    ReplyDelete
  24. Every single girl out there deserves to feel as special as possible when it's her birthday. This list of Happy Birthday Gorgeous messages can help. You.Happy Birthday Gorgeous Lady

    ReplyDelete

  25. Your only point of contact with me is a heartfelt request for assistance with a matter well within my scope of expertise.
    https://crackguru.net/ace-utilities-crack-download/

    ReplyDelete
  26. Nice Article Keep posting.
    < ahref="https://www.vcubesoftsolutions.com/best-devops-training-in-hyderabad/">Best DevOps Training institute in hydderabad

    ReplyDelete