Cognos default Content Store Derby database

If you install Cognos Content Database, the default database that is created is given a user ID and password. It is recommend that you change this user ID and password.

Administration tasks for Cognos Content Database are performed using a utility named ij. The documentation for derby is available in the c8_location\derby10.1.2.1\docs directory where you installed Cognos Content Database.

Steps to Change the Default User Password

1. On the computer where you installed Cognos Content Database, go to the c8_location\derby10.1.2.1\bin directory.

2. Start the ij utility using the ij.bat or ij.ksh script file.

   The ij utility is a command line utility for creating and managing Cognos Content Database.

3. Connect to the default database by typing the following ij utility command:

   connect 'jdbc:derby://localhost:1527/cm;user=cognos;password=cognos';

   If you changed the port number from the default 1527, use the correct port number for your Cognos Content Database.

   The default database is named cm. The database name is case sensitive.

4. Change the default password for the cognos user by typing the following ij utility command:

   CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.cognos', 'NewPassword');

   The new password must be used for the next connection to the database.

5. Close the ij utility by typing the following command:

   disconnect;

Steps to Create a New User and Password

1. On the computer where you installed Cognos Content Database, go to the c8_location\derby10.1.2.1\bin directory.

2. Start the ij utility using the ij.bat or ij.ksh script file.

3. Connect to the default database by typing the following ij utility command:

   connect 'jdbc:derby://localhost:1527/cm;user=cognos;password=cognos';

   If you changed the port number from the default 1527, use the correct port number for your Cognos Content Database.

   The default database is named cm. The database name is case sensitive.

4. Create a new user by typing the following ij utility command:

   CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.NewUser', 'NewUserPassword');

5. Give the new user full access to the database by typing the following ij utility command:

   CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.database.fullAccessUsers','cognos, NewUser');

   The property that you are changing, the list of users, is a comma-delimited field. In this step, you are including the new user in the list of users with full access. The default user, cognos, is still part of the list of users with full access. You can remove the cognos user.

6. Close the ij utility by typing the following command:

   disconnect;

Steps to Remove a User

1. On the computer where you installed Cognos Content Database, go to the c8_location\derby10.1.2.1\bin directory.

2. Start the ij utility using the ij.bat or ij.ksh script file.

3. Connect to the default database by typing the following ij utility command:

   connect 'jdbc:derby://localhost:1527/cm;user=NewUser; password=NewUserPassword';

4. Choose the kind of user that you want to remove:

   • To remove a user from the list of users with full access, type the following ij utility command:

     CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.database.fullAccessUsers', 'NewUser');

     You omit the user name from the list of users with full access. For example, the above command removes the default cognos user and keeps the new user that you just created.

   • To remove a user from the database, type the following ij utility command and omit the user password:

     CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.cognos', '');

     This command removes the password for the default cognos user, which also removes the user from the database.

5. Close the ij utility by typing the following command:

   disconnect;