federation problems

[Lennart Jonsson]

Hi, I'm trying to create a federated database, but I run into trouble when
about to "create server". Some info about the env where I try:

[db2inst1@db2-00 lelle]$ uname -a
Linux db2-00 2.4.21-9.ELsmp #1 SMP Thu Jan 8 17:08:56 EST 2004 i686 i686
i386 GNU/Linux

[db2inst1@db2-00 lelle]$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08015"
with level identifier "02060106".
Informational tokens are "DB2 v8.1.0.48", "s040212", "MI00069", and FixPak
"5".
Product is installed at "/opt/IBM/db2/V8.1".

Now, here is what I have done:

db2 update dbm cfg using FEDERATED YES
db2 force application all
db2stop
db2start

db2 create database a
db2 create database b
db2 connect to a
db2 "create table x (c1 int not null primary key)"
db2 connect reset
db2 connect to b
db2 "create table y (c2 int not null primary key)"

db2 create wrapper DRDA

so far so good, but when I try to create a server

db2 "create server APA type DB2/UDB VERSION '8.1' WRAPPER DRDA
authorization" "db2inst1" "OPTIONS (DBNAME 'A')"

I get the error

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 "Remote authid/password missing" received
from
data source "". Associated text and tokens are "".

I have played around with the create server command, using different
parameters, but whatever I do end up with I
SQL1822N. I also tried cataloging a remote db at but the results are
similar. Passing the password doesnt seem to help either.

Obviously I am missing something, just cant figure out what it is. Any hints
anyone?

Kind regards
/Lennart

[Lennart Jonsson]

Never mind, without knowing exactly what was wrong it works now.

/Lennart

"Lennart Jonsson" <le*************@kommunisera.umea.se> skrev i meddelandet
news:cg**********@hudsucker.umdac.umu.se...

Hi, I'm trying to create a federated database, but I run into trouble when
about to "create server". Some info about the env where I try:

[db2inst1@db2-00 lelle]$ uname -a
Linux db2-00 2.4.21-9.ELsmp #1 SMP Thu Jan 8 17:08:56 EST 2004 i686 i686
i386 GNU/Linux

[db2inst1@db2-00 lelle]$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08015" with level identifier "02060106".
Informational tokens are "DB2 v8.1.0.48", "s040212", "MI00069", and FixPak
"5".
Product is installed at "/opt/IBM/db2/V8.1".

Now, here is what I have done:

db2 update dbm cfg using FEDERATED YES
db2 force application all
db2stop
db2start

db2 create database a
db2 create database b
db2 connect to a
db2 "create table x (c1 int not null primary key)"
db2 connect reset
db2 connect to b
db2 "create table y (c2 int not null primary key)"

db2 create wrapper DRDA

so far so good, but when I try to create a server

db2 "create server APA type DB2/UDB VERSION '8.1' WRAPPER DRDA
authorization" "db2inst1" "OPTIONS (DBNAME 'A')"

I get the error

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 "Remote authid/password missing" received
from
data source "". Associated text and tokens are "".

I have played around with the create server command, using different
parameters, but whatever I do end up with I
SQL1822N. I also tried cataloging a remote db at but the results are
similar. Passing the password doesnt seem to help either.

Obviously I am missing something, just cant figure out what it is. Any hints anyone?

Kind regards
/Lennart

[Leo]

Try something like this:
--NOTE: Create the federated server def. Give the information for the
target database
create server brdods type DB2/UDB version 8.1 wrapper drda
authorization INSTACNE_OWNER password "passwd" options (NODE 'BRDODS',
DBNAME 'BRDODS' , FOLD_ID 'N' , FOLD_PW 'N' ) '


"Lennart Jonsson" <le*************@kommunisera.umea.se> wrote in message news:<cg**********@hudsucker.umdac.umu.se>...

Hi, I'm trying to create a federated database, but I run into trouble when
about to "create server". Some info about the env where I try:

[db2inst1@db2-00 lelle]$ uname -a
Linux db2-00 2.4.21-9.ELsmp #1 SMP Thu Jan 8 17:08:56 EST 2004 i686 i686
i386 GNU/Linux

[db2inst1@db2-00 lelle]$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08015"
with level identifier "02060106".
Informational tokens are "DB2 v8.1.0.48", "s040212", "MI00069", and FixPak
"5".
Product is installed at "/opt/IBM/db2/V8.1".

Now, here is what I have done:

db2 update dbm cfg using FEDERATED YES
db2 force application all
db2stop
db2start

db2 create database a
db2 create database b
db2 connect to a
db2 "create table x (c1 int not null primary key)"
db2 connect reset
db2 connect to b
db2 "create table y (c2 int not null primary key)"

db2 create wrapper DRDA

so far so good, but when I try to create a server

db2 "create server APA type DB2/UDB VERSION '8.1' WRAPPER DRDA
authorization" "db2inst1" "OPTIONS (DBNAME 'A')"

I get the error

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 "Remote authid/password missing" received
from
data source "". Associated text and tokens are "".

I have played around with the create server command, using different
parameters, but whatever I do end up with I
SQL1822N. I also tried cataloging a remote db at but the results are
similar. Passing the password doesnt seem to help either.

Obviously I am missing something, just cant figure out what it is. Any hints
anyone?

Kind regards
/Lennart