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
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. It only takes a minute to sign up.Sign up to join this community
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.
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:
CREATE WRAPPER CREATE SERVER CREATE NICKNAME