Creating a content store and starting Cognos Analytics on Windows

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. From the Windows Start menu, select IBM Cognos Analytics > IBM Cognos Configuration.
    2. In the Explorer window, expand Data Access > Content Manager and click Content Store.
    3. In the Type property, enter DB2 database.
    4. In the Database server and port number property, enter localhost or the fully qualified domain name of the machine 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.
    5. In the User ID and password property, enter the user name of the owner of the Db2 instance where the content store database will be located and the password that is associated with that user name.
      Typically, this user name is db2admin. If the user name is a Windows™ domain user name, enter the user name without a Windows domain name prefix or suffix.
    6. In the Database name property, verify that the default value is cm.
    7. From the File menu, click Save.
    8. In the informational window, click Close.
    9. In the Explorer window, expand Data Access > Content Manager and click Content Store.
    10. Right-click Content Store and click Generate DDL.
    11. In the informational window, click Close.
    12. From the Windows Start menu, select IBM Db2 Db2COPY1 (Default) > Db2 Command Window - Administrator. Then, enter the following command: 
      db2 -tvf "Cognos_installation_dir\configuration\schemas\content\db2\createDb.sql"
      On Windows, add quotes around the directory path if it contains spaces. For example: 
      db2 -tvf "C:\Program Files\IBM\Cognos\analytics\configuration\schemas\content\db2\createDb.sql"
      This process might take a few minutes.
    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).

    It might take Cognos Analytics a few minutes to start.

    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. Exit IBM Cognos Configuration.