DB2 创建联邦
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')
页:
[1]