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) 编辑 收藏 所属分类:
数据库