1.启用DB2联邦支持
DB2 UPDATE DBM CFG USING FEDERATED YES
2.编目远程数据到本地
创建NODE
DB2 CATALOG TCPIP NODE PI_NODE REMOTE 10.10.10.10 SERVER 50000
编目数据库
DB2 CATALOG DATABASE JSSF AT NODE PI_NODE
3.创建WRAPPER
在不同的操作系统下,LIBRARY对应的值如下表所示:
-- AIX(unix) LIBRARY:libdb2drda.a
-- HP-UX LIBRARY:libdb2drda.sl
-- Linux LIBRARY:libdb2drda.so
-- Solaris LIBRARY:libdb2drda.so
-- Windows LIBRARY:db2drda.dll
CREATE WRAPPER "DRDA"
LIBRARY 'libdb2drda.a'
OPTIONS (DB2_FENCED 'N'
);
4.创建SERVER
CREATE SERVER "PISERVER"
TYPE DB2/UDB
VERSION 8.1
WRAPPER DRDA
AUTHORIZATION "nxlxuser"
PASSWORD "nxlxuser"
OPTIONS
(DBNAME 'JSSF'
);
5.创建USER MAPPING
CREATEUSER MAPPING FOR DB2ADMIN
SERVER "PISERVER"
OPTIONS
(REMOTE_AUTHID 'nxlxuser',
REMOTE_PASSWORD 'nxlxuser'
);
6创建NICKNAME
CREATE NICKNAME "DB2ADMIN"."PI_WE_PARTY_ASSIGNMENT"
FOR "PISERVER"."NXLXUSER"."WE_PARTY_ASSIGNMENT";