By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,702 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Federated problems 1100N

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
Are you using Instance owner id in both the places

cheers...
Shashi Mannepalli

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.