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

Federated Database

P: n/a
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. Each came
back successful.

- create wrapper drda

- create server REMOTEDB2 type DB2/6000 version 8.1 wrapper drda
authorization "amrobi2" password "amrobi2" options (node 'DB2', dbname
'AIMUAT')

- create user mapping for amrobi2 server REMOTEDB2
OPTIONS(remote_authid 'amrobi2', remote_password 'amrobi2')

- create nickname REMOTEDB2.aimconnection for
REMOTEDB2.AIM.AIMCONNECTION

It's this last one that doesn't cooperate. I get the following error:

SQL1822N Unexpected error code "-30082" received from data source
"REMOTEDB2". Associated text and tokens are "func="DriverConnect" msg="
SQL30082N Attempt to esta". SQLSTATE=560BD

This looks like a user/password issue but from what I can see,
everything seems okay.
Can anyone shed any light on what the deal might be?

Thanks!

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ansonee wrote:
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. Each came
back successful.

- create wrapper drda

- create server REMOTEDB2 type DB2/6000 version 8.1 wrapper drda
authorization "amrobi2" password "amrobi2" options (node 'DB2', dbname
'AIMUAT')

- create user mapping for amrobi2 server REMOTEDB2
OPTIONS(remote_authid 'amrobi2', remote_password 'amrobi2')

- create nickname REMOTEDB2.aimconnection for
REMOTEDB2.AIM.AIMCONNECTION

It's this last one that doesn't cooperate. I get the following error:

SQL1822N Unexpected error code "-30082" received from data source
"REMOTEDB2". Associated text and tokens are "func="DriverConnect" msg="
SQL30082N Attempt to esta". SQLSTATE=560BD

This looks like a user/password issue but from what I can see,
everything seems okay.
Can anyone shed any light on what the deal might be?


Can you connect to the database "AIMUAT" using the user-id/password that you
gave in the CREATE SERVER statement?

Are you currently connected to the federated server (where you run the above
listed statements) as user "amrobi2" as you specified in the CREATE USER
MAPPING statement?

What exactly did you find in the db2diag.log? With DIAGLEVEL set to 4, you
should be able to see the exact reason code.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.