Posted on 2009-01-22 15:45:57-08 by lush in response to 9779
Re: DBD::DB2 make failed
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
Direct Responses: 10908 | Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.