|
Db2 federation may be employed to retrieve selective information from non-db2 origins like oracle, sql server. It likewise may be applied with db2 datasources. Setting up federation may be mixing up at times. Below is the basic routine that may be used to setup federated system: 1) Enable federation: Federation may be enabled by running the following command update dbm cfg using federated yes immediate; 2) Create wrapper:Below is the command you would issue for a db2 datasource. Wrappers is different for each RDBMS. Please refer to IBM documentation to get more selective information on wrappers create wrapper DRDA; 3) Catalog the datasource information: Datasource will have to be cataloged in the right manner and the federated server uses the access method depending on the datasource type. 4) Create a server definition. Refer to the underneath example for db2/udb datasource db2 “create server SAMPLEHOST type DB2/UDB version 9. 5 wrapper drda authorization ‘user1′ password ‘*****’ options(node ‘SAMPLENODE’, dbname ‘SAMPLTST’)” 5) Create user mapping: db2 “CREATE USER MAPPING FOR federuser server SAMPLEHOST options(remote_authid ‘user1′, REMOTE_PASSWORD ‘*****’)” 6)Create nickname: CREATE NICKNAME EMP FOR SAMPLEHOST. SAMPLTST. EMP; If you follow all the above steps, basic federation set up is done. Nicknames may be on tables or views that reside in the datasource. Once the federation is setup, nicknames may be employed to refer to the actual datasource objects. If a heap of portion of the code may not be processed by the selective information source, it is not passed to the data source. The datasource in this case will be using substitute functionality that is close or the data set will be sent to the federated server for further and added processing Most helpful customer reviews 17 of 23 people found the following review helpful. |
-
Recent Posts
- Bionic Tenniswp Womens Tennis Gloves
- Jean Hoxie Robin Hood Tennis
- Magnetic Therapy Support Tennis Relief
- Head Mens Extreme Court Tennis
- Bcbgirls Womens Cala High Tennis
- Wilson 2011 Junior Tennis Racquet
- Adidas Barric Grass Silver Tennis
- Sterling Silver Pattern Tennis Bracelet
- Zanies Christmas Holiday Naughty Tennis
- Wilson Ncode Tennis Racquet Cover
- Mens Adidas Supreme Wide Tennis
- Tennis Tutor Model 3 Remote
- Export Badminton Similar Rackets Thailand
- Sega Superstars Tennis Playstation 3
- Vincent Toddler Little Soccer Tennis
- Adidas Mens Batida Leather Tennis
- Technical Tennis Racquets Strings Courts
- Virtua Tennis 4 Playstation 3
- Wilson Womens Tour Strike Tennis
- Royal London Sports Collection Tennis
- Export Badminton Similar Rackets Bulgaria
- Control Mario Power Tennis Nintendo Wii
- Babolat 10 Club Tennis Backpack
- Prince Tennis Box Set Vol
- Stories Hall Fame Tennis
- Bathroom Tennis Minutes Improve Maintain
- Ash Mens As Rex High Top Tennis
- Virtua Tennis Game Boy Advance
- Unique Sports Advantage Tennis Glove
- Penn Championship Titanium Tennis Single
Recent Comments
Categories




