DB2 创建联邦

sue

1.设置FEDERATED参数

  DB2 UPDATE DBM CFG USING FEDERATED YES

  DB2STOP

  DB2START


2.连接数据库
   

DB2 connect to dbname user 用户 using 密码

3.创建WRAPPER


DB2 CREATE WRAPPER "WRAPPER"  LIBRARY 'db2drda.dll' OPTIONS (DB2_FENCED  'N')

4.创建SERVER

   

DB2 create server "SERVER" type db2/udb version '8.1' wrapper "WRAPPER" authid "USER"   password "PASSWORD" options (dbname 'sample')

5.创建USER MAPPING


DB2 CREATE USER MAPPING FOR gc SERVER "SERVER" OPTIONS (REMOTE_AUTHID  'USER', REMOTE_PASSWORD  'PASSWORD')