473,325 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

DB2 Federated connection problems

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
Nov 12 '05 #1
2 5205
"Tim V." <va****@us.ibm.com> wrote in
news:Xn**********************************@207.115. 17.102:

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

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
Nov 12 '05 #2
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/infoce...n/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

On Thu, 29 Sep 2005, Tim V. wrote:
"Tim V." <va****@us.ibm.com> wrote in
news:Xn**********************************@207.115. 17.102:

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

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


---
Michael Ortega-Binderberger mi**@acm.org, mi**@ics.uci.edu
Department of Computer Science mi**@computer.org, m.******@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

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: ansonee | last post by:
I'm in trhe midst of creating a federated connection to a database. Everything looks good until I get to the "nickname" part. Below is the series of commands I executed against the remote database....
0
by: stevenkblack | last post by:
I have a server W2k running DB2 8.1.6. We have two databases one DBDC that holds our user base and QUALITY with all our application data. I have about 8 tables federated on QUALITY looking at the...
2
by: vrbala | last post by:
Hi All, I have a issue in federated database. I will explain the scenario I have a table T1 in database called offlinedb. It has one column F1 I have an another table T2 in database uatdb. I...
5
by: Klemens | last post by:
I get SQL30090 reason 18 by trying to do an insert in a federated table and an update in a local table in one transaction Do I have to change some settings to get done or ist this not possible by...
1
by: terryintransit | last post by:
Problem: ======== I'm receiving SQL1101N when I sttempt to build a nickname in a federated database. Config ====== Server: AIX Version 5.2 DB2: 8.2.1
5
by: Michael Rudolph | last post by:
Hi newsgroup, I have an issue with the configuration of a DB2 federated database (WebSphere Information Integrator) in conjunction with the relational wrapper for Oracle on AIX. DB2 seems to not...
2
by: mas5 | last post by:
Hello, Sorry if my question is elementary. I've searched google, but can't seem to find exactly what I'm looking for. My client is using db2 8.2. They have 2 companies and each company has a...
9
by: mitek | last post by:
Hi, All. Is federated procedures between DB2 databases currently not supported in WebSphere Federation Server 9.1 ??? I recieve next error when trying to create DB2 federated procedure : ...
2
by: wugon.net | last post by:
env: db2 LUW v8 + aix We encounter some java applications status did not change and keep in "Federated request pending" for a long time. we try issue db2 "force applications <handle id>" to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.