db2 创建联邦数据库 /nickname

最近接触了一些db2 的东西，作为菜得不能再菜的菜鸟的我来说真是晕啊，弄了两天才弄明白，当然还有很多不明白的地方（绿色的部分是有疑问或者不确定的），写点东西小总结一下吧，要不回头就该忘了。。。要是有自己理解的不对的地方希望大家踊跃拍砖，这样才能进步啊。。。。

是关于federation server 如何access db2 data source的，

主要的信息在db2的information center里面都有http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/index.jsp

 首先要 configuring the federated server

1. Enabling the federated server to access data sources

    update dbm cfg using federated yes

2. Setting required environment variables for data source clients

    db2stop force

    db2start

3.Verifying that library files are linked to data source client software

   This task applies only when the federated server uses UNIX and the data source client is Informix®, Microsoft SQL Server, Oracle, Sybase, or Teradata.

4. Managing the product license key and policy

 

然后进行 configuring access to db2 data source

1.  Catalog a DB2 node entry.

     CATALOG TCPIP NODEdb2_node REMOTEsystem42 SERVERdb2tcp42