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
-
From the Db2® command line, issue this command to display the parameters and their current settings:
GET DATABASE MANAGER CONFIGURATION
- 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.
- 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