Tarun,
The information you requested is below. Thanks for your help. Just a side note, I installed the V9.
+5 Client, set my DB2_HOME to the 9.5 path, and the compile was successful.
Here is the information:
# perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 2) configuration:
Platform:
osname=aix, osvers=5.2.0.0, archname=aix-thread-multi
uname='aix animals 2 5 000709cf4c00 '
config_args=''
hint=previous, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc_r', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialia
+s -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong',
optimize='-O',
cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NAT
+IVE_DLOPEN -DNEED_PTHREAD_INIT -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoa
+nsialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -D_ALL_SOURCE -D_A
+NSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT
+-q32 -D_LARGE_FILES -qlonglong -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoa
+nsialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -D_ALL_SOURCE -D_A
+NSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT
+-q32 -D_LARGE_FILES -qlonglong -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoa
+nsialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -D_ALL_SOURCE -D_A
+NSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT
+-q32 -D_LARGE_FILES -qlonglong'
ccversion='5.0.2.0', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='ld', ldflags =' -brtl -b32 -bmaxdata:0x80000000'
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lbind -lnsl -ldbm -ldl -lld -lm -lpthreads -lc_r -lcrypt -lbsd -lPW
perllibs=-lbind -lnsl -ldl -lld -lm -lpthreads -lc_r -lcrypt -lbsd -lPW
libc=/lib/libc.a, so=a, useshrplib=true, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='-bE:/usr/opt/perl5/lib/5.8.2/aix-thread-
+multi/CORE/perl.exp -bE:/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/perl.exp -bE:/usr/opt/perl5
+/lib/5.8.2/aix-thread-multi/CORE/perl.exp -bE:/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/perl.
+exp'
cccdlflags=' ', lddlflags='-bhalt:4 -bM:SRE -bI:$(PERL_INC)/perl.exp -bE:$(BASEEXT).exp -bnoent
+ry -lpthreads -lc_r'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
Locally applied patches:
SUIDPERLIO1 - fix PERLIO_DEBUG buffer overflow (CAN-2005-0156)
SPRINTF0 - fixes for sprintf formatting issues - CVE-2005-3962
REGCOMP0 - buffer overflow in regexp engine for UTF8 (CVE-2007-5116)
Built under aix
Compiled at Dec 5 2007 16:08:49
@INC:
/usr/opt/perl5/lib/5.8.2/aix-thread-multi
/usr/opt/perl5/lib/5.8.2
/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi
/usr/opt/perl5/lib/site_perl/5.8.2
/usr/opt/perl5/lib/site_perl
.
# uname -a
AIX frauddemo 3 5 00CA9E524C00
# env |grep DB2
DB2_HOME=/opt/IBM/db2/V9.1
DBI, DBD::DB2 Version:
I am using CPAN to install the packages, as root. The only DB2 related Environment variables are DB
+2_HOME, which I set to /opt/IBM/db2/V9.1 (install location of DB2. I installed ESE and CLIENT pack
+ages of DB2)
perl -MCPAN -e 'install DBI'
perl -MCPAN -e 'install DBD:DB2'
I currently have DBD::DB2 installed, using the db2 9.5 Client
Module Installed CPAN
DBI 1.607 1.607
DBD::DB2 1.3 1.3
Here is what is installed for V9.1
# /opt/IBM/db2/V9.1/install/db2ls -q -a -b /opt/IBM/db2/V9.1
Install Path: /opt/IBM/db2/V9.1
Feature Response File ID Level Fix Pack Feature Description
--------------------------------------------------------------------------------------------
DB2_PRODUCT_MESSAGES_EN 9.1.0.4 4a Product Messages - English
BASE_CLIENT 9.1.0.4 4a Base client support
JDK 9.1.0.4 4a IBM Software Development Kit (SDK) for Jav
+a(TM)
DB2_JAVA_HELP_EN 9.1.0.4 4a Java Help (HTML) - English
REPL_QSERVER 9.1.0.4 4a Replication with MQ Server
BASE_DB2_SERVER 9.1.0.4 4a Run-time Environment
SQL_PROCEDURES 9.1.0.4 4a SQL procedures
ICU_SUP 9.1.0.4 4a ICU Utilities
REPL_SERVER 9.1.0.4 4a SQL Replication Support
BASE_DB2_ENGINE 9.1.0.4 4a Base server support
CONNECT_SUPPORT 9.1.0.4 4a Connect support
JAVA_SUPPORT 9.1.0.4 4a Java support
JAVA_COMMON_FILES 9.1.0.4 4a Java Common files
SPATIAL_EXTENDER_CLIENT_SUPPORT 9.1.0.4 4a Spatial Extender client
APPLICATION_DEVELOPMENT_TOOLS 9.1.0.4 4a Base application development tools
ADMINISTRATION_SERVER 9.1.0.4 4a Administration Server
COMMUNICATION_SUPPORT_TCPIP 9.1.0.4 4a Communication support - TCP/IP
DATABASE_PARTITIONING_SUPPORT 9.1.0.4 4a Parallel Extension
REPL_CLIENT 9.1.0.4 4a Replication tools
DB2_DATA_SOURCE_SUPPORT 9.1.0.4 4a DB2 data source support
LDAP_EXPLOITATION 9.1.0.4 4a DB2 LDAP support
INSTANCE_SETUP_SUPPORT 9.1.0.4 4a DB2 Instance Setup wizard
XML_EXTENDER 9.1.0.4 4a XML Extender
FIRST_STEPS 9.1.0.4 4a First Steps
CLIENT_PRODUCT_SIGNATURE 9.1.0.4 4a Product Signature for DB2 Client
DB2_WEB_TOOLS 9.1.0.4 4a DB2 Web Tools
ESE_PRODUCT_SIGNATURE 9.1.0.4 4a Product Signature for DB2 Enterprise Serve
+r Edition
XML_EXTENDER_SAMPLES 9.1.0.4 4a XML Extender samples
DB2_SAMPLE_APPLICATIONS 9.1.0.4 4a ADT sample programs
SPATIAL_EXTENDER_SAMPLES 9.1.0.4 4a Spatial Extender samples
