On Tue, Apr 19, 2011 at 23:30, Jonathan Leffler <jonathan.leff...@gmail.com>wrote:
> > > 2011/4/19 mao jia li <limao...@cn.ibm.com> > >> DBD:DB2 can not install successful on my local linux OS. Could you help to >> solve this problem? Thanks very much. >> Pls see Screenshot below: >> >> [root@glasc .cpan]# uname -a >> Linux glasc 2.4.21-15.EL #1 Thu Apr 22 00:27:41 EDT 2004 i686 i686 i386 >> GNU/Linux >> [root@glasc .cpan]$ db2level >> DB21085I Instance "db2inst1" uses "32" bits and DB2 code release >> "SQL08010" >> with level identifier "01010106". >> Informational tokens are "DB2 v8.1.0.0", "s021023", "", and FixPak "0". >> Product is installed at "/opt/IBM/db2/V8.1" >> > > This says the DB2 software is in /opt/IBM/db2/V8.1 > > Also, it says version 8.1 - is that new enough to work with the DBD::DB2 > driver? What does the documentation recommend as the minimum version > number? > Answer (from http://search.cpan.org/~ibmtordb2/DBD-DB2-1.80a/DB2.pod): The DBD::DB2 driver is supported by DB2 UDB V9 and later. See http://www.software.ibm.com/data/db2/perl for more information on supported environments. Time to upgrade the DB2 you are using - or downgrade to a version of DBD::DB2 that supports DB2 V8.1. > [image: Inactive hide details for Use Cpan]Use Cpan >> cpan[3]> install DBD:DB2 >> Running install for module 'DBD::DB2' >> CPAN: YAML loaded ok (v0.71) >> Running make for I/IB/IBMTORDB2/DBD-DB2-1.80a.tar.gz >> CPAN: Digest::SHA loaded ok (v5.47) >> CPAN: Compress::Zlib loaded ok (v2.02) >> Checksum for >> /root/.cpan/sources/authors/id/I/IB/IBMTORDB2/DBD-DB2-1.80a.tar.gz ok >> Scanning cache /root/.cpan/build for sizes >> >> ............................................................................DONE >> CPAN: Archive::Tar loaded ok (v1.52) >> DBD-DB2-1.80/ >> ... >> DBD-DB2-1.80/MANIFEST >> CPAN: File::Temp loaded ok (v0.22) >> >> CPAN.pm: Going to build I/IB/IBMTORDB2/DBD-DB2-1.80a.tar.gz >> >> >> Configuring DBD::DB2... >> Remember to actually read the README and CAVEATS files! >> >> Using DB2 in "/usr" >> >> > This suggests /usr > > The discrepancy is worrying. > > > >> System: perl5.010001 DBI1.616 linux glasc 2.4.21-15.el #1 thu apr 22 >> 00:27:41 edt 2004 i686 i686 i386 gnulinux i686-linux dl_dlopen.xs >> Compiler: cc -O2 -fno-strict-aliasing -pipe -I/usr/local/include >> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 >> Includes: -I"/usr/include" >> -I"/usr/local/perl/lib/site_perl/5.10.1/i686-linux/auto/DBI" >> -I"/usr/local/perl/lib/5.10.1/i686-linux/auto/DBI" >> -I"/usr/local/perl/lib/site_perl/5.10.1/i686-linux/auto/DBI" >> Libraries: -L/usr/lib -ldb2 >> >> Checking if your kit is complete... >> ... >> >> cc -c -I"/usr/include" >> -I"/usr/local/perl/lib/site_perl/5.10.1/i686-linux/auto/DBI" >> -I"/usr/local/perl/lib/5.10.1/i686-linux/auto/DBI" >> -I"/usr/local/perl/lib/site_perl/5.10.1/i686-linux/auto/DBI" >> -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE >> -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.80\" -DXS_VERSION=\"1.80\" -fPIC >> "-I/usr/local/perl/lib/5.10.1/i686-linux/CORE" -DDB2_CACHE_FIX dbdimp.c >> dbdimp.c: In function `diagnoseError': >> dbdimp.c:51: warning: unreachable code at beginning of switch statement >> dbdimp.c: In function `dbd_db_connect': >> dbdimp.c:344: `SQL_ATTR_INFO_PROGRAMNAME' undeclared (first use in this >> function) >> dbdimp.c:344: (Each undeclared identifier is reported only once >> dbdimp.c:344: for each function it appears in.) >> dbdimp.c: In function `getConnectAttr': >> dbdimp.c:790: `SQL_ATTR_INFO_PROGRAMNAME' undeclared (first use in this >> function) >> dbdimp.c: In function `db2_db_STORE_attrib': >> dbdimp.c:869: `SQL_ATTR_INFO_PROGRAMNAME' undeclared (first use in this >> function) >> dbdimp.c: In function `db2_db_FETCH_attrib': >> dbdimp.c:1014: `SQL_ATTR_INFO_PROGRAMNAME' undeclared (first use in this >> function) >> dbdimp.c: In function `db2_describe': >> dbdimp.c:1260: `SQL_DATABASE_CODEPAGE' undeclared (first use in this >> function) >> dbdimp.c:1292: `SQL_APPLICATION_CODEPAGE' undeclared (first use in this >> function) >> make: *** [dbdimp.o] Error 1 >> IBMTORDB2/DBD-DB2-1.80a.tar.gz >> >> There isn't self-evidently a header missing, so the discrepancy in the > locations may not matter. > But, I do rather suspect that your DB2 is too old to work with DBD::DB2. > -- Jonathan Leffler <jonathan.leff...@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."