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 v8.1.0.89", "special_15295", "U800790_15295", and
FixPak "9".
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

System = SunOS
Release = 5.8

SQL30082N is userid/password problem generally ..

Assuming the userid and password you are specifying in the statement is correct, can you exclude the FOLD_ID 'U', FOLD_PW 'U' option and try ?

Sathyaram