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/
