IBM Support

How to move a database with Content Store and Datawarehouse to another server in Cognos Analytics

Question & Answer


Question

This document provides the general steps for planning move of the Content Store and Datawarehouse from one server to a new server. It is assumed the IBM Cognos Analytics Installation stays on the same server. If the IBM Cognos Analytics Installation is moving to another server, additional steps are required for a successful migration.

Cause

Need a description of the process or a checklist of what needs to change and be done in the current environment to re-map or re-point reports, cube models etc. to the new Datawarehouse server.

Answer

Important Notes before trying the steps:

i) Make sure the DBA has made a backup of the Content store before the migration.
ii) Confirm that your new database version is supported for your version of Cognos. Please consult the Supported environment page with the most up to date information for your version of Cognos.

1. Make sure Cognos has proper permission to the new Datawarehouse server Database.

2. Before the migration, it is a good practice to run a Content Store maintenance task to remove inconsistencies within the Content Store due to deleted or non-existing user accounts: Content store maintenance tasks
 

Make sure the content store is migrated properly using either the content store deployment (Export all) from Cognos Administration:
Deploying the Entire Content Store

or from the database side using database specific tools.

3. In the Cognos Configuration, on the Content Manager, point to the new server with the Content Store database and port number:

4. Test this Content store by a right-click, if this tests successfully, Cognos is properly able to connect to your Content store.

5. Restart Cognos and import the deployment of your Cognos Content Store.

6. In Cognos Administration, after all the datasources have been imported, edit each of the datasource to point to the new server for the datawarehouse database and test the connections.

These should get your Cognos back up and running.

Framework Manager and Transformer do not need any modifications as they point to the Gateway and dispatcher URIs for Cognos. They connect to your database via these URIs and since these aren't changing, they should work properly without any changes.

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
10 July 2024

UID

swg22000738

Page Feedback