Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    335

    Unanswered: Federated DB driving me crazy

    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.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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

  3. #3
    Join Date
    Jan 2010
    Posts
    335
    > 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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •