Cognos Analytics

 View Only

 History audit data after an upgrade

Jump to  Best Answer
Mack L's profile image
Mack L posted 08/12/26 11:51 AM

Hi,

When upgrading from one major version to another, Cognos 11.1.x to 12.1.x, how do we preserve audit data history especially when the upgrade is done using the clean install method. We intend to keep the current version (11.1.x) even after the go live of 12.1.x for  some days. The requirement is to have audit data history when I access the audit package in the new cognos environment (12.1.x).

Best Regards,

Abbas Alnamar's profile image
Abbas Alnamar IBM Champion posted 08/14/26 10:19 AM  Best Answer
Hi Mack,
 
Yes, I did this exact same thing when upgrading from 11.2.4 to 12.0.4 (and now 12.1.3) using SQL Server. 
 
Just a heads up when you point Cognos 12 to the copied DB for the first time, it has to upgrade the database schema. If your database is huge, the initial startup will take a while. Don't worry if it looks like it's hanging just let it run.
 
As always, make sure you take a Database full backup and a servers snapshot before hitting the switch!
Thank you,
Abbas
Ralf Roeber's profile image
Ralf Roeber IBM Champion posted 08/12/26 11:57 AM

Hello Mack,

we migrate data from old audit DB. 

Last month we finished a migration from 11.x to 12.1x with switching the database from db2 to postgres.

And we just migrated the data.

Let me know, if you need help with that.

Abbas Alnamar's profile image
Abbas Alnamar IBM Champion posted 08/12/26 12:04 PM

Hello Mack,

To keep your audit history while both environments are running, your best bet is to make a copy of the current audit database and point Cognos 12.1.x to that new copy. You definitely don't want both versions hitting the exact same live database at the same time, or you'll run into schema conflicts and locking issues.

Thank you,

Abbas

Mack L's profile image
Mack L posted 08/13/26 10:51 AM

Hi @Abbas Alnamar,

Thank you. Would like to know if this has been tried successfully so far. Is there a chance of running into problems with audit after using a copy of the previous Audit db for the new 12.1.x version?

Best Regards,

Related Content