DB2 Connection in Cognos

DB2 Connect String: jdbc:db2://localhost:50000/UNICADB


Important: If you are using DB2, the DB2 database name must be in uppercase letters.

Cognos 10.2 startup.sh on Redhat

To get this to work:

1. Ensure that LD_LIBRARY_PATH is set to :/apps/ibm/cognos/c10_64/bin64
2. Ensure that CLASSPATH is set to: /apps/ibm/cognos/c10_64/bin64/jre/7.0/lib/ext/bcprov-jdk14-145.jar
3. Ensure you have source db2profile and that it has 32bit libraries in LD_LIBRARY_PATH

httpd.conf for Cognos

Just add the following lines to httpd.conf:


ScriptAlias /ibmcognos/cgi-bin "/apps/ibm/cognos/c10_64/cgi-bin"

Order allow,deny
Allow from all

Alias /ibmcognos "/apps/ibm/cognos/c10_64/webcontent"

Order allow,deny
Allow from all

Too many open files

If you get too many open files, you might want to do this:

1. vi /etc/sysctl.conf and add in the following to the last line:
fs.file-max = 65536

2. Reboot the server and check using sysctl -p

Streams Logs

Location:
/home/streamsadmin/OpDetection/StreamsRemoteControlService/wlp/usr/servers/StreamsRCS/logs

/home/streamsadmin/OpDetection/RealTimeConnector/wlp/usr/servers/RealTimeConnector/logs

/apps/IBM/EMM/OpDetection/InteractService/wlp/usr/servers/InteractService/logs

Maximise Redhat VM Screen

System -> Preferences -> Display
Under Monitor -> Resolution, change to 1920 x 1080

Setting up VNC Server

1. yum install tigervnc-server

2. login for each vnc user (e.g. unica, streamsadmin) and run:  vncpasswd

3. Edit '/etc/sysconfig/vncservers' with your favorite editor

4. Append the following lines :
VNCSERVERS="1:unica 2:streamsadmin"
VNCSERVERARGS[1]="-geometry 1024x768"
VNCSERVERARGS[2]="-geometry 1024x768"

5. Start the vnc server:
# service vncserver start

6. Ensure service is started on reboots :
# chkconfig vncserver on


7. Configure the firewall
    # iptables -I INPUT -m state --state NEW -p tcp --destination-port 5901 -j ACCEPT
    # iptables -I INPUT -m state --state NEW -p tcp --destination-port 5902 -j ACCEPT

NOTE : Each user requires an additional firewall port opened starting at 5901. Because we added two users above, we need to open two ports.

    # service iptables save

Configuring hostname on redhat 6

1. vi  /etc/sysconfig/network

2. Comment off:
#HOSTNAME=localhost.localdomain

3. Add the following:
 - HOSTNAME=rhel-server-6.5-x86_64.localdomain

4. Reboot

Installing perl-XML-Simple (for Streams)

Do note that you will need perl-XML-Parser before you can install perl-XML-Simple:

[root@localhost rpm]# rpm -ivh perl-XML-Simple-2.18-6.el6.noarch.rpm
error: Failed dependencies:
    perl(XML::Parser) is needed by perl-XML-Simple-2.18-6.el6.noarch


[root@localhost rpm]# yum install perl-XML-Parser
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package perl-XML-Parser.x86_64 0:2.36-7.el6 will be installed
--> Processing Dependency: perl(URI::file) for package: perl-XML-Parser-2.36-7.el6.x86_64
--> Processing Dependency: perl(URI) for package: perl-XML-Parser-2.36-7.el6.x86_64
--> Processing Dependency: perl(LWP) for package: perl-XML-Parser-2.36-7.el6.x86_64
--> Running transaction check
---> Package perl-URI.noarch 0:1.40-2.el6 will be installed
---> Package perl-libwww-perl.noarch 0:5.833-2.el6 will be installed
--> Processing Dependency: perl-HTML-Parser >= 3.33 for package: perl-libwww-perl-5.833-2.el6.noarch
--> Processing Dependency: perl(HTML::Entities) for package: perl-libwww-perl-5.833-2.el6.noarch
--> Processing Dependency: perl(Compress::Zlib) for package: perl-libwww-perl-5.833-2.el6.noarch
--> Running transaction check
---> Package perl-Compress-Zlib.x86_64 0:2.021-136.el6 will be installed
--> Processing Dependency: perl(IO::Uncompress::Gunzip) >= 2.021 for package: perl-Compress-Zlib-2.021-136.el6.x86_64
--> Processing Dependency: perl(IO::Compress::Gzip::Constants) >= 2.021 for package: perl-Compress-Zlib-2.021-136.el6.x86_64
--> Processing Dependency: perl(IO::Compress::Gzip) >= 2.021 for package: perl-Compress-Zlib-2.021-136.el6.x86_64
--> Processing Dependency: perl(IO::Compress::Base::Common) >= 2.021 for package: perl-Compress-Zlib-2.021-136.el6.x86_64
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.021 for package: perl-Compress-Zlib-2.021-136.el6.x86_64
---> Package perl-HTML-Parser.x86_64 0:3.64-2.el6 will be installed
--> Processing Dependency: perl(HTML::Tagset) >= 3.03 for package: perl-HTML-Parser-3.64-2.el6.x86_64
--> Processing Dependency: perl(HTML::Tagset) for package: perl-HTML-Parser-3.64-2.el6.x86_64
--> Running transaction check
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.021-136.el6 will be installed
---> Package perl-HTML-Tagset.noarch 0:3.20-4.el6 will be installed
---> Package perl-IO-Compress-Base.x86_64 0:2.021-136.el6 will be installed
---> Package perl-IO-Compress-Zlib.x86_64 0:2.021-136.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================================================================================================================
 Package                                                           Arch                                              Version                                                    Repository                                              Size
