asked on

Need help on DB2 Federation

Hi ALL

Good Morning.

I am facing problem with DB2 Federation. I am doing between 10.5 and 9.7 .

create server servername type db2/udb version '9.7' wrapper DRDA authid "db2inst1" password "password" options(add dbname 'DBNAME');

create user mapping for sourceinstancename server servername options ( remote_authid 'db2inst1', remote_password 'password');

Any iputs please..

Darrell Porter

Please refine your need. I do not see a question, just some statements.

Prardhan N

ASKER

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1101N Remote database "TARGETDBNAME" on node "<unknown>" could not be accessed
with the specified authorization id and password. SQLSTATE=08004

I am facing this error while creating server.

Prardhan N

ASKER

Any inputs please...

Darrell Porter

Try this instead:

create server servername type db2/udb version 9 wrapper DRDA authid "db2inst1" password "password" options(dbname 'DBNAME');

Prardhan N

ASKER

I have below Questions

1) Does Federation work between Linux and Aix Machine ?
2) Does Federation work if they(Source and Target) are in different Networks.?

I could do DB cataloging successfully.

SOLUTION