cognos8.3sample导入DB2资料整理

xiaoerp

step1:创建数据库（此数据库也可作为cognos服务器的content db）

• db2 CREATE DATABASE gs_db AUTOMATIC STORAGE YES ON 'C:\' DBPATH ON 'C:\' USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM PAGESIZE 32768
• db2 connect to gsdb user db2admin using db2admin
• db2 UPDATE DATABASE CONFIGURATION USING APPLHEAPSZ 1024 AUTOMATIC IMMEDIATE
• db2 UPDATE DATABASE CONFIGURATION USING LOCKTIMEOUT 240 DEFERRED
• db2 CREATE BUFFERPOOL COGBUF IMMEDIATE SIZE 250 PAGESIZE 32 K
• db2 CREATE SYSTEM TEMPORARY TABLESPACE COGSTEMP PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 32 OVERHEAD 10.5 PREFETCHSIZE 32 TRANSFERRATE 0.14 BUFFERPOOL COGBUF
• db2 CREATE USER TEMPORARY TABLESPACE COGUTEMP PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 32 OVERHEAD 10.5 PREFETCHSIZE 32 TRANSFERRATE 0.14 BUFFERPOOL COGBUF
  

复制代码

step2:给db2admin用户赋予管理员权限
step3:创建schema

• create schema gosales;
• create schema gosalesdw;
• create schema gosaleshr;
• create schema gosalesrt;
• create schema gosalesmr;
  

复制代码

step4:修改codepage

• db2set db2codepage=1252
• db2 terminate
  

复制代码

step5:执行db2move命令载入数据

• 打开db2命令编辑器后输入
• cd c:\congos\c8\webcontent\samples\datasources\db2\GS_DB>db2move gs_db import -u db2admin -p db2admin
  

复制代码

step6:修改gs_db_modify.sql文件的用户名和密码为db2admin,然后执行gs_db_modify.bat
sample导入DB2数据库操作就完成了。