How create content store in DB2?

by ·0 Comments

Product:
Cognos Analytics 11.0.6
Microsoft Windows 2012 server
DB2 11.1.1 database server

Problem:
How create a content store in DB2?

Solution:
Install Cognos Analytics 11 on the windows server.
Install DB2 11 on the database server, ensure the local administrator is administrator on the db2 database to.

From the DB2 server copy the jar files needed from folder
C:\Program Files\IBM\SQLLIB\java. Place the two files
d2jcc_license_cu.jar
db2jcc4.jar
in folder c:\program files\ibm\cognos\analytics\drivers on the Cognos BI server.

Start Cognos Configuration and setup up the values for the environment.
On the Content Store tab enter the values for the DB2:
database server and port number: Enter ipadress:50000
User id and password: Enter the namn and password you want the schema to have.
Database name: Enter the name of the database you want it to have.

Click save.
Right click on Content store and select “Generate DDL”.
This will create a SQL script you should run on the DB2 server to create the needed database.
Copy the file C:/Program Files/ibm/cognos/analytics/configuration/schemas/content/db2/createDb.sql to the DB2 server.
Place the file in folder c:\install.

On the DB2 server login as Windows administrator.
Start a DB2 Command Windows – Administrator.
Enter this command:
db2 -tvf c:\install\createDb.sql

This will run the steps to create the content store database.
Will be similar to this;

CREATE DATABASE cm AUTOMATIC STORAGE YES ALIAS cm USING CODESET UTF-8 TERRITORY
US COLLATE USING SYSTEM PAGESIZE 8192
DB20000I Kommandot CREATE DATABASE har utförts.
CHANGE DATABASE cm COMMENT WITH ‘IBM Cognos Content Store’
DB20000I Kommandot CHANGE DATABASE COMMENT har utförts.
CONNECT TO cm
Information om databasanslutning
Databasserver = DB2/NT64 11.1.1.1
SQL-användar-ID = ADMINIST…
Lokalt databasalias = CM
UPDATE DATABASE CONFIGURATION USING APPLHEAPSZ 1024 DEFERRED
DB20000I Kommandot UPDATE DATABASE CONFIGURATION har utförts.
UPDATE DATABASE CONFIGURATION USING LOCKTIMEOUT 240 DEFERRED
DB20000I Kommandot UPDATE DATABASE CONFIGURATION har utförts.
CONNECT RESET
DB20000I Kommandot SQL har utförts.
CONNECT TO cm
Information om databasanslutning
Databasserver = DB2/NT64 11.1.1.1
SQL-användar-ID = ADMINIST…
Lokalt databasalias = CM
CREATE BUFFERPOOL cm_08KBP IMMEDIATE SIZE 1000 PAGESIZE 8K
DB20000I Kommandot SQL har utförts.
CREATE BUFFERPOOL cm_32KBP IMMEDIATE SIZE 1000 PAGESIZE 32K
DB20000I Kommandot SQL har utförts.
CONNECT RESET
DB20000I Kommandot SQL har utförts.
CONNECT TO cm
Information om databasanslutning
Databasserver = DB2/NT64 11.1.1.1
SQL-användar-ID = ADMINIST…
Lokalt databasalias = CM
CREATE SYSTEM TEMPORARY TABLESPACE TSN_SYS_cm IN DATABASE PARTITION GROUP IBMTEM
PGROUP PAGESIZE 32K BUFFERPOOL cm_32KBP
DB20000I Kommandot SQL har utförts.

When the database is finish created in DB2 server, then go to the Cognos Analytics 11 server and from inside Cognos Configuration click on START. This will start the Cognos BI service, and connect it to the database and create the tables needed.

The Cognos status will show this for a successful start;
[Launching a JVM using ‘Maximum memory in MB’]
Successfully launched a test JVM with the memory setting of ‘4096’. Note that this does not guarantee that the IBM Cognos service will start and run successfully.

To see which JVM options are based on this setting, view ibmcognos_location/bin64/bootstrap_wlp_.xml and see your JVM documentation for an explanation of those options.

[Archive Local File System Root]
Since the value is empty, the feature is disabled. There is nothing to test.

[Validate mail server properties.]
[ ERROR ] The mail server cannot be reached.

[Archive Local File System Root]
Since the value is empty, the feature is disabled. There is nothing to test.

