How to create a federation server to db2/400 in a db2 udb AIX databases

[zgh1970]

Hi, All,
We have a database on db2 udb aix.
The database has federated server to db2 mainframe.
Now We have already catalog database of db2/400 on the db2 UDB aix
server.
I tried to create new federation server for db2as/400.
It seam has problem.
1. can the db2 mainframe and db/400 have the same wrapper?
Our existing db2 mainframe uses the wrapper with library libdb2drda.a
This wrapper is used by db2 mainframe
2. When i create a new federated server for db2/as400 with the same
wrapper and try to create nicknmae under it,it showed the following
error message:
Error: SQL0204N "SYSIBM.SYSTABLES" is an undefined name.
SQLSTATE=42704
(State:42704, Native Code: FFFFFF34)

It seams I need to create a new wrapper for db2/400. What library I
need to use?

Thanks,

[zgh1970]

On Mar 19, 2:35 pm, "zgh1970" <[e-mail]:

Hi, All,
We have a database on db2 udb aix.
The database has federated server to db2 mainframe.
Now We have already catalog database of db2/400 on the db2 UDB aix
server.
I tried to create new federation server for db2as/400.
It seam has problem.
1. can the db2 mainframe and db/400 have the same wrapper?
Our existing db2 mainframe uses the wrapper with library libdb2drda.a
This wrapper is used by db2 mainframe
2. When i create a new federated server for db2/as400 with the same
wrapper and try to create nicknmae under it,it showed the following
error message:
Error: SQL0204N "SYSIBM.SYSTABLES" is an undefined name.
SQLSTATE=42704
(State:42704, Native Code: FFFFFF34)

It seams I need to create a new wrapper for db2/400. What library I
need to use?

Thanks,

Hi, All,
I have found the reason for that error.
I have created the federation to db2/400 in db2 udb.
Thanks,

[Michael Ortega-Binderberger]

Hi, answers embedded below.

On Mon, 19 Mar 2007, zgh1970 wrote:

Hi, All,
We have a database on db2 udb aix.
The database has federated server to db2 mainframe.
Now We have already catalog database of db2/400 on the db2 UDB aix
server.
I tried to create new federation server for db2as/400.
It seam has problem.
1. can the db2 mainframe and db/400 have the same wrapper?
Our existing db2 mainframe uses the wrapper with library libdb2drda.a
This wrapper is used by db2 mainframe

Yep, you only need 1 wrapper (drda wrapper) to talk to udb,
as400 and mainframe db2, just create a new server.

2. When i create a new federated server for db2/as400 with the same
wrapper and try to create nicknmae under it,it showed the following
error message:
Error: SQL0204N "SYSIBM.SYSTABLES" is an undefined name.
SQLSTATE=42704
(State:42704, Native Code: FFFFFF34)

You should have a setup similar to this:
create wrapper drda;
create server s1 type db2/400 version 5.3 wrapper drda
authorization "myuser" password "whatever" options (dbname
'SALES');
create user mapping for user server s1 options
(remote_authid 'myuser', remote_password 'whatever');

>
It seams I need to create a new wrapper for db2/400. What library I
need to use?

Thanks,

---
Michael Ortega-Binderberger mi**@acm.org, mi**@ics.uci.edu
Department of Computer Science mi**@computer.org, m.******@ieee.org
U. of Illinois, Urbana-Champaign http://www-db.ics.uci.edu/~miki
949-824-7231 fax: [phone]
UC Irvine Database Research Group 444 Computer Science,
On loan to the University of U. of California at Irvine,
California, Irvine (Researcher) Irvine, CA, 92697-3425

[zgh1970]

On Mar 19, 4:10 pm, Michael Ortega-Binderberger <[e-mail]>
wrote:

Hi, answers embedded below.

On Mon, 19 Mar 2007, zgh1970 wrote:

Hi, All,
We have a database on db2 udb aix.
The database has federated server to db2 mainframe.
Now We have already catalog database of db2/400 on the db2 UDB aix
server.
I tried to create new federation server for db2as/400.
It seam has problem.
1. can the db2 mainframe and db/400 have the same wrapper?
Our existing db2 mainframe uses the wrapper with library libdb2drda.a
This wrapper is used by db2 mainframe

Yep, you only need 1 wrapper (drda wrapper) to talk to udb,
as400 and mainframe db2, just create a new server.

2. When i create a new federated server for db2/as400 with the same
wrapper and try to create nicknmae under it,it showed the following
error message:
Error: SQL0204N "SYSIBM.SYSTABLES" is an undefined name.
SQLSTATE=42704
(State:42704, Native Code: FFFFFF34)

You should have a setup similar to this:
create wrapper drda;
create server s1 type db2/400 version 5.3 wrapper drda
authorization "myuser" password "whatever" options (dbname
'SALES');
create user mapping for user server s1 options
(remote_authid 'myuser', remote_password 'whatever');

It seams I need to create a new wrapper for db2/400. What library I
need to use?

Thanks,

---
Michael Ortega-Binderberger [e-mail], [e-mail]
Department of Computer Science [e-mail], [e-mail]
U. of Illinois, Urbana-Champaign http://www-db.ics.uci.edu/~miki
949-824-7231 fax: [phone]
UC Irvine Database Research Group 444 Computer Science,
On loan to the University of U. of California at Irvine,
California, Irvine (Researcher) Irvine, CA, 92697-3425

Hi, Micahel,
thank you for the replay. At first I specified the wrong DB2 typwhen
creating
the server.
Thanks,