COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: lifzgud on 29 Oct 2012 09:25:31 AM

Title: Migrating a Content Store from DB2 9.5 to 9.7
Post by: lifzgud on 29 Oct 2012 09:25:31 AM
Hi guys ,

I am trying to migrate the cognos content store for 8.3 from DB2 9.5 to DB2 9.7
We have to migrate the whole database from 9.5 to 9.7 anyways as part of an activity . This will include migrating the cognos schema as well in which the content store was present.

Considering that application server on which cognos was installed does not change and only the database has changed , what all steps would I need to do to make the reports work again from the new Database. All the DSNs will also be taken care of as a separate activity to point to DB2 9.7 tables

Would I just have to change the content store settings in cognos configuration? or would I have to take a complete export of the content store from cognos administration and import it back again anyways.

Regards,
Anirban