[Start Service]
21:21:53, ‘LogService’, ‘StartService’, ‘Success’.
21:21:54, CAF-WRN-0010 CAF input validation enabled.
21:21:54, CAF-WRN-0021 CAF Third Party XSS checking disabled.
21:22:06, ”, ‘StartService’, ‘Success’.
21:22:08, CM-SYS-2057 Creating content store tables (schema version 7.0045).
21:22:16, CM-SYS-2215 A Content Manager internal PRECACHEINITACTIONS task started.
21:22:16, CM-SYS-2216 A Content Manager internal PRECACHEINITACTIONS task is complete.
21:22:16, CM-SYS-2093 The Content Manager cache initialization is complete. 1 objects loaded in 0,11 seconds.
21:22:17, CM-SYS-2216 A Content Manager internal POSTINITACTIONS task is complete.
21:22:16, CM-SYS-2215 A Content Manager internal POSTINITACTIONS task started.
21:22:39, CM-SYS-5159 Content Manager is running in active mode.
21:22:39, ‘ContentManagerService’, ‘StartService’, ‘Success’.
21:22:39, CM-SYS-2215 A Content Manager internal CMUPGRADESCRIPT task started.
21:22:41, DPR-DPR-1002 Successfully registered the dispatcher http://winca:9300/p2pd in Content Manager.
21:22:43, ‘idVizService’, ‘StartService’, ‘Success’.
21:23:25, ‘SACamService’, ‘StartService’, ‘Success’.
21:23:24, ‘camAsyncService’, ‘StartService’, ‘Success’.
21:23:27, ”, ‘Run’, ‘Run’.
21:23:34, ‘AnnotationService’, ‘StartService’, ‘ANN DB Validation successful.’.
21:23:34, ”, ‘Run’, ‘Run’.
21:23:36, ‘EventService’, ‘StartService’, ‘NC DB Validation successful.’.
21:23:43, ‘HumanTaskService’, ‘StartService’, ‘HTS DB Validation successful.’.
21:23:49, ‘zipiService’, ‘StartService’, ‘Success’.
21:23:49, ‘PDC’, ‘StartService’, ‘Success’.
21:23:50, ‘PresentationService’, ‘StartService’, ‘Success’.
21:23:51, Start a cgsLauncher because the start count 1 is larger than 0.
21:23:51, ‘BUX Service’, ‘StartService’, ‘Success’.
21:24:04, ‘RepositoryService’, ‘StartService’, ‘Success’.
21:24:04, ‘burstDistributionService’, ‘StartService’, ‘Success’.
21:24:04, ‘GraphicsService’, ‘StartService’, ‘Success’.
21:24:41, ‘QueryService’, ‘StartService’, ‘Success’.
21:24:48, ‘QueryService’, ‘StartService’, ‘Success’.
21:24:55,
21:24:55, ‘ReportService’, ‘StartService’, ‘Success’.
21:24:55, ‘visualisationGalleryService’, ‘StartService’, ‘Success’.
21:25:13, ‘camAsyncAA’, ‘StartService’, ‘Success’.
21:25:13, ‘ReportDataService’, ‘StartService’, ‘Success’.
21:25:14, ‘relationalMetadataService’, ‘StartService’, ‘Success’.
21:25:13, ‘Fragment Server Service’, ‘StartService’, ‘Success’.
21:25:14, ‘SACamSrvcInternal’, ‘StartService’, ‘Success’.
21:25:14, ‘QLSService’, ‘StartService’, ‘Success’.
21:25:13, ‘SystemService’, ‘StartService’, ‘Success’.
21:25:14, ‘BatchReportService’, ‘StartService’, ‘Success’.
21:25:13, ‘MobileService’, ‘StartService’, ‘Success’.
21:25:13, ‘ContentManagerCacheService’, ‘StartService’, ‘Success’.
21:25:13, ‘CacheService’, ‘StartService’, ‘Success’.
21:25:14, ‘QLSImportService’, ‘StartService’, ‘Success’.
21:25:14,
21:25:14, ‘SACamSrvc’, ‘StartService’, ‘Success’.
21:25:14, ‘idVizServer’, ‘StartService’, ‘Success’.
21:25:15, ‘MetadataService’, ‘StartService’, ‘Success’.
21:25:14, ‘idVizServer’, ‘StartService’, ‘Success’.
21:25:14, ‘DeliveryService’, ‘StartService’, ‘Success’.
21:25:14, ‘SMDService’, ‘StartService’, ‘Success’.
21:25:14, ‘QLSBIService’, ‘StartService’, ‘Success’.
21:25:14, ‘idVizService’, ‘StartService’, ‘Success’.
21:25:14, ‘idVizService’, ‘StartService’, ‘Success’.
21:25:15, ‘HumanTaskService’, ‘StartService’, ‘Success’.
21:25:15, ‘AnnotationService’, ‘StartService’, ‘Success’.
21:25:15, ‘MonitorService’, ‘StartService’, ‘Success’.
21:25:15, ‘AgentService’, ‘StartService’, ‘Success’.
21:25:15, ‘JobService’, ‘StartService’, ‘Success’.
21:25:15, ‘EventService’, ‘StartService’, ‘Success’.
21:25:25, ‘CPS Producer Registration Service’, ‘StartService’, ‘Success’.
21:25:26, ‘Dispatcher’, ‘Start’, ‘Success’.
21:25:31, ”, ”, ‘Success’.
21:25:56, ”, ‘Run’, ‘Run’.
21:25:56, ”, ‘Run’, ‘Run’.
21:25:56, ”, ‘Run’, ‘Run’.
21:25:56, ”, ‘Run’, ‘Run’.
21:25:56, ”, ‘Run’, ‘Run’.