Questions about Federation in DPF environment


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.


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

Views: 196


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

Join ChannelDB2

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service