Results 1 to 5 of 5

Thread: DB2 Federation.

  1. #1
    Join Date
    Dec 2009
    Posts
    14

    Unanswered: DB2 Federation.

    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Federation between DB2 servers does not need anything else installed. It is included in the base DB2 product.

    Andy

  3. #3
    Join Date
    Dec 2009
    Posts
    14
    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.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Did you bounce the instances after you set the FEDERATED parameter?

    Andy

  5. #5
    Join Date
    Dec 2009
    Posts
    14
    Thanks now i am able to create the wrapper.
    The problem is i did not restart the database manager properly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •