Hi,

i want to setup a federated database access, but i'm stuck on an issue.

I've two servers Prod and Test. I want to load data from Prod to Test. Usually i create a federated connection, create a nickname for the table to be read from and start a load from cursor from nick into target table.

On the box with my issues could not access the prod database. I'm always referenced to the Test-System.

I activated federated in dbm cfg (restartet the instance at least once)
I've cataloged the Prod database. Access is possible and I can read the prod tables from the command line.

I've setup a Wrapper, Server and a User Mapping for the connection to the prod database. When i wanted to created a nickname i got an error that the target table does not exist. So i created a nickname for syscat.tables. When reading the nickname, the Information for the TEST-Database is returned.

connect to TESTDB;

create wrapper DRDA;

CREATE SERVER SERVPFDE
TYPE DB2/UDB
VERSION 9.5
WRAPPER DRDA
AUTHORIZATION db2admin
PASSWORD xxxxxxxxx
OPTIONS
( FOLD_ID 'L', FOLD_PW 'L',
DBNAME 'PFDE')
;

CREATE USER MAPPING FOR db2admin SERVER SERVPFDE
OPTIONS (REMOTE_AUTHID 'db2admin', REMOTE_PASSWORD 'xxxxxxxx')
;


Both DB-Servers are running with DB2 9.5 FP4 on Win 2003 Server.

Does anyone have a clue what's wron? I've doublechecked it several times, but i couldn't find a reason why it's not working.

can you display the create nickname and msg from this

> db2 "create nickname xfde.load_tab for servpfde.pfde.tbl_content"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "SERVPFDE.PFDE.TBL_CONTENT" is an undefined name. SQLSTATE=42704

> db2 "create nickname xfde.load_tab for servpfde.syscat.tables"
DB20000I The SQL command completed successfully.

(But xfde.load_tab retruns the data from the local database)