I have two databases under the same instance and I will be using db3 as the federated db accessing tables in db1 via nicknames. I created the wrapper, but get an error from when I attempt to create the server.
Any ideas? Here is all the relevant information.
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v126.96.36.199", "special_15295", "U800790_15295", and
Product is installed at "/opt/IBM/db2/V8.1".
create server primary type db2/udb version 8.2 wrapper drda authorization "xxxx" PASSWORD "xxxxx" OPTIONS (DBNAME 'DB1', FOLD_ID 'U', FOLD_PW 'U', COLLATING_SEQUENCE 'Y')
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1822N Unexpected error code "-30082" received from data source "PRIMARY".
Associated text and tokens are " SQL30082N Attempt to establish connection