Creating a DB2 Database federated object

Db2
1. DB2 =>update dbm CFG using federated YES
2. DB2 =>db2stop Force
3. DB2 =>db2start

4. Create the wrapper:
DB2 =>create WRAPPER DRDA LIBRARY ' Db2drda.dll ' OPTIONS (ADD db2_fenced ' N ')

5. Create a server definition:
DB2 =>create SERVER lbzm TYPE db2/udb VERSION ' 9.7 ' WRAPPER DRDA AUTHID "db2admin" PASSWORD "* * * * *" options (ADD DBNAME ' Lbzm ')

6. Create User mappings:
DB2 =>create USER MAPPING for db2admin SERVER lbzm OPTIONS (add Remote_authid ' db2admin ', add remote_password ' * * * * * ")

7. Create a table map (nickname)
DB2 =>create nickname Db2admin.v3_fore_co_day for Lbzm.db2admin.v3_fore_co_day

Creating a DB2 Database federated object