yes you could use db2 connect from linux box to db2 database of rs/6000 but
you have to catalog the database on client nodes to catalog databases that
reside on database server machines.
ex.
To Catalog node directory:
db2 catalog tcpip node db2srv remote db2srv server 10000
where db2srv : hostname of db2 server
10000: service name or port.
To Catalog Database:
db2 catalog database dbname at node db2srv
where db2srv : hostname of db2 server
dbname: database alias name
How to Check if it's successfully catalog:
1. db2 list node directory.
you should see node directory and it's corresponding database server.
2. db2 list database directory
you should see system database directory and it's db alias & db alias.
3. db2 connect to dbname user xxxx using xxxx.
HTH,
Paul
-----Original Message-----
From: neuroticimbecile [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 9:17 PM
To: [EMAIL PROTECTED]
Subject: Re: [plug] db2 accessed from linux
thank you very much orly,
would you know if i could use db2 connect to access a db2 database residing
on
a rs/6000 box ?
grateful,
-eric
On Wed, 14 Feb 2001, you wrote:
> On Wed, 14 Feb 2001, neuroticimbecile wrote:
> ..
> > any of you guys done this before?
> >
> > i have a db2 dbu running on an ibm rs/6000.
> > and i have a intel linux box.
> >
> > i need to access the db2 database from my linux box.
>
> Download DB2 for Linux (must be the Enterprise edition, the personal
> development edition [PDE] does not have DB2 Connect). Unfortunately the
EE
> is only good for 90 days.. after which you pay.
>
> Once you have DB2 installed (easy, bunch of RPM's, drops in /opt) you can
> build DBD::DB2. Then you can talk to your DB2 just the same way I talk to
> PostgreSQL and Oracle -- via Perl..
>
> You just gotta love Perl.
>
> I don't kow how to set up the DB2 Connect though (analogous to
> tnsnames.ora and listener.ora).
--
.--. Enrique D. Rosel II office://+63.2.894.3592/
( () ) Q Linux Solutions, Inc.
`--\\ A Philippine Open Source Solutions Co. http://www.q-linux.com/
_
Philippine Linux Users Group. Web site and archives at
http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
