How to uninstall the Cognos Content Database

Technote (troubleshooting)

Problem(Abstract)

If you configured your IBM Cognos environment to use the Cognos Content Database, otherwise known as Derby, as your Content Store and you would like to uninstall it and use a supported database application for you Content Store.

Resolving the problem

1) - On the computer where you installed Cognos Content Database, go to the cognosroot_location\bin directory, and type the following command:

• On Windows, type

derby.bat uninstall

This command removes the Cognos Content Database service.

• On UNIX, type

derby.sh stop

This command stops the Cognos Content Database service.

2) - In the cognosroot_location directory, delete the derby10.* directory.

3) - In the cognosroot_location\bin directory, delete the following files:

• On Windows, derby.bat
• On UNIX, derby.sh and derbyenv.sh

4) - On Windows, in the cognosroot_location\logs directory, delete the derby.service file.

5) - In the cognosroot_location directory, open the cmplst.txt file in a text editor.

6) - Remove lines containing Cognos Content Database values. The lines contain CCD and CMDERBY. For example:

C8BISRVRCCD_version=

C8BISRVRCCD_name=

CCD_version=

CCD_name=

CMDERBY_version=

CMDERBY_name=

Tip: You can also comment the lines out by inserting # at the start of each line.

7) - Save the file.

8) - Start IBM Cognos Configuration.

9) - Under Data Access, Content Manager, do the following:

• Delete the Cognos Content Database.
• Configure a new database resource to point to a new content store

10) - Restart IBM Cognos BI.