Re: perl-5.6.0-DBI and DBD:DB2 on AIX 6.1

Hello,

On 13.02.2014 16:06, Straub, Brian C wrote:
> We have been using perl-5.6.0-DBI on AIX 6.1
Perl 5.6.0 is 14 years old and unsupported for years. Have you 
considered updating to a newer perl?

> to access an oracle 10 server.  It appears to be using the oracle 8 
> client still but does connect to our oracle 10 server without any issue.
Yes, it seems Oracle did a good job at compatibility.
> Now we'd like to use perl-5.6.0-DBI to access a DB2 V10.0 database. 
> Our perl program will be running on AIX 6.1 remotely from the DB2 
> V10.0 server which is running on a zOS mainframe system.
> I can see the DB2.pm module is not installed within our perl-5.6.0-DBI 
> installation.
So you need to install it. You will need a DB2 client, the DBD::DB2 
package, and of course the compiler that was used to compile perl. Don't 
just copy DB2.pm anywhere, install using the cpan utility. Run cpan, 
type "install DBD::DB2". Or at least, download and unpack the DBD::DB2 
package, run perl Makefile.PL, make, make test, make install, as usual.

Check the Readme file at http://search.cpan.org/dist/DBD-DB2/, maybe you 
need to manually download an older version of DBD::DB2. Currently, it 
seems DBD::DB2 v1.85 works with perl 5.6.0, and requires DBI 1.21.

DBI 1.21 was released between 2002, the oldest DBI newer that 1.21 that 
is still available at CPAN is v1.50, released 2005. DBI 1.49 requires at 
least perl 5.6.1, so if your DBI is older than 1.21, you need to 
manually upgrade DBI to a verson older than 1.49, then recompile all 
DBDs including DBD::Oracle.

> The Oracle.pm module is there.
Irrelevant.
> How do we go about installing the correct DBD:DB2 version on our AIX 
> 6.1 system to work with our perl-5.6.0-DBI installation ?
See above.
> How do we choose the correct DB2 client version for AIX 6.1 to go 
> along with the DBD:DB2 version ?
Use the client with the same version as the database.

Hope that helps,
Alexander
> *Brian Straub*, Assistant Vice President
> *State Street Corporation *|  ETS / Solutions Quality Engineering  / 
> Interchange Engineering
> 1776 Heritage Drive, JAB4W, N. Quincy, MA  02171
> *P* +1 617 662 5170 | *M* +1 617 592 5004  | [email protected]_ 
> <mailto:[email protected]>
> The information contained in this email and any attachments have been 
> classified as limited access and/or privileged State Street 
> information/communication and is intended solely for the use of the 
> named addressee(s). If you are not an intended recipient or a person 
> responsible for delivery to an intended recipient, please notify the 
> author and destroy this email. Any unauthorized copying, disclosure, 
> retention or distribution of the material in this email is strictly 
> forbidden.
>
> *Go green. *Consider the environment before printing this email.
> Data Classification - Limited Access


-- 
Alexander Foken
mailto:[email protected]  http://www.foken.de/alexander/