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.

Federation between DB2 servers does not need anything else installed. It is included in the base DB2 product.

Andy

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.

User Response:

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
by "<reason-code>":

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.

Did you bounce the instances after you set the FEDERATED parameter?

Andy

Thanks now i am able to create the wrapper.
The problem is i did not restart the database manager properly.