analytics/configuration/schemas/content/db2/createDb.sql.template

-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2010
--
-- US Government Users Restricted Rights - Use, duplication or disclosure
-- restricted by GSA ADP Schedule Contract with IBM Corp.

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).

-- Use this template to create the IBM Cognos content database. Replace these variables:  
-- @DBNAME@ : Database name
-- @DBUSERID@ : User ID, this account is used by the product to connect to the content store
-- This script must be run as a user that has sufficient privileges to access and create the database. 
-- The database user account meeds to exist for the product to function.

CREATE DATABASE @DBNAME@ AUTOMATIC STORAGE YES ALIAS @DBNAME@ USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM PAGESIZE 8192;
CHANGE DATABASE @DBNAME@ COMMENT WITH 'IBM Cognos Content Store';
CONNECT TO @DBNAME@;
UPDATE DATABASE CONFIGURATION USING APPLHEAPSZ 1024 DEFERRED;
UPDATE DATABASE CONFIGURATION USING LOCKTIMEOUT 240 DEFERRED; 
CONNECT RESET;

CONNECT TO @DBNAME@;
CREATE BUFFERPOOL @DBNAME@_08KBP IMMEDIATE SIZE 1000 PAGESIZE 8K;
CREATE BUFFERPOOL @DBNAME@_32KBP IMMEDIATE SIZE 1000 PAGESIZE 32K;
CONNECT RESET;

CONNECT TO @DBNAME@;
CREATE SYSTEM TEMPORARY TABLESPACE TSN_SYS_@DBNAME@ IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32K BUFFERPOOL @DBNAME@_32KBP;
CREATE USER TEMPORARY TABLESPACE TSN_USR_@DBNAME@ IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8K BUFFERPOOL IBMDEFAULTBP;
CREATE REGULAR TABLESPACE TSN_REG_@DBNAME@ IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8K BUFFERPOOL @DBNAME@_08KBP; 
DROP TABLESPACE USERSPACE1;
CONNECT RESET;

CONNECT TO @DBNAME@;
CREATE SCHEMA db2COGNOS AUTHORIZATION @DBUSERID@;
COMMENT ON SCHEMA db2COGNOS IS 'IBM Cognos Content Store';
GRANT CREATETAB,BINDADD,CONNECT,IMPLICIT_SCHEMA ON DATABASE  TO USER @DBUSERID@;
GRANT CREATEIN,DROPIN,ALTERIN ON SCHEMA DB2COGNOS TO USER @DBUSERID@;
GRANT USE OF TABLESPACE TSN_USR_@DBNAME@ TO USER @DBUSERID@;
GRANT USE OF TABLESPACE TSN_REG_@DBNAME@ TO USER @DBUSERID@;
CONNECT RESET;