db2 USER MAPPING, CREATE SERVER机NICKNAME

1.创建WRAPPER  

CREATE WRAPPER "DRDA"  LIBRARY 'libdb2drda.a'  OPTIONS (DB2_FENCED  'N');

2.创建SERVER 的 DDL 语句
 需替换AUTHORIZATION,PASSWORD,DBNAME，,指定数据库2库名,用户名及密码  相当于创建一个中间的"关联库"

CREATE SERVER tempserver 
   TYPE DB2/UDB 
   VERSION 9.7
   WRAPPER DRDA 
   AUTHORIZATION "db2inst2"
   PASSWORD "1"
   OPTIONS
     (DBNAME  '数据库2'
     );

3.创建USER MAPPING 的 DDL 语句,将本地数据库1的Schema于指定数据库2进行映射关联

CREATE USER MAPPING FOR Schema1
   SERVER tempserver
   OPTIONS
     (REMOTE_AUTHID  'db2inst2'
     ,REMOTE_PASSWORD  '1'
     );
CREATE USER MAPPING FOR Schema2
   SERVER tempserver
   OPTIONS
     (REMOTE_AUTHID  'db2inst2&#