如何创建联邦

来源：互联网发布：python源码剖析新版编辑：程序博客网时间：2024/04/29 08:21

1. 创建联邦

注意：登录总会的数据库不要保存密码。

1.1. 省局的联邦

catalog tcpip node resoft remote <总会数据库所在的远程主机的ip地址> server 50000;

catalog db <总会数据库实例名> as fxjc_zh at node resoft;

CREATE WRAPPER DRDA OPTIONS (DB2_FENCED 'N');

CREATE SERVER resoft TYPE DB2/UDB VERSION '8.2' WRAPPER DRDA AUTHID "fxjc" PASSWORD "fxjc" OPTIONS(add node 'resoft', ADD DBNAME 'fxjc_zh');

create user mapping for fxjc_zh server resoft options (add remote_authid 'fxjc',add remote_password 'fxjc');

在控制中心，停止数据库后，重新启动数据库。

Create nickname FXJC.DQ_STANDARDLIBRARY for resoft.FXJC.DQ_STANDARDLIBRARY;

create nickname FXJC.A_SPECIAL_MEMBER for resoft.FXJC.A_SPECIAL_MEMBER;

Create nickname FXJC.DIM_ORG for resoft.FXJC. DIM_ORG;

Create nickname FXJC. M_LEGAL_ORG for resoft.FXJC. M_LEGAL_ORG;

Create nickname FXJC. M_ORGCLS for resoft.FXJC. M_ORGCLS;

Create nickname FXJC. BANK_ORG_LEVEL for resoft.FXJC. BANK_ORG_LEVEL;

Create nickname FXJC. BANK_REGION_LEVEL for resoft.FXJC. BANK_REGION_LEVEL;

Create nickname FXJC. DIM_REGION for resoft.FXJC. DIM_REGION;

1.2. 单列市级别的联邦

在省局级别部署，该步骤略过。

catalog tcpip node resoft remote <省局数据库所在的远程主机的ip地址> server 50000;

catalog db <省局数据库实例名> as fxjc_sj at node resoft;

CREATE WRAPPER DRDA OPTIONS (DB2_FENCED 'N');

CREATE SERVER resoft TYPE DB2/UDB VERSION '8.2' WRAPPER DRDA AUTHID "fxjc" PASSWORD "fxjc" OPTIONS(add node 'RESOFT', ADD DBNAME ' fxjc_sj ');

create user mapping for fxjc_sj server RESOFT options (add remote_authid 'fxjc',add remote_password 'fxjc');

在控制中心，停止数据库后，重新启动数据库。

create nickname FXJC.C_INDIVIDUATION_CONFIG for resoft.FXJC.C_INDIVIDUATION_CONFIG;

下面建立与总会的联邦。

catalog tcpip node resoft_zh remote <总会数据库所在的远程主机的ip地址> server 50000;

catalog db <总会数据库实例名> as fxjc_zh at node resoft_zh;

CREATE SERVER resoft_zh TYPE DB2/UDB VERSION '8.2' WRAPPER DRDA AUTHID "fxjc" PASSWORD "fxjc" OPTIONS(add node 'RESOFT_ZH', ADD DBNAME 'fxjc_zh');

create user mapping for fxjc_zh server resoft_zh options (add remote_authid 'fxjc',add remote_password 'fxjc');

在控制中心，停止数据库后，重新启动数据库。

Create nickname FXJC.DQ_STANDARDLIBRARY for resoft.FXJC.DQ_STANDARDLIBRARY;

create nickname FXJC.A_SPECIAL_MEMBER for resoft.FXJC.A_SPECIAL_MEMBER;

Create nickname FXJC.DIM_ORG for resoft.FXJC. DIM_ORG;

Create nickname FXJC. M_LEGAL_ORG for resoft.FXJC. M_LEGAL_ORG;

Create nickname FXJC. M_ORGCLS for resoft.FXJC. M_ORGCLS;

Create nickname FXJC. BANK_ORG_LEVEL for resoft.FXJC. BANK_ORG_LEVEL;

Create nickname FXJC. BANK_REGION_LEVEL for resoft.FXJC. BANK_REGION_LEVEL;

Create nickname FXJC. DIM_REGION for resoft.FXJC. DIM_REGION;

建立完毕。