IBM InfoSphere Federation Server, Version 10.5

Enabling the federated server to access data sources

The FEDERATED parameter must be set to YES to enable the federated server to access to the data sources.

About this task

The installation program attempts to set the FEDERATED parameter, but it is best to confirm that it is properly set to YES. If the FEDERATED parameter is not properly set, all attempts to access data sources will fail with message SQL20076, reason code 1.

The following procedure explains how to verify that the FEDERATED parameter is properly set and enable it if necessary.

Procedure

  1. From the DB2® command line, issue this command to display the parameters and their current settings: 
    GET DATABASE MANAGER CONFIGURATION
  2. Check the value of the MAX_CONNECTIONS parameter to determine if the concentrator is on:
    • If MAX_CONNECTIONS is equal to MAX_COORDAGENTS, the concentrator is off.
    • If MAX_CONNECTIONS is greater than MAX_COORDAGENTS, the concentrator is on.
    The MAX_CONNECTIONS parameter cannot be active when the FEDERATED parameter is set to YES. If the concentrator is on, change the value of MAX_CONNECTIONS to be equal to MAX_COORDAGENTS.
  3. Check the FEDERATED parameter setting. If the FEDERATED parameter is set to NO, change the setting to YES. Issue this command to change the setting: 
    UPDATE DATABASE MANAGER CONFIGURATION USING FEDERATED YES
Parent topic: Verifying the setup of the federated server

Feedback