473,327 Members | 2,118 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,327 software developers and data experts.

Federated problems 1100N

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

Two Db instances exist on the server
User : user_a Password: pwd_a DB: db_a
User : user_b Password: pwd_b DB: db_b
Setup
=====
Im trying to build a federated db from db_a to db_b.

update dbm cfg using federated yes
catalog tcpip node n_db_b remote <IP> server <port>
catalog database db_b as my_db_b at node n_db_b

Ive successfully tested this with
connect to my_db_b user user_b using pwd_b
select tabname from syscat.tables
connect reset
create wrapper DRDA

create server s_db_b type "DB2/6000" version 8.2.1 wrapper DRDA
authorization user_b password "pwd_b" options(add node 'n_db_b' , add
dbname 'db_b')

create user mapping for docket server s_db_b options (remote_authid
'user_b', remote_password 'pwd_b')
create nickname f_db_b.table_x for s_db_b.schema.table_x

SQL1101N Remote database "docket" on node "n_dktdm2" could not be
accessed with the specified authorization id and password.
SQLSTATE=08004

Any suggestions as to how am I using the password and username
incorrectly? One reference states that the authorization ID in the
CREATE SERVER "must have BINDADD authority at the data source.".
How do I verify this.
Thanks

Nov 12 '05 #1
1 2051
Are you using Instance owner id in both the places

cheers...
Shashi Mannepalli

Nov 12 '05 #2

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

Similar topics

5
by: Terry | last post by:
Hi All, Im having problems setting up the federated database. The commands Im using are as follows: CATALOG TCPIP NODE 'FSYS1' REMOTE <ip> SERVER <port> CREATE SERVER svr_docket TYPE...
3
by: Terry | last post by:
Hi All, Im trying to run db2expln over some sql in order to find out why its so slow. I receive the following error message. LINE MESSAGES FOR DYNEXPLN.sqc ------ ...
1
by: RdR | last post by:
Hi, I have a table in SQL Server with no keys, I point this as a federated table in DB2 but in DB2 I have defined keys against this federated table in SQL. Where will the key constraints be...
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...
2
by: Tim V. | last post by:
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...
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: Damir | last post by:
Hello, I have a strange problem with federated access between two DB2 databases, both on AIX 5, both instances V9.1 (FP02). For the sake of this post, the two DB2 databases are named: 1. "live"...
0
by: imusion | last post by:
Hi, I have 2 servers each running AIX and both have a DB2 database setup on them. I'm building a news management application and in our setup we need to have a staging and production setup. So...
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...
0
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: 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...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.