filon51
不求最好,但求更好!
posts - 0,comments - 0,trackbacks - 0

1、服务端主机上创建wrapper、创建数据库访问别名:
db2 catalog tcpip node sap_node remote 10.252.0.124 server 5912
db2 catalog db prd as lis_sap at node sap_node

2、创建包装器:CREATE WRAPPER DRDA;

3、创建server:
CREATE SERVER sap_server
  TYPE DB2/AIX
  VERSION '9.1'
  WRAPPER DRDA
  AUTHORIZATION "jihe"
  PASSWORD  "abc123"
  OPTIONS (ADD DBNAME 'lis_sap',ADD PASSWORD 'Y');
commit;

4、创建用户映射:
CREATE USER MAPPING FOR "db2inst1" SERVER sap_server OPTIONS ( ADD REMOTE_AUTHID 'jihe', ADD  REMOTE_PASSWORD 'abc123');
commit; 

5、创建nickname:

CREATE NICKNAME DB2INST1.BSAS FOR sap_server.SAPPRD.BSAS;
CREATE NICKNAME DB2INST1.BSIS FOR sap_server.SAPPRD.BSIS;
CREATE NICKNAME DB2INST1.BSID FOR sap_server.SAPPRD.BSID;
CREATE NICKNAME DB2INST1.BSAD FOR sap_server.SAPPRD.BSAD;
CREATE NICKNAME DB2INST1.BSIK FOR sap_server.SAPPRD.BSIK;
CREATE NICKNAME DB2INST1.BSAK FOR sap_server.SAPPRD.BSAK;
CREATE NICKNAME DB2INST1.T012K FOR sap_server.SAPPRD.T012K;
CREATE NICKNAME DB2INST1.FAGLFLEXA FOR sap_server.SAPPRD.FAGLFLEXA;
commit;

6、全部ok



No Money,No All!
posted on 2009-12-30 10:26 齐胜龙 阅读(160) 评论(0)  编辑  收藏 所属分类: 数据库

只有注册用户登录后才能发表评论。


网站导航: