Federated Database

[ansonee]

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!

[Knut Stolze]

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