Re: Install DBI on Unix

The easiest way to go about getting DBI installed on a *nix machine is to use Perl's CPAN interface. You will most likely need your sysadmin to do this. DBI by itself, however, does not know how to talk to any database. You need to install a database driver. Since you mentioned DB2, you will want Bundle::DBD::DB2. This includes Bundle::DBI which in turn includes DBI, DBI::Shell, Storable, Net::Daemon,RPC::PlServer, and DBD::Multiplex. If you have root on the box, try the following.

perl -MCPAN -e shell
[download]

This will ask you if you want to manually configure. I generally say 'No' on my dev boxes; Perl seems to select reasonable defaults and it all works. Once configuration is done, you should get a cpan> prompt. Here you can just type:

install Bundle::DBD::DB2
[download]

This will download the latest sources; determine any pre-dependencies; download and install any missing pre-dependencies; then make && make test && make install all of the packages mentioned above.

Note: DBD::DB2 will need to know the libraries and paths for DB2 in order to properly build and possibly even how to connect to a database to run make test.

Ivan Heffner
Sr. Software Engineer, DAS Lead
WhitePages.com, Inc.

Comment on Re: Install DBI on Unix Select or Download Code

Replies are listed 'Best First'.
Re^2: Install DBI on Unix by Tanktalus (Canon) on Sep 15, 2005 at 01:31 UTC
Last time I checked, the DBD::DB2 tests were superficial and didn't do anything whatsoever with DB2 (past loading the libraries). Which is why DB2::db's tests actually connect to a server, create a database, and do some minor stuff with it. That said, DBD::DB2 still does need the install path for DB2 (v8.2 by the sounds of the OP's question) to compile/link. I've been after the author of DBD::DB2 for years to get better tests into the suite, but he does this on company time (IBM actually pays someone to develop this), and this is but one of his responsibilities.	[reply]

Replies are listed 'Best First'.

Re^2: Install DBI on Unix
by Tanktalus (Canon) on Sep 15, 2005 at 01:31 UTC

Last time I checked, the DBD::DB2 tests were superficial and didn't do anything whatsoever with DB2 (past loading the libraries). Which is why DB2::db's tests actually connect to a server, create a database, and do some minor stuff with it.

That said, DBD::DB2 still does need the install path for DB2 (v8.2 by the sounds of the OP's question) to compile/link. I've been after the author of DBD::DB2 for years to get better tests into the suite, but he does this on company time (IBM actually pays someone to develop this), and this is but one of his responsibilities.

[reply]