点击Next
点击Next
点击OK
2. Cognos配置
2.1 准备COGNOS的资料库(Content Store)
?
如果Contetent Store采用DB2,需要准备一个UTF8字符集的数据库。 脚本参考如下:
CREATE DATABASE dwcognos AUTOMATIC STORAGE YES ON 'C:\\' DBPATH ON 'C:\\' USING CODESET UTF-8 TERRITORY CN COLLATE USING SYSTEM PAGESIZE 4096; connect to dwcognos; --change db parameter
update db cfg using locktimeout 240; update db cfg using applheapsz 1024;
CREATE BUFFERPOOL COGNOSBF32K IMMEDIATE SIZE 8000 PAGESIZE 32 K ; CREATE SYSTEM TEMPORARY TABLESPACE COGNOSTSP_SYS PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL COGNOSBF32K ;
CREATE USER TEMPORARY TABLESPACE COGNOSTSP_USER PAGESIZE 4 K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL IBMDEFAULTBP ;
CREATE REGULAR TABLESPACE COGNOS_USER_REGU PAGESIZE 4 K MANAGED BY ?
拷贝DB2_installation/java下的db2java.zip db2jcc.jar db2jcc_license_cu.jar 三个文件拷贝到cognos 安装目录c8_location/webapps/p2pd/WEB-INF/lib 下,重命名db2java.zip为db2java.jar
2.2 准备好COGNOS的安全认证源(在此采用SUN ONE)
Sun one安装步骤详见:准备好COGNOS的资料库(Content Store) 在Sun one中建立所需用户
2.3 运行cognos Configration
进入程序?IBM Cognos 8?IBM Cognos Configuration 进行Cognos 8的设置
?
配置资料库
如上图,删除默认的Content Store
如上图,配置新的Content Manage