Follow the steps below if you want to create another content store database using Cognos Content Database. This may be required if you install more than one instance of your IBM Cognos 8 product in one location and you want to run the instances separately.
Before you create the new content store, do the following:
Install the additional instance of your IBM Cognos 8 product in a separate directory on the same computer.
Ensure that you select Cognos Content Database on the Component Selection page of the installation wizard.
Create a new user and password for the new content store database.
In the location where you installed the new instance of Cognos Content Database, in the c8_location\derby10.1.2.1\bin directory, use the ij.bat or ij.ksh script to create a new database.
Use the following syntax:
connect 'jdbc:derby://host:port/db_name;create=true;user=username; password=password';
Ensure that you use a different name, user, and password for the new content store.
For example, to create a database named contentstore2 on the localhost computer on port number 1527 as a user named cognos2 with a password of cognos2, you would type
connect 'jdbc:derby://localhost:1527/contentstore2;create=true;user=cognos2;password=cognos2';
The database name is case-sensitive.
The database files are located in the c8_location\contentstore directory.
When you are finished with the ij utility, disconnect by using the following command:
disconnect;