
Signature
Tim.
"Those who give up essential liberties for temporary safety deserve neither
liberty nor safety." - Benjamin Franklin
I figured it out. Regardless of what you put in the
'create server' part, it doesn't get sent. When you try
to connect via Federated server, it's sending the OS ID
you are logged in as. So, if I'm logged in as 'db2inst1',
that's the ID/PWD combo that gets sent, even if I define the
server with a different UID. I had to create a 'user mapping'
that xlates 'db2inst1' -> 'userid'.
It's not clearly (at least to me) explained in the doc.
Tim.
> Here's the layout: AIX v5.2, DB2 v8 fp8 running in 64bit
>
[quoted text clipped - 47 lines]
>
> I just can't figure out what why it doesn't like the supplied info.

Signature
Tim.
"Those who give up essential liberties for temporary safety deserve neither
liberty nor safety." - Benjamin Franklin
Michael Ortega-Binderberger - 30 Sep 2005 22:22 GMT
The userid and pw that you put in the create server
statement are NOT used for normal connections, they are used
for other "misc" stuff (misteriously pointed in:
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.ud
b.doc/admin/r0002170.htm
The one that is used is the one you
are currently connected as (if there is no user mapping) or
the user/pw defined in the user mapping.
Your user mapping is suspect. It indicates that you have
the same user "userid" on both instances. What you need is
create user mapping for local_user_id server
...(... 'remote_user_id', ...'remote pw')
Michael
> I figured it out. Regardless of what you put in the
> 'create server' part, it doesn't get sent. When you try
[quoted text clipped - 59 lines]
> >
> > I just can't figure out what why it doesn't like the supplied info.
---
Michael Ortega-Binderberger miki@acm.org, miki@ics.uci.edu
Department of Computer Science miki@computer.org, m.ortega@ieee.org
U. of Illinois, Urbana-Champaign http://www-db.ics.uci.edu/~miki
949-824-7231 fax: 949-824-4056
UC Irvine Database Research Group 444 Computer Science,
On loan to the University of U. of California at Irvine,
California, Irvine (Researcher) Irvine, CA, 92697-3425