By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,609 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,609 IT Pros & Developers. It's quick & easy.

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

P: n/a
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,

Mar 19 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mar 19, 2:35 pm, "zgh1970" <george.zh...@lombard.cawrote:
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,

Mar 19 '07 #2

P: n/a
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: 949-824-4056
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
Mar 19 '07 #3

P: n/a
On Mar 19, 4:10 pm, Michael Ortega-Binderberger <m...@ics.uci.edu>
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 m...@acm.org, m...@ics.uci.edu
Department of Computer Science m...@computer.org, m.ort...@ieee.org
U. of Illinois, Urbana-Champaign http://www-db.ics.uci.edu/~miki
949-824-7231 fax: 949-824-4056
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,

Mar 20 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.