Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011

    Unanswered: Error in applying federation

    Hey.. is it possible to imply the federation between the two remote databases.

    I catalogged two databases say A and B on my local db2 . A is present on server1 and B is present on server2. I want to federate the db B from db A. I am able to connect to both the databases with the credentials through control centre and also able to create the wrapper and server definitions. but after that when i try to create the user mappings i am getting the following error...

    The DB2 Administration Server encountered a non-severe error
    while executing a request.


    A non-severe error occurred in the DB2 Administration Server while it
    was processing a request.

    User response:

    Refer to the DB2 Administration Server's First Failure Data Capture Log
    for additional information.

    If trace was active, invoke the Independent Trace Facility at the
    operating system command prompt. Contact IBM Support with the following
    required information:
    * Problem description
    * SQLCODE or message number
    * SQLCA contents if possible
    * Trace file if possible

    Although I have checked the das user of all 3 servers - server1, server2 and my local das users. The dasusr is working fine on all these servers but still getting this error again and again. I am using this task through the control center of my local having db2 V9.5 ESE (windows)

    Server 1 has V9.5 ESE version zlinux

    server 2 has v9.7 ese versin linux-64 bit

    Please help asap..Thanks in advance........

  2. #2
    Join Date
    May 2003
    Are the databases enabled for Federation?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2011

    Federated Database System Support (FEDERATED) = YES

    This is enable on all 3 servers..

Posting Permissions

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