=============================================================================================================================================================================================================================================
Installing:
 perl-XML-Parser                                                   x86_64                                            2.36-7.el6                                                 rhel-source                                            224 k
Installing for dependencies:
 perl-Compress-Raw-Zlib                                            x86_64                                            1:2.021-136.el6                                            rhel-source                                             69 k
 perl-Compress-Zlib                                                x86_64                                            2.021-136.el6                                              rhel-source                                             45 k
 perl-HTML-Parser                                                  x86_64                                            3.64-2.el6                                                 rhel-source                                            109 k
 perl-HTML-Tagset                                                  noarch                                            3.20-4.el6                                                 rhel-source                                             16 k
 perl-IO-Compress-Base                                             x86_64                                            2.021-136.el6                                              rhel-source                                             69 k
 perl-IO-Compress-Zlib                                             x86_64                                            2.021-136.el6                                              rhel-source                                            136 k
 perl-URI                                                          noarch                                            1.40-2.el6                                                 rhel-source                                            117 k
 perl-libwww-perl                                                  noarch                                            5.833-2.el6                                                rhel-source                                            388 k

Transaction Summary
=============================================================================================================================================================================================================================================
Install       9 Package(s)

Total download size: 1.1 M
Installed size: 2.6 M
Is this ok [y/N]: y
Downloading Packages:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                                                        2.7 MB/s | 1.1 MB     00:00    
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Installing : perl-IO-Compress-Base-2.021-136.el6.x86_64                                                                                                                                                                                1/9
  Installing : perl-URI-1.40-2.el6.noarch                                                                                                                                                                                                2/9
  Installing : 1:perl-Compress-Raw-Zlib-2.021-136.el6.x86_64                                                                                                                                                                             3/9
  Installing : perl-IO-Compress-Zlib-2.021-136.el6.x86_64                                                                                                                                                                                4/9
  Installing : perl-Compress-Zlib-2.021-136.el6.x86_64                                                                                                                                                                                   5/9
  Installing : perl-HTML-Tagset-3.20-4.el6.noarch                                                                                                                                                                                        6/9
  Installing : perl-HTML-Parser-3.64-2.el6.x86_64                                                                                                                                                                                        7/9
  Installing : perl-libwww-perl-5.833-2.el6.noarch                                                                                                                                                                                       8/9
  Installing : perl-XML-Parser-2.36-7.el6.x86_64                                                                                                                                                                                         9/9
  Verifying  : perl-libwww-perl-5.833-2.el6.noarch                                                                                                                                                                                       1/9
  Verifying  : perl-Compress-Zlib-2.021-136.el6.x86_64                                                                                                                                                                                   2/9
  Verifying  : 1:perl-Compress-Raw-Zlib-2.021-136.el6.x86_64                                                                                                                                                                             3/9
  Verifying  : perl-URI-1.40-2.el6.noarch                                                                                                                                                                                                4/9
  Verifying  : perl-XML-Parser-2.36-7.el6.x86_64                                                                                                                                                                                         5/9
  Verifying  : perl-IO-Compress-Zlib-2.021-136.el6.x86_64                                                                                                                                                                                6/9
  Verifying  : perl-HTML-Tagset-3.20-4.el6.noarch                                                                                                                                                                                        7/9
  Verifying  : perl-IO-Compress-Base-2.021-136.el6.x86_64                                                                                                                                                                                8/9
  Verifying  : perl-HTML-Parser-3.64-2.el6.x86_64                                                                                                                                                                                        9/9

Installed:
  perl-XML-Parser.x86_64 0:2.36-7.el6                                                                                                                                                                                                       

Dependency Installed:
  perl-Compress-Raw-Zlib.x86_64 1:2.021-136.el6      perl-Compress-Zlib.x86_64 0:2.021-136.el6      perl-HTML-Parser.x86_64 0:3.64-2.el6       perl-HTML-Tagset.noarch 0:3.20-4.el6      perl-IO-Compress-Base.x86_64 0:2.021-136.el6    
  perl-IO-Compress-Zlib.x86_64 0:2.021-136.el6       perl-URI.noarch 0:1.40-2.el6                   perl-libwww-perl.noarch 0:5.833-2.el6    

Complete!
[root@localhost rpm]# rpm -ivh perl-XML-Simple-2.18-6.el6.noarch.rpm
Preparing...                ########################################### [100%]
   1:perl-XML-Simple        ########################################### [100%]

All about RPM

Install a RPM package

    rpm –ivh packagename.rpm


Upgrade a RPM package


    rpm –Uvh packagename.rpm


Verify a RPM package was installed

        rpm -qa | grep packagename
        locate packagename

Pluggable Databases (OMG)

Didn't know that Oracle12C brought dba work to a different level.

Anyway, with pluggable databases, things just got more complex.

Here are some good links:

http://www.dummies.com/how-to/content/how-to-create-new-pluggable-databases-in-oracle-12.html
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_basics/pdb_basics.html
http://oracle-base.com/articles/12c/multitenant-connecting-to-cdb-and-pdb-12cr1.php 


Anyway, after starting up the Oracle instance, remember to do the following:
ALTER PLUGGABLE DATABASE ALL OPEN;

Installing Oracle 12C on Linux

Here is a good link

Installing .Net3.5 on Windows 2012

This is important if you can't install .Net3.5 on Windows 2012, check this article:
http://www.askvg.com/fix-0x800f0906-and-0x800f081f-error-messages-while-installing-net-framework-3-5-in-windows-8/