Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Posts
    29

    Unanswered: Accessing tables across the servers

    How to access tables across the server in db2 9.7?

    For eg: I have server1,have tables like table1 and table2 and a query like:
    select a.col1,a.col2 from table1 a join table2 b on a.col1=b.col1

    In another server server2, i need to execute same above query but tables will not be present in this server.


    So can we access tables present in server1 from server2, if yes what is the procedure to do that? Is there any server linking facilities in db2?

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Yes, this is called FEDERATION in db2.
    You setup federationk, create servers, wrappers, mappings, nicknames...

  3. #3
    Join Date
    Mar 2012
    Location
    Canberra, Australia
    Posts
    38

Posting Permissions

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