Here's the layout: AIX v5.2, DB2 v8 fp8 running in 64bit
I've got a Multi-partitioned db running on lpar4 and I want to
connect it to 2 instances running on lpar13. We'll deal with just
1 instance on lpar13 for now.
lpar4 -> db name dwdb
lpar13 -> db name IBMEDGE
On lpar13, I have a userid that has DBADMIN authority.
ID: userid PW: passwd
Our dba cataloged IBMEDGE on our lpar4 machine with no problems.
I can connect to it from lpar4 with the follwing command:
db2 connect to IBMEDGE user userid using passwd
Federated part:
(I got this out of the Configuring Federated Data Source manual, so I
did RTFM :) )
I created a DRDA wrapper with no problems.
-> create wrapper DRDA library 'libdb2drda.a'
I then created a server (ran successfully)
-> create server EDGESRC type DB2/UDB version 8 wrapper DRDA
authorization "userid" password "passwd"
options (DBNAME 'IBMEDGE', FOLD_ID 'L', FOLD_PW 'L');
I then created a user_mapping (ran successfully)
-> create user mapping for userid server EDGESRC
options (REMOTE_AUTHID 'userid', REMOTE_PASSWORD 'passwd');
When I try to test the connection or create a nickname, I get a
userid/passwd error (SQL1101N SQLSTATE=08004).
The userid/passwd combo work fine when I telnet or do a direct DB2 connect
to it.
The quotes and FOLD options should force it to lowercase.
Both instances have FEDERATED set to 'YES' in the dbm cfg.
It would probably be easier to do it in the control center, but IGS has
it blocked by an firewall.
I just can't figure out what why it doesn't like the supplied info.
--
Tim.
"Those who give up essential liberties for temporary safety deserve neither
liberty nor safety." - Benjamin Franklin