We are having db2 version 8.2 enterprise edition installed on windows.
We need to query 2 database instances in the same server.
Can any one tell us how this can be done.
For db2 federation is DB2 Information Integrator required?
If so does it comes with server installation or is it a seperate installation?
We are not able to create wrapper.
When i try to create wrapper for any db2 instance it gives me the below error:
An error has been detected at the instance level. The requested
operation cannot be completed because a specified functional area
was not installed or because a specified functional area was not
enabled to the instance.
The following is the list of reason codes and associated
functional areas you can enable at the instance level:
1. The ability to execute distributed request operations against
multiple data sources in a single statement.
Enable the instance for the requested action or operation.
First, install the specified functional area if it is missing.
Then, enable the specified functional area. Enablement steps vary
1. For a federated server, set the DBM variable <FEDERATED> to
YES and then restart the database manager.
sqlcode : -20076
sqlstate : 0A502
I have set the federated parameter to yes for both the instances.