ChannelDB2

Questions about Federation in DPF environment

Questions:

We are installing federation server on a 40 node DPF (MPP) database.
1. Do I have to install federation on all of the nodes or just the coordinating node.
2. Do I need wrappers, servers, user mappings and nicknames on all of the nodes or just the coordinator node.


Answers:

1. Please install federation on all of the nodes because in a DPF(MPP) system, any partition could be potentially a coordinator where the application connect to and the SQL statement compiled. The SQL could be federated query which need Federation installed to compile and execute

2. Wrapper/server/user mapping/nickname only need to be created once . This is same as create
table.

Views: 81

Tags: DB2, DPF, Database, Feature, Information, Integration, MPP, Partitioning, multi-partition, wrapper

Comment

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service