Federated setup - additional column

Terry · *nix forums addict Joined: 15 Apr 2003 Posts: 55

It appears the issue relates to the fixpak level. I located the
following is IBM documentation.

"DB2 for UNIX and Windows Version 7.2 federated databases

To successfully create nicknames for DB2 for UNIX and Windows Version
8 tables and views, you must apply the DB2 for UNIX and Windows
Version 7.2 Fixpak 8 on your DB2 for UNIX and Windows Version 7.2
federated database. If you do not apply Fixpak 8 on your DB2 for UNIX
and Windows Version 7.2 federated database, an error will occur when
you access the nicknames."

Terry · *nix forums addict Joined: 15 Apr 2003 Posts: 55

Problem:
=========
Unknown column appearing in federated tables.

Description:
============
Local database (L) is an established 'federated' database, extracting
values from multiple remote databases.
Database server = DB2/LINUX 7.1.0

Remote (R) database is a new database. Id like L to pull values from
R.
Database server = DB2/6000 8.1.4

Note the different version numbers.

I can set up the federated configurations on L to R. When building
nicknames additional, and different, columns are appearing in both the
describe and select.

On R
-----
CREATE TABLE application (
Application_id INTEGER NOT NULL,
Application_name VARCHAR(16) NOT NULL
)

On L (having created a nickname)
--------------------------------

Google