Re: Connect to DB2

2006-01-05 Thread Dan Scott
Let's keep this discussion on-list in case someone else has the same
question in the future.

http://ibm.com/db2/perl/ says that if you are compiling DBD::DB2 on
Linux, you set DB2_HOME to the location of your DB2 instance--for
example, /home/db2inst1/sqllib/ -- because DBD::DB2 needs the DB2
headers and libraries to compile successfully.

When you run a Perl program, DBD::DB2 then uses those libraries to
connect to your DB2 server running on Windows.

Dan


On 1/5/06, Vincent Deng <[EMAIL PROTECTED]> wrote:
> Dear Dan,
>
> So what value I should assign to DB_HOME? The DB2 home directory on
> windows box or?
>
> Thanks in advance
>
>
> On 1/5/06, Dan Scott <[EMAIL PROTECTED]> wrote:
> > Hi Vincent:
> >
> > You just need to install the DB2 development headers and libraries
> > (available with the free to download and use DB2 Application
> > Development Client) on your Linux box and set DB2_HOME before
> > compiling DBD::DB2; that will enable you to connect from your Linux
> > box to a DB2 server running on a Windows box.
> >
> > For more information:
> > * http://ibm.com/db2/perl/
> > * http://www.db2mag.com/showArticle.jhtml?articleID=59301551
> > * http://www.db2mag.com/story/showArticle.jhtml?articleID=60400732
> >
> > (Note that Red Hat 9.0 is not officially supported by DB2, so you
> > might run into some troubles with that part of the equation. If it
> > doesn't work out, and you're willing to install a new flavour of
> > Linux, check out http://ibm.com/db2/linux/validate for a list of Linux
> > distros supported by DB2)
> >
> > Dan
> >
> > On 1/5/06, Vincent Deng <[EMAIL PROTECTED]> wrote:
> > > Dear dbi-helpers,
> > >
> > > My environment is RedHat 9.0.
> > > I got the following message while installing DBD::DB2 module.
> > >
> > > DB2_HOME environment variable must be set to installed location of DB2.
> > >
> > > Did this message indicate that I have to install DB2 in the same
> > > machine and set DB2_HOME environment variable for DBD installation?
> > > If I want not to install DB2 on the same machine but connect to the
> > > DB2 server installed on another windows machine, what should I do?
> > >
> > > Thanks in advance
> > >
> >
>


Re: Connect to DB2

2006-01-05 Thread Dan Scott
Hi Vincent:

You just need to install the DB2 development headers and libraries
(available with the free to download and use DB2 Application
Development Client) on your Linux box and set DB2_HOME before
compiling DBD::DB2; that will enable you to connect from your Linux
box to a DB2 server running on a Windows box.

For more information:
* http://ibm.com/db2/perl/
* http://www.db2mag.com/showArticle.jhtml?articleID=59301551
* http://www.db2mag.com/story/showArticle.jhtml?articleID=60400732

(Note that Red Hat 9.0 is not officially supported by DB2, so you
might run into some troubles with that part of the equation. If it
doesn't work out, and you're willing to install a new flavour of
Linux, check out http://ibm.com/db2/linux/validate for a list of Linux
distros supported by DB2)

Dan

On 1/5/06, Vincent Deng <[EMAIL PROTECTED]> wrote:
> Dear dbi-helpers,
>
> My environment is RedHat 9.0.
> I got the following message while installing DBD::DB2 module.
>
> DB2_HOME environment variable must be set to installed location of DB2.
>
> Did this message indicate that I have to install DB2 in the same
> machine and set DB2_HOME environment variable for DBD installation?
> If I want not to install DB2 on the same machine but connect to the
> DB2 server installed on another windows machine, what should I do?
>
> Thanks in advance
>