Re: Could you pls help to solve this problem

Hi
Thank you  very much, so quick response.

Cheers :-)

Jeffrey
Maojia Li(李茂嘉)
E_mail:[email protected]
IBM Chengdu Global Delivery Center
Phone: 028-85302399
Mobile:186-0289-5200
Address:5/F, A5 Bldg, Tianfu Software Park,Tianfu Ave, Chengdu
P. R. China 610041
成都市高新区天府大道天府软件园区A5号楼5楼IBM,610041




From:	Jonathan Leffler <[email protected]>
To:	mao jia li/China/IBM@IBMCN
Cc:	[email protected]
Date:	04/20/2011 02:39 PM
Subject:	Re: Could you pls help to solve this problem





On Tue, Apr 19, 2011 at 23:30, Jonathan Leffler <[email protected]
> wrote:


  2011/4/19 mao jia li <[email protected]>
   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.


   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 <[email protected]>  #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."