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
( FOLD_ID 'L', FOLD_PW 'L',
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
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
> 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)