Cognos import sample DB with DB2

Run:

C:/Program Files/IBM/cognos/c8/webcontent/samples/datasources/db2/GS_DB>DB2MOVE cogsam83 IMPORT -u cogsam83admin -p admin1234

 

 

Error:

* IMPORT:  table "GOSALESHR"."SATISFACTION_INDEX"
***ERROR -332.  Check message file tab132.msg!
***  SQLCODE:  -332  -  SQLSTATE:  57017
***  SQL0332N  不支持从源代码页 "1252" 到目标代码页 "1386" 的字符转换。  SQLSTATE=57017

 

Solution:

 

db2set db2codepage=1252

db2 terminate

db2 connect to cogsam83 user cogsam83admin using admin1234

 

C:/Program Files/cognos/c8/webcontent/samples/datasources/db2>db2set db2codepage
=1252

C:/Program Files/cognos/c8/webcontent/samples/datasources/db2>db2 terminate
DB20000I TERMINATE命令成功完成。

C:/Program Files/cognos/c8/webcontent/samples/datasources/db2>db2 connect to cog
sam83 user db2admin using uflbmd1l

   数据库连接信息

数据库服务器         = DB2/NT 9.5.1
SQL 授权标识         = DB2ADMIN
本地数据库别名       = COGSAM83

C:/Program Files/cognos/c8/webcontent/samples/datasources/db2>

 

 

re-run:

 

DB2MOVE cogsam83 IMPORT -u cogsam83admin -p admin1234