• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

How do I pass data between multiple DB2 dbs?

We are setting up multiple DB2 databases, each in it's own instance on a server.
How can I, in one database, query tables in another? Can this be done?
Using DB2 UDB WorkGroup Edition v7.2 w/fixpak 11, running on Windows 2000. Upgrading beyond v7.2 is not an option.
0
EricDreczko
Asked:
EricDreczko
1 Solution
 
LowfatspreadCommented:
you either establish federation links between the databases

or you connect to the other and then issue a query against it....

but if you want to join then you need the federation link basically...

0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now