Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

There are two instances of DB2 running on the same machine. One has a table aliased to the a table in the other one. Is there a way to do this in DB2 or does it have to be done via an external tool?

This is with an older version of DB2

share|improve this question
You should accept answers as that helps to build the community. – Chris Aldrich Mar 29 '11 at 19:08

The "federation" feature in DB2 will allow you to do what you need.

It's available on the Linux/Unix/Windows version of DB2 - not sure about the mainframe - and there are no licensing issues, it's part of the base product set.

To implement it you only need to create a few extra db objects (wrapper, server mappings, nickname) and you're more or less done. Follow the documentation and you should be fine.


share|improve this answer

you should be able to use the 3 part table name to access the data.

prior to version 9 is was simple, subsystem.qualifier.tablename would get you there, at least on the mainframe. starting with version 9 you have to perform a bind on each subsystem.

share|improve this answer

I would recommend using the DB2 federation feature. Then you would be able to setup a nickname and then use it just like any other table.

Some statements to setup federation I would look at are:


Tutorial to Federate Quickly

Publib for all general information about DB2

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.