Creating a content store and starting Cognos Analytics on Linux or AIX

The information that you enter in IBM® Cognos® Configuration for Cognos Analytics is used to generate a script that you use to create the content store database.

  1. Create the content store for Cognos Analytics.
    1. Enter the following commands to start IBM Cognos Configuration: 
      cd <Cognos_installation_dir>/bin64/
. /home/db2inst1/sqllib/db2profile
./cogconfig.sh
      Notice the space between the . and the / in the second command.
      Tip:

      It's recommended to source-in the db2profile ( . /home/db2inst1/sqllib/db2profile) anytime you are going to start IBM Cognos Configuration.

    2. In the Explorer window, expand Data Access > Content Manager and click Content Store.
    3. In the Database server and port number property, enter localhost or the fully qualified domain name of the computer where Db2® is installed.
      For example, localhost:25000 or FQDN_Of_Your_Machine:25000 where 25000 is the default port number that is used by Db2. If you are using a different port number (for example, 50000), ensure that you use that value. To determine the port that is used by Db2, examine the varDBPort parameter in the installation_dir/config/InstallVariable.properties file.
    4. In the User ID and password property, enter the user name of the owner of the Db2 instance where the content store database is located and the password that is associated with that user name.
    5. In the Database name property, verify that the default value is cm.
    6. From the File menu, click Save.
    7. In the Explorer window, go to Data Access > Content Manager and click Content Store.
    8. Right-click Content Store and click Generate DDL.
    9. In the informational window, click Close.
    10. While you are logged in to the Linux® or AIX® operating system as the root user, switch to the user that is the Db2 instance owner (for example, db2inst1).
    11. Enter the following Db2 command: 
      db2 -tvf Cognos_installation_dir/configuration/schemas/content/db2/createDb.sql
      If the results of this command contain the following similar messages, you can safely ignore those messages because the Db2 instance owner already has the necessary privileges:
      GRANT CREATETAB,BINDADD,CONNECT,IMPLICIT_SCHEMA ON DATABASE TO USER db2inst1
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0554N  An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502
      GRANT CREATEIN,DROPIN,ALTERIN ON SCHEMA DB2COGNOS TO USER db2inst1
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0554N  An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502

      GRANT USE OF TABLESPACE TSN_USR_cm TO USER db2inst1
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0554N  An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502
      GRANT USE OF TABLESPACE TSN_REG_cm TO USER db2inst1
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0554N  An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502
    12. Go back to the root user.
    13. From the Actions menu, click Test.
      You are testing the connection between Content Manager and the content store database.
    14. In the informational window, click Close.

      For more information, see Generating a script file to create a database for a Db2 content store.

  2. Start Cognos Analytics (Content Manager and application services).
    1. In IBM Cognos Configuration, in the Explorer window, click Local Configuration.
    2. From the Actions menu, click Test.
      Tip: If you are not configuring Cognos Analytics to send notifications, you can ignore the testing the mail server connection failure message. If there is a failure related to NIST SP800-131A conformance, click Details in the dialog to see more information. The integration between Cognos Analytics and IBM Spectrum® Control is not affected by this setting.
    3. From the Actions menu, click Start.
  3. When Cognos Analytics starts, exit IBM Cognos Configuration.