473,573 Members | 2,924 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Federated setup - additional column

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_nam e VARCHAR(16) NOT NULL
)

On L (having created a nickname)
--------------------------------
describe table r_application
Column Type Type
name schema name Length Scale Nulls
------------------------------ --------- ------------------ --------
APPLICATION_ID SYSIBM INTEGER 4 0 No
APPLICATION_ID0 SYSIBM INTEGER 4 0 No
APPLICATION_NAM E SYSIBM VARCHAR 16 0 Yes

Where has the column APPLICATION_ID0 come from?
select * from r_application
Returns back rows with the following columns:
Application_id OK
Application_id1 ???
Application_id1 1 ???
Application_id1 11 ???
Application_nam e OK

What are those addition columns?
select APPLICATION_ID0 from r_application
Works, returning the values found in APPLICATION_ID0 - which isnt in
the APPLICATION table!
select APPLICATION_ID1 from r_application


fails - which is good.
Im perplexed, this is very odd.
Why Im I obtaining additional columns in the describe?
Why Im I obtaining additional columns in the select? Why are these
different form the view?
Any thoughts are welcome.

Thanks

Terry

KEYWORDS: federated, DB2, columns, additional, 7.1, 8.1, describe,
select
Nov 12 '05 #1
1 1941
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."
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
2905
by: stabbert | last post by:
I am attempting to join two tables together on two different unix servers. Here is some relevant info about the tables. TABLE 1 Setup ----------------------- DB2 UDB 7.2 EE
0
1977
by: Joerg Ammann | last post by:
hello, we are using: - DB2 UDB V 8.1 FP-6 on LINUX as (local) federated DB - DB2 UDB V 7.2 on AIX as datasource we try to move part of an application (most of the tables) von AIX to LINUX and acess a few remaining tables (on AIX) via the "federated DB" feature.
0
1759
by: Joerg Ammann | last post by:
hi, os: aix 4.3.3 DB2: version 7 FP3 we are using a federated DB setup, datasource and fed-Db are both V7FP3 (in fact they are on the same server) and are having massiv performance problems. i tracked it back to the way the queries are push-downed to the
2
4842
by: vrbala | last post by:
Hi All, I have a issue in federated database. I will explain the scenario I have a table T1 in database called offlinedb. It has one column F1 I have an another table T2 in database uatdb. I added attached table T1 in offlinedb using Federated Objects. Then i created a procedure P1 in uatdb database with the following contents.
5
3324
by: Klemens | last post by:
I get SQL30090 reason 18 by trying to do an insert in a federated table and an update in a local table in one transaction Do I have to change some settings to get done or ist this not possible by definition? Thanks Klemens
1
2069
by: terryintransit | last post by:
Problem: ======== I'm receiving SQL1101N when I sttempt to build a nickname in a federated database. Config ====== Server: AIX Version 5.2 DB2: 8.2.1
14
4422
by: peteh | last post by:
Hi All; We have many production jobs that "load from cursor" to a UDB/AIX 8.2 (with dpf) data warehouse from source tables residing Oracle 9i. Since Oracle dates are (roughly) equivalent to DB2 timestamps, we frequently use the date() function to "convert" from the Oracle date datatype to the DB2 date datatype. We have used this technique...
9
5737
by: mitek | last post by:
Hi, All. Is federated procedures between DB2 databases currently not supported in WebSphere Federation Server 9.1 ??? I recieve next error when trying to create DB2 federated procedure : SQL30090N Operation invalid for application execution environment. Reason code = "21". LINE NUMBER=1.
0
2874
by: imusion | last post by:
Hi, I have 2 servers each running AIX and both have a DB2 database setup on them. I'm building a news management application and in our setup we need to have a staging and production setup. So the staging database gets the changes performed and then once we're satisfied with how it looks, we push the changes through SQL queries which perform...
0
7694
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8202
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8065
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6419
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5593
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5291
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3732
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1303
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1041
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.