Connect to DB2

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

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=3D59301551
* http://www.db2mag.com/story/showArticle.jhtml?articleID=3D60 400732

(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 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

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 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 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=3D59301551
> > * http://www.db2mag.com/story/showArticle.jhtml?articleID=3D60 400732
> >
> > (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 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 DB=
2.
> > >
> > > 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
> > >
> >
>