Cognos returns error CM-SYS-5003 on startup, database connection test is fine

[gabbagabba]

Environment:
- Cognos 10.1 32 bit for Linux, running on 32 bit Debian Wheezy (the latest stable release), running on VMware Player, running on Microsoft Windows 7 Professional 64 bit, with 2-3 GB of allocated RAM.
- Content store: IBM DB2 Express-C 10.5 for Windows 64 bit, running on Microsoft Windows 7 Professional 64 bit.
- System specs: Lenovo ThinkPad T430 with Intel Core i5 CPU at 3.1 GHz, 8 GB of RAM, 320 GB 2.5" SATA hard disk.

As part of a Cognos training lab I'm supposed to run Cognos 10.1 32 bit on a Linux VM running on my work laptop. I try to start it from cogconfig.sh with a blank content store database running on the DB2 server. Testing the server connection works fine, and in fact I can perfectly connect to the database using the DB2 command line, but when attempting to start Cognos I invariably end up getting the following error:

"CM-SYS-5003 Content Manager is unable to access the content store. Verify your database connection parameters, and then contact your database administrator for assistance.  A table space could not be found with a page size of at least "4096" that authorization ID "DB2ADMIN" is authorized to use.. SQLCODE=-286, SQLSTATE=42727, DRIVER=3.65.77 Cause: A table space could not be found with a page size of at least "4096" that authorization ID "DB2ADMIN" is authorized to use.. SQLCODE=-286, SQLSTATE=42727, DRIVER=3.65.77".

I have tried with type 2 and type 4 database clients, didn't work. I have tried putting the DB2 admin user on the database credentials, didn't work. With type 2 client I tried dropping and recreating the database, didn't work.

Any idea of what's going on?

[MFGF]

Hi,

There are some configuration steps you need to do to set up DB2 as a content store database. Here is a checklist I work through when setting things up:

Create a new DB2 database called CCS
a. Right-click on All Databases in the navigation tree and select Create Database -> Standard...
b. In step 1 Name of the Create Database Wizard enter the following values
  i.    Enter Database name : CCS, leave all other defaults.
  ii.    Click on Next
c. In step 2 Storage, leave the defaults and click Next
d. In step 3 Region, choose the following values
  i.    Country/Region: default
  ii.    Code set: UTF-8
  iii.    Click Next
e. In step 4 Summary, you can see the database command by clicking on the Show Command button. Click Finish.
f. Wait for the database to be created then review the DB2 Message and make sure the creation was successful. Then click Close.


Expand All Databases -> CCS,  then create 2 buffer pools by right clicking on Buffer Pools and selecting Create... with the following values:
a. Create a 32K Buffer Pool
  i.    Buffer pool name: BUFFER_32K
  ii.    Page size: 32
  iii.    Enable self tuning: checked
  iv.    Click OK

b. Create a 4K Buffer Pool
  i.    Buffer pool name: BUFFER_4K
  ii.    Page size: 4
  iii.    Enable self tuning: checked
  iv.    Click OK

Create 3 table spaces by right-click on Table Spaces -> Create... with the following values:
a. Create a System Temporary table space
  i.    Name - Table space name: CCSSYSTEMP, click Next
  ii.    Type - Type: System temporary, click Next
  iii.    Buffer Pool - Buffer Pool: BUFFER_32K, click Finish
b. Create a User Temporary table space
  i.    Name - Table space name: CCSUSERTEMP, click Next
  ii.    Type - Type: User temporary, click Next
  iii.    Buffer Pool - Buffer Pool: BUFFER_4K, click Finish
c. Create a Regular table space
  i.    Name - Table space name: CCSREGSPACE, click Next
  ii.    Type - Type: Regular, click Next
  iii.    Buffer Pool - Buffer Pool: BUFFER_4K, click Finish

You might also need to copy the DB2 JDBC driver files into your install of Cognos 10:

Copy the DB2 JDBC drivers to the Cognos p2pd/WEB-INF/lib folder
a.    Copy db2java.zip, db2jcc.jar and db2jcc_license_cu.jar to <install folder>/webapps/p2pd/WEB-INF/lib folder.
b.    Rename db2java.zip to db2java.jar

Good luck!!

MF.