Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Federated Server

    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

  2. #2
    Join Date
    Aug 2001
    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 ?

    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts