It turned out that I had not download and installed the proper version of
DB2. I revisited IBM's web site and downloaded the developer's edition.
After installing this version of DB2 I was able to successfully compile and
install the DBD::DB2 module for perl. Thanks to all who responded to my
request for help.
*****************************************
Richard Rice
Continental Tire North America, Inc.
(704) 583-8668
*****************************************
Jonathan Leffler
<jonathan.leffler
@gmail.com> To
"[EMAIL PROTECTED]"
03/20/2005 04:52 <[EMAIL PROTECTED]>
AM cc
[email protected]
Subject
Please respond to Re: Error installing DBD::DB2 on
Jonathan Leffler AIX 5
<jonathan.leffler
@gmail.com>
One part of your problem is that Perl was built with a compiler you
don't have (or aren't using). When Perl was built, the compiler
understood -qmaxmem etc.
I'd guess that the rest of your problem is that you don't have the
necessary connectivity software installed - or the SDK for it.
Take a good look at the DBD::DB2 README file...wherein it says:
Ensure the following DB2 product is installed.
DB2 Application Development Client v7.2 or later
Included with the DB2 Personal Developer's Edition and the
DB2 Universal Developer's Edition
The Application Development Client can be downloaded here:
http://www.ibm.com/software/data/db2/udb/support/
On Sat, 19 Mar 2005 14:08:44 -0500, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
>
> I am having a problem install the DBD::DB2 module on my IBM server
running
> AIX 5. I download DBI-1.48 from the CPAN site and successfully installed
> it. I also downloaded DBD-DB2-0.78 from the CPAN site but I am having a
> problem installing it. I get an error when I issue the 'make' command. I
> have successfully installed 'IBM DB2 Universal Database' and I can issue
> db2 commands from an xterm session to my database. I need to install the
> DBD::DB2 module so that I can write a perl script to access my database.
> Any help would be appreciated. I have include information concerning the
> install .Please let me know if you need any further information.
>
>
--------------------------------------------------------------------------------------------------------
>
> IBM DB2 Universal Database
> Release Notes
>
> Version 8.2 (Version 8.1 FixPak 7)
>
> Before using this information and the product it supports, be sure to
> read the general information under Notices.
>
>
----------------------------------------------------------------------------------------------------------
>
> perl -v
>
> This is perl, v5.8.3 built for aix
>
> Copyright 1987-2003, Larry Wall
>
> Perl may be copied only under the terms of either the Artistic License or
> the
> GNU General Public License, which may be found in the Perl 5 source kit.
>
> Complete documentation for Perl, including FAQ lists, should be found on
> this system using `man perl' or `perldoc perl'. If you have access to
the
> Internet, point your browser at http://www.perl.com/, the Perl Home Page.
>
>
------------------------------------------------------------------------------------------------------------
>
> gcc -v
> Reading specs from /usr/local/lib/gcc/powerpc-ibm-aix5.1.0.0/3.4.3/specs
> Configured with: ../gcc-3.4.3/configure --disable-nls --disable-aix64
> Thread model: aix
> gcc version 3.4.3
>
>
-------------------------------------------------------------------------------------------------------------
>
> DBD-DB2-0.78: perl Makefile.PL
>
> Configuring DBD::DB2...
> Remember to actually read the README and CAVEATS files!
>
> Using DB2 in "/local_home/db2inst1/sqllib"
> System: perl5.008003 DBI1.48 aix pdslib51 1 5 00088d5f4c00 aix dl_aix.xs
> Compiler: cc -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -I/usr/local/include
-q32
> -D_LARGE_FILES -qlonglong
> Includes: -I"/local_home/db2inst1/sqllib/include"
> -I"/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI"
> Libraries: -L/local_home/db2inst1/sqllib/lib -ldb2
>
> Checking if your kit is complete...
> Looks good
> Checking if your kit is complete...
> Looks good
> Writing Makefile for DBD::DB2::Constants
> Writing Makefile for DBD::DB2
>
>
-----------------------------------------------------------------------------------------------------------
>
> make
> cc -c -I"/local_home/db2inst1/sqllib/include"
> -I"/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI" -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES -qlonglong
-O
> -DVERSION=\"0.78\" -DXS_VERSION=\"0.78\" "-I/usr/local/lib/perl5/5.8.3
> /aix/CORE" DB2.c
> cc: unrecognized option `-qmaxmem=16384'
> cc: unrecognized option `-qnoansialias'
> cc: unrecognized option `-q32'
> cc: unrecognized option `-qlonglong'
> In file included from DB2.xs:7:
> DB2.h:9:20: sqlcli.h: No such file or directory
> DB2.h:11:21: sqlcli1.h: No such file or directory
> DB2.h:12:20: sqlext.h: No such file or directory
> DB2.h:14:66: sqlstate.h: No such file or directory
> In file included from DB2.h:20,
> from DB2.xs:7:
> dbdimp.h:16: error: parse error before "SQLHENV"
> dbdimp.h:16: warning: no semicolon at end of struct or union
> dbdimp.h:19: error: parse error before '}' token
> dbdimp.h:24: error: parse error before "SQLHENV"
> dbdimp.h:24: warning: no semicolon at end of struct or union
> dbdimp.h:25: warning: data definition has no type or storage class
> dbdimp.h:27: error: parse error before '}' token
> dbdimp.h:33: error: parse error before "SQLHENV"
> dbdimp.h:33: warning: no semicolon at end of struct or union
> dbdimp.h:34: warning: data definition has no type or storage class
> dbdimp.h:35: error: parse error before "phstmt"
> dbdimp.h:35: warning: data definition has no type or storage class
> dbdimp.h:38: error: parse error before '*' token
> dbdimp.h:38: warning: data definition has no type or storage class
> dbdimp.h:42: error: parse error before "done_desc"
> dbdimp.h:42: warning: data definition has no type or storage class
> dbdimp.h:44: error: parse error before '*' token
> dbdimp.h:44: warning: data definition has no type or storage class
> dbdimp.h:48: error: parse error before "RowCount"
> dbdimp.h:48: warning: data definition has no type or storage class
> dbdimp.h:55: error: parse error before '}' token
> dbdimp.h:63: error: parse error before "SQLSMALLINT"
> dbdimp.h:63: warning: no semicolon at end of struct or union
> dbdimp.h:64: warning: data definition has no type or storage class
> dbdimp.h:65: error: parse error before "cbufl"
> dbdimp.h:65: warning: data definition has no type or storage class
> dbdimp.h:66: error: parse error before "dsize"
> dbdimp.h:66: warning: data definition has no type or storage class
> dbdimp.h:67: error: parse error before "prec"
> dbdimp.h:67: warning: data definition has no type or storage class
> dbdimp.h:68: error: parse error before "scale"
> dbdimp.h:68: warning: data definition has no type or storage class
> dbdimp.h:69: error: parse error before "nullok"
> dbdimp.h:69: warning: data definition has no type or storage class
> dbdimp.h:72: error: parse error before "ftype"
> dbdimp.h:72: warning: data definition has no type or storage class
> dbdimp.h:75: error: parse error before "bufferSize"
> dbdimp.h:75: warning: data definition has no type or storage class
> dbdimp.h:76: error: parse error before "rlen"
> dbdimp.h:76: warning: data definition has no type or storage class
> dbdimp.h:86: error: parse error before "SQLUSMALLINT"
> dbdimp.h:86: warning: no semicolon at end of struct or union
> dbdimp.h:87: error: conflicting types for 'indp'
> dbdimp.h:73: error: previous declaration of 'indp' was here
> dbdimp.h:87: warning: data definition has no type or storage class
> dbdimp.h:90: error: parse error before "descSQLType"
> dbdimp.h:90: warning: data definition has no type or storage class
> dbdimp.h:91: error: parse error before "descDecimalDigits"
> dbdimp.h:91: warning: data definition has no type or storage class
> dbdimp.h:92: error: parse error before "descColumnSize"
> dbdimp.h:92: warning: data definition has no type or storage class
> dbdimp.h:95: error: parse error before "sql_state"
> dbdimp.h:95: warning: data definition has no type or storage class
> DB2.xs: In function `XS_DBD__DB2__dr_disconnect_all':
> DB2.xs:41: error: dereferencing pointer to incomplete type
> DB2.xs:42: error: dereferencing pointer to incomplete type
> DB2.xs: In function `XS_DBD__DB2__db_commit':
> DB2.xs:91: error: dereferencing pointer to incomplete type
> DB2.xs: In function `XS_DBD__DB2__db_rollback':
> DB2.xs:100: error: dereferencing pointer to incomplete type
> DB2.xs: In function `XS_DBD__DB2__db_disconnect':
> DB2.xs:109: error: dereferencing pointer to incomplete type
> DB2.xs:113: error: dereferencing pointer to incomplete type
> DB2.xs:114: error: dereferencing pointer to incomplete type
> DB2.xs:115: error: dereferencing pointer to incomplete type
> DB2.xs:119: error: dereferencing pointer to incomplete type
> DB2.xs:119: error: dereferencing pointer to incomplete type
> DB2.xs:121: error: dereferencing pointer to incomplete type
> DB2.xs:123: error: dereferencing pointer to incomplete type
> DB2.xs: In function `XS_DBD__DB2__db_DESTROY':
> DB2.xs:164: error: dereferencing pointer to incomplete type
> DB2.xs:166: error: dereferencing pointer to incomplete type
> DB2.xs:173: error: dereferencing pointer to incomplete type
> DB2.xs:174: error: dereferencing pointer to incomplete type
> DB2.xs:175: error: dereferencing pointer to incomplete type
> DB2.xs:177: error: dereferencing pointer to incomplete type
> DB2.xs:178: error: dereferencing pointer to incomplete type
> DB2.xs:178: error: dereferencing pointer to incomplete type
> DB2.xs:178: error: dereferencing pointer to incomplete type
> DB2.xs:180: error: dereferencing pointer to incomplete type
> DB2.xs:188: error: dereferencing pointer to incomplete type
> DB2.xs:189: error: dereferencing pointer to incomplete type
> DB2.xs:194: error: dereferencing pointer to incomplete type
> DB2.xs:194: error: dereferencing pointer to incomplete type
> DB2.xs:194: error: dereferencing pointer to incomplete type
> DB2.xs: In function `XS_DBD__DB2__st_execute':
> DB2.xs:336: error: dereferencing pointer to incomplete type
> DB2.xs:338: error: dereferencing pointer to incomplete type
> DB2.xs:343: error: dereferencing pointer to incomplete type
> DB2.xs:344: error: dereferencing pointer to incomplete type
> DB2.xs:345: error: dereferencing pointer to incomplete type
> DB2.xs:360: error: dereferencing pointer to incomplete type
> DB2.xs:361: error: dereferencing pointer to incomplete type
> DB2.xs: In function `XS_DBD__DB2__st_finish':
> DB2.xs:406: error: dereferencing pointer to incomplete type
> DB2.xs:407: error: dereferencing pointer to incomplete type
> DB2.xs:411: error: dereferencing pointer to incomplete type
> DB2.xs:414: error: dereferencing pointer to incomplete type
> DB2.xs:414: error: dereferencing pointer to incomplete type
> DB2.xs:414: error: dereferencing pointer to incomplete type
> DB2.xs: In function `XS_DBD__DB2__st_DESTROY':
> DB2.xs:472: error: dereferencing pointer to incomplete type
> DB2.xs:474: error: dereferencing pointer to incomplete type
> DB2.xs:480: error: dereferencing pointer to incomplete type
> DB2.xs:481: error: dereferencing pointer to incomplete type
> DB2.xs:481: error: dereferencing pointer to incomplete type
> DB2.xs:481: error: dereferencing pointer to incomplete type
> DB2.xs:483: error: dereferencing pointer to incomplete type
> DB2.xs:484: error: dereferencing pointer to incomplete type
> DB2.xs:485: error: dereferencing pointer to incomplete type
> DB2.xs:489: error: dereferencing pointer to incomplete type
> DB2.xs:489: error: dereferencing pointer to incomplete type
> DB2.xs:489: error: dereferencing pointer to incomplete type
> DB2.xs: In function `boot_DBD__DB2':
> DB2.xs:24: error: invalid application of `sizeof' to incomplete type
> `/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI/DBIXS.h'
> DB2.xs:25: error: invalid application of `sizeof' to incomplete type
> `/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI/DBIXS.h'
> DB2.xs:26: error: invalid application of `sizeof' to incomplete type
> `/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI/DBIXS.h'
> make: 1254-004 The error code from the last command is 1.
>
> Stop.
>
> *****************************************
> Richard Rice
> Continental Tire North America, Inc.
> (704) 583-8668
> *****************************************
>
>
--
Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h>
Guardian of DBD::Informix - v2005.01 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
