If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Fix Pack 4 Installation guidance on Cognos 10.1.1

Started by Ravisha, 27 Jan 2016 08:29:29 PM

Previous topic - Next topic

Ravisha

We have a standalone installation of Cognos 10.1.1 (Prod) and the content store DB is on a different server.

We've been having database connectivity issues lately. Upon contacting IBM, we've been told to install Fix Pack 4 to eliminate db connectivity issues to Microsoft SQL Server 2012. The users are facing this issue/error while running the report. But when they re-run it, they aren't facing OLEDB database connectivity errors.

So, I would like to know what steps I need to follow before I install fix pack 4. Since we have a standalone application, we have to install it directly in the prod environment. If there is a need for backups, what sort of backups would they be? and If something fails, how would I roll back it ?

Your answers are appreciated

cognoslearner1


Ravisha

Hello

Thanks a lot for your valuable advice. I truly appreciate it. :)

I have a question regarding exporting and importing the cognos content through administration portal. I would like to know how it varies when compared to making a backup copy of Content store database?

If I install a new version of cognos (10.2) and point it to blank database (content store); upon starting the services, cognos will automatically create table structures right? Now, when I import the cognos content 10.1 backup (from deployment folder), will the cognos automatically update with the new data in the underlying tables in content store DB ? is this one of the processes of upgrading cognos?

Your input is highly appreciated.


cognoslearner1

#3
Yes the method which you mentioned can be used for up gradation of cognos it is called "lift and shift " method.
Details of different methods are given in the below link.
http://www.envisn.com/envisn-cognos-blog/bid/45290/Planning-A-Successful-Cognos-Migration

There are 2 ways to backup content store.
1- Take back up from the Cognos admin portal.
2- Ask your DBA to take a cold backup of CS db.

First method is used when your not sure the db and version your going to use in the upgradation.
Second method is used when there is same db flavour is being used for upgradation.

-- Cognoslearner1

Ravisha