Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Linux connection to DB2/400

0 views
Skip to first unread message

Cosimo Streppone

unread,
Jun 15, 2000, 3:00:00 AM6/15/00
to
Hi,

anyone succeeded in connecting a linux redhat
box directly to as/400 database using Perl DBD::DB2 driver ?

Is it enought to use DB2 Connect Personal Edition for Linux ?
What version ? (6.1, 5.2, or other)
How I configure DB2 on Linux to connect directly to my AS/400 ?

I was following these steps:

db2> catalog dcs database <localdb> as <remotedb>
db2> catalog tcpip node <node> remote <my_as400> ostype OS/400
db2> catalog database <local> as <remotedb> at node <node>

When I issue a "connect to local" commands,
it says that "database release level of server doesn't support
database release level of client".

What can I do ?
Anyone succeeded in this task?

Thank you guys.

Cosimo [cst...@idgroup.it]

Blair Kenneth Adamache

unread,
Jun 16, 2000, 3:00:00 AM6/16/00
to
DB2 Connect Personal Edition for Linux (v6.1 or v7.1) is sufficient.

DB2/400 must be at v4r2 or later and have TCP/IP working.

David Marvin

unread,
Jun 16, 2000, 3:00:00 AM6/16/00
to
You have mis-catalogued. Try this;

db2 catalog tcpip node mynode remote my_as400 server 446
db2 catalog dcs database mydcsdb as <as/400 rdbname>
db2 catalog db mydcsdb as mylocaldb at node mynode authentication dcs
db2 terminate
db2 connect to mylocaldb user xxxxx using yyyyy
cd $HOME/sqllib/bnd
db2 bind @ddcs400.lst sqlerror continue
db2 commit

0 new messages