http://snippets.dzone.com/posts Sat, 26 Jul 2008 13:36:25 GMT DZone Snippets: federation code http://snippets.dzone.com/posts/show/3681 Server A configuration: <br />OS: WinXP <br />Instance name: TMINST <br />Instance user and password: db2admin/db2admin <br />Required nickname for remote table: DB2ADMIN.R_CUSTOMERS <br /> <br />Server B configuration: <br />OS: Linux <br />IP: 10.60.100.21 <br />DB2 service port: 50000 <br />Instance user and password: db2inst1/db2inst1 <br />Database name: TM_ON <br />Table name to be linked: CUSTOMERS <br /> <br />CLP Commands @Server A: <br /><code> <br />db2set DB2INSTDEF=TMINST <br />SET DB2INSTANCE=TMINST <br />db2 UPDATE DATABASE MANAGER CONFIGURATION USING FEDERATED YES IMMEDIATE <br />db2 CATALOG TCPIP NODE RTMINST REMOTE 10.60.100.21 SERVER 50000 REMOTE_INSTANCE db2inst1 OSTYPE Linux <br />db2 CATALOG DATABASE TM_ON AS RTM_ON AT NODE RTMINST <br />db2start <br />db2 CONNECT TO TM_ON USER db2admin USING db2admin <br />db2 CREATE WRAPPER DRDA <br />db2 "CREATE SERVER RTM_ON TYPE DB2/UDB VERSION '9.1' WRAPPER DRDA AUTHORIZATION \"db2inst1\" PASSWORD \"db2inst1\" OPTIONS( ADD DBNAME 'RTM_ON')" <br />db2 CREATE USER MAPPING FOR DB2ADMIN SERVER RTM_ON OPTIONS ( ADD REMOTE_AUTHID 'db2inst1', ADD REMOTE_PASSWORD 'db2inst1') <br />db2 CREATE NICKNAME DB2ADMIN.R_CUSTOMERS FOR RTM_ON.DB2INST1.CUSTOMERS <br />db2 SELECT * FROM R_CUSTOMERS <br /></code> Fri, 16 Mar 2007 11:46:43 GMT http://snippets.dzone.com/posts/show/3681 wjchay (Chay Weei Jye)