This script generates a DB2 database which can be use as a Cognos content store.
------------------------------------------------------------------------
-- This file will setup the Cognos Content Store database for Cognos --
-- Developed by CogKnowHow.com --
-- Date : 13-02-2008 --
------------------------------------------------------------------------
CREATE DATABASE COGNOS AUTOMATIC STORAGE YES ON 'C:\' ALIAS COGNOS USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM PAGESIZE 32768 WITH 'Cognos DB';
CONNECT TO COGNOS;
CREATE SCHEMA "DB2COGNOS" AUTHORIZATION DB2INST1;
------------------------------------
-- DDL Statements for BUFFERPOOLS --
------------------------------------
CREATE BUFFERPOOL "COGNOS_04KBP" SIZE 250 PAGESIZE 4096;
CREATE BUFFERPOOL "COGNOS_08KBP" SIZE 250 PAGESIZE 8192;
CREATE BUFFERPOOL "COGNOS_16KBP" SIZE 250 PAGESIZE 16384;
CREATE BUFFERPOOL "COGNOS_32KPB" SIZE 250 PAGESIZE 32768;
CONNECT RESET;
CONNECT TO COGNOS;
------------------------------------
-- DDL Statements for TABLESPACES --
------------------------------------
CREATE TEMPORARY TABLESPACE TSN_SYS_COGNOS IN DATABASE PARTITION GROUP IBMTEMPGROUP
PAGESIZE 32768 MANAGED BY AUTOMATIC STORAGE
EXTENTSIZE 16
PREFETCHSIZE 16
BUFFERPOOL COGNOS_32KPB
OVERHEAD 12.670000
TRANSFERRATE 0.180000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY OFF;
CREATE USER TEMPORARY TABLESPACE TSN_USR_COGNOS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 16384 MANAGED BY AUTOMATIC STORAGE
EXTENTSIZE 16
PREFETCHSIZE 16
BUFFERPOOL COGNOS_16KBP
OVERHEAD 10.500000
TRANSFERRATE 0.140000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY OFF;
CREATE REGULAR TABLESPACE TSN_REG_COGNOS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 16384 MANAGED BY AUTOMATIC STORAGE
AUTORESIZE YES
INITIALSIZE 32 M
MAXSIZE NONE
EXTENTSIZE 16
PREFETCHSIZE 16
BUFFERPOOL COGNOS_16KBP
OVERHEAD 10.500000
TRANSFERRATE 0.140000
DROPPED TABLE RECOVERY ON;
---------------------------------------
-- Authorization Statements on Schemas
---------------------------------------
GRANT CREATEIN ON SCHEMA "DB2COGNOS" TO USER "DB2USER" WITH GRANT OPTION;
GRANT DROPIN ON SCHEMA "DB2COGNOS" TO USER "DB2USER" WITH GRANT OPTION;
GRANT ALTERIN ON SCHEMA "DB2COGNOS" TO USER "DB2USER" WITH GRANT OPTION;
----------------------------------------
-- Authorization Statements on Database
----------------------------------------
GRANT CREATETAB ON DATABASE TO USER "DB2USER" ;
GRANT BINDADD ON DATABASE TO USER "DB2USER" ;
GRANT CONNECT ON DATABASE TO USER "DB2USER" ;
GRANT IMPLICIT_SCHEMA ON DATABASE TO USER "DB2USER" ;
---------------------------------------
-- Authorization statement on table space
---------------------------------------
GRANT USE OF TABLESPACE "TSN_USR_COGNOS" TO USER "DB2USER" ;
COMMIT WORK;
CONNECT RESET;
TERMINATE;
;
www.cogknowhow.com