Unanswered: Federated System
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
- create wrapper drda
- create server REMOTEDB2 type DB2/6000 version 8.1 wrapper drda
authorization "amrobi2" password "amrobi2" options (node 'DB2', dbname
- create user mapping for amrobi2 server REMOTEDB2
OPTIONS(remote_authid 'amrobi2', remote_password 'amrobi2')
- create nickname REMOTEDB2.aimconnection for
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?
"If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."