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!