Could you pls help to solve this problem

Hi Dear,

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"

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/dbdimp.c
DBD-DB2-1.80/DB2.pm
DBD-DB2-1.80/README
DBD-DB2-1.80/META.yml
DBD-DB2-1.80/DB2.xs
DBD-DB2-1.80/lib/
DBD-DB2-1.80/lib/Bundle/
DBD-DB2-1.80/lib/Bundle/.copyarea.db
DBD-DB2-1.80/lib/Bundle/DBD/
DBD-DB2-1.80/lib/Bundle/DBD/DB2.pm
DBD-DB2-1.80/lib/Bundle/DBD/.copyarea.db
DBD-DB2-1.80/lib/.copyarea.db
DBD-DB2-1.80/test.pl
DBD-DB2-1.80/HISTORY
DBD-DB2-1.80/DB2.h
DBD-DB2-1.80/t/
DBD-DB2-1.80/t/main.t
DBD-DB2-1.80/t/base.t
DBD-DB2-1.80/t/.copyarea.db
DBD-DB2-1.80/DB2.pod
DBD-DB2-1.80/LICENSE
DBD-DB2-1.80/dbdimp.h
DBD-DB2-1.80/CAVEATS
DBD-DB2-1.80/Changes
DBD-DB2-1.80/Makefile.PL
DBD-DB2-1.80/Constants/
DBD-DB2-1.80/Constants/Constants.xs
DBD-DB2-1.80/Constants/Constants.pm
DBD-DB2-1.80/Constants/Makefile.PL
DBD-DB2-1.80/Constants/.copyarea.db
DBD-DB2-1.80/Constants/MANIFEST
DBD-DB2-1.80/.copyarea.db
DBD-DB2-1.80/tests/
DBD-DB2-1.80/tests/perld076_connInvalidStringInvalidParamsRemote.pl
DBD-DB2-1.80/tests/perld028_stmtCreateTableWithNonGraphicTypes.pl
DBD-DB2-1.80/tests/perld094_testSQLRowCount.pl
DBD-DB2-1.80/tests/perld012_testAutoCommitOFFAndRollback.pl
DBD-DB2-1.80/tests/perld090_testStoredProc.pl
DBD-DB2-1.80/tests/perld089_stmtRetrieveXMLUsingBLOBRead.pl
DBD-DB2-1.80/tests/perldutl.pl
DBD-DB2-1.80/tests/perld007_connValid3ConnWithoutDiscon.pl
DBD-DB2-1.80/tests/perld068_connIncorrectUIDRemote.pl
DBD-DB2-1.80/tests/perld041stmt_SelectGraphicDataTypesUsingBindColumns.pl
DBD-DB2-1.80/tests/run-tests.pl
DBD-DB2-1.80/tests/perld066_testBindParamArrayWithUpdate.pl
DBD-DB2-1.80/tests/perld010_testAutoCommintON.pl
DBD-DB2-1.80/tests/connection.pl
DBD-DB2-1.80/tests/perld080_testGetInfoFor32BitInteger.pl
DBD-DB2-1.80/tests/perld035_stmtCreateTableBITData.pl
DBD-DB2-1.80/tests/perld014_testAutoCommitONAndCommit.pl
DBD-DB2-1.80/tests/perld003_connInvalidUserID.pl
DBD-DB2-1.80/tests/perld058_testChangingOfChopBlanksValue.pl
DBD-DB2-1.80/tests/perld006_connValidDBIEnvVarsEmptyUserIDPassword.pl
DBD-DB2-1.80/tests/perld_null_clob_test.pl
DBD-DB2-1.80/tests/perld069_connIncorrectPassRemote.pl
DBD-DB2-1.80/tests/perld030_stmtSelectBindPrepareExecuteUsingBindCol.pl
DBD-DB2-1.80/tests/perld092_typeDecfloat.pl
DBD-DB2-1.80/tests/perld067_connIncorrectDBNameRemote.pl
DBD-DB2-1.80/tests/perld002_connInvalidDBName.pl
DBD-DB2-1.80/tests/perld083_testDB2LoginTimeoutLocal.pl
DBD-DB2-1.80/tests/perld043_stmtTryFetchForNonSelect.pl
DBD-DB2-1.80/tests/perld059_testChopBlanksONDuringConnect.pl
DBD-DB2-1.80/tests/perld000_createTables.pl
DBD-DB2-1.80/tests/perld071_connIncorrectPortRemote.pl
DBD-DB2-1.80/tests/perld091_connAttrApplicationName.pl
DBD-DB2-1.80/tests/perld032_stmtInsertPrepareExecuteNumberDataTypes.pl
DBD-DB2-1.80/tests/perld053_retrieveCLOBData.pl
DBD-DB2-1.80/tests/perld001_connValid.pl
DBD-DB2-1.80/tests/perld027_stmtNumParamsNumFieldsOnNonSelectWithParamMarkers.pl
DBD-DB2-1.80/tests/perld079_testGetInfoFor16BitInteger.pl
DBD-DB2-1.80/tests/perld081_connWithSchema.pl
DBD-DB2-1.80/tests/perld095_chopblanks_test.pl
DBD-DB2-1.80/tests/perld054_testDefaultChopBlanksSetting.pl
DBD-DB2-1.80/tests/exp/
DBD-DB2-1.80/tests/exp/perld051_verifyDBHandleOnInactiveDestroyb.exp
DBD-DB2-1.80/tests/exp/perld055_testSetChopBlanksON.exp
DBD-DB2-1.80/tests/exp/perld058_testChangingOfChopBlanksValue.exp
DBD-DB2-1.80/tests/exp/perld006_connValidDBIEnvVarsEmptyUserIDPassword.exp
DBD-DB2-1.80/tests/exp/perld030_stmtSelectBindPrepareExecuteUsingBindCol.exp
DBD-DB2-1.80/tests/exp/perld008_connValid3ConnWithDiscon.exp
DBD-DB2-1.80/tests/exp/perld014_testAutoCommitONAndCommit.exp
DBD-DB2-1.80/tests/exp/perld013_testAutoCommitONAndRollback.exp
DBD-DB2-1.80/tests/exp/perld010_testAutoCommintON.exp
DBD-DB2-1.80/tests/exp/perld059_testChopBlanksONDuringConnect.exp
DBD-DB2-1.80/tests/exp/perld054_testDefaultChopBlanksSetting.exp
DBD-DB2-1.80/tests/exp/perld012_testAutoCommitOFFAndRollback.exp
DBD-DB2-1.80/tests/exp/perld045_stmtCheckActiveAttrForStmtHandleAfterFinish1.exp
DBD-DB2-1.80/tests/exp/perld034_stmtReuseStmtHandle.exp
DBD-DB2-1.80/tests/exp/perld077_conn7ConnectionsRemote.exp
DBD-DB2-1.80/tests/exp/.copyarea.db
DBD-DB2-1.80/tests/exp/perld052_verifyCachedKidsAttr.exp
DBD-DB2-1.80/tests/exp/perld051_verifyDBHandleOnInactiveDestroya.exp
DBD-DB2-1.80/tests/exp/perld015_resetAutoCommitMultTimes.exp
DBD-DB2-1.80/tests/exp/perld056_testSetChopBlanksOFF.exp
DBD-DB2-1.80/tests/exp/perld011_testAutoCommitOFFAndCommit.exp
DBD-DB2-1.80/tests/exp/perld057_testChopBkanksChangedFromDBH.exp
DBD-DB2-1.80/tests/exp/perld018_verify017RolledBack.exp
DBD-DB2-1.80/tests/exp/perld007_connValid3ConnWithoutDiscon.exp
DBD-DB2-1.80/tests/exp/perld009_testAutoCommintOFF.exp
DBD-DB2-1.80/tests/perld074_connValidDBIEnvVarsRemote.pl
DBD-DB2-1.80/tests/perld084_testDB2LoginTimeoutRemote.pl
DBD-DB2-1.80/tests/perld048_stmtCompareReturnRowsResultforExecuteAndRows1.pl
DBD-DB2-1.80/tests/perld051_verifyDBHandleOnInactiveDestroy.pl
DBD-DB2-1.80/tests/perld082_connWithDefaultSchema.pl
DBD-DB2-1.80/tests/perld070_connIncorrectHostRemote.pl
DBD-DB2-1.80/tests/perld078_testGetInfoForString.pl
DBD-DB2-1.80/tests/perld039_stmtInsertPrepareExecuteGraphicDataTypes.pl
DBD-DB2-1.80/tests/perld013_testAutoCommitONAndRollback.pl
DBD-DB2-1.80/tests/perld025_stmtNumParamsNumFieldsWithoutParamMarkers.pl
DBD-DB2-1.80/tests/perld011_testAutoCommitOFFAndCommit.pl
DBD-DB2-1.80/tests/perld061_pingConnWithForceAppAll.pl
DBD-DB2-1.80/tests/perld037_stmtSelectBITDataUsingBindCol.pl
DBD-DB2-1.80/tests/perld086_stmtInsertXMLColumn.pl
DBD-DB2-1.80/tests/perld023_stmtReturnsUndefOnError.pl
DBD-DB2-1.80/tests/perld026_stmtNumParamsNumFieldsWithParamMarkers.pl
DBD-DB2-1.80/tests/perld046_stmtCheckActiveAttrForStmtHandleOnError.pl
DBD-DB2-1.80/tests/perld005_connValidDBIEnvVars.pl
DBD-DB2-1.80/tests/perld018_verify017RolledBack.pl
DBD-DB2-1.80/tests/perld056_testSetChopBlanksOFF.pl
DBD-DB2-1.80/tests/perld055_testSetChopBlanksON.pl
DBD-DB2-1.80/tests/perld085_stmtCreateTableXMLColumn.pl
DBD-DB2-1.80/tests/perld029_stmtInsertPrepareAndExecute.pl
DBD-DB2-1.80/tests/.copyarea.db
DBD-DB2-1.80/tests/perld093_testStoredPrcMultResultset.pl
DBD-DB2-1.80/tests/perld062_pingConnWithdb2stop.pl
DBD-DB2-1.80/tests/perld009_testAutoCommintOFF.pl
DBD-DB2-1.80/tests/perld057_testChopBkanksChangedFromDBH.pl
DBD-DB2-1.80/tests/perld063_testBindParamArray.pl
DBD-DB2-1.80/tests/perld050_stmtExecuteReturnsUndefOnError.pl
DBD-DB2-1.80/tests/perld022_stmtRowsAffectedUnknown.pl
DBD-DB2-1.80/tests/perld015_resetAutoCommitMultTimes.pl
DBD-DB2-1.80/tests/perld045_stmtCheckActiveAttrForStmtHandleAfterFinish1.pl
DBD-DB2-1.80/tests/perld_trusted_context.pl
DBD-DB2-1.80/tests/perld020_stmtWithHostVars.pl
DBD-DB2-1.80/tests/perld065_testBindParamArray2.pl
DBD-DB2-1.80/tests/perld019_stmtWithVendorEscape.pl
DBD-DB2-1.80/tests/err/
DBD-DB2-1.80/tests/perld073_connValidRemote.pl
DBD-DB2-1.80/tests/perld075_connValidStringInvalidParamsRemote.pl
DBD-DB2-1.80/tests/perld033_stmtSelectNumberDataTypesUsingBindCol.pl
DBD-DB2-1.80/tests/perld077_conn7ConnectionsRemote.pl
DBD-DB2-1.80/tests/perld034_stmtReuseStmtHandle.pl
DBD-DB2-1.80/tests/perld042_stmtTryFetchWithoutExecute.pl
DBD-DB2-1.80/tests/perld004_connInvalidPassword.pl
DBD-DB2-1.80/tests/perld040_stmtSelectGraphicDataTypesUsingBindCol.pl
DBD-DB2-1.80/tests/perld008_connValid3ConnWithDiscon.pl
DBD-DB2-1.80/tests/perld031_stmtCreateTableNumberDataTypes.pl
DBD-DB2-1.80/tests/perld038_stmtCreateTableGraphicDataTypes.pl
DBD-DB2-1.80/tests/res/
DBD-DB2-1.80/tests/perld052_verifyCachedKidsAttr.pl
DBD-DB2-1.80/tests/perld024_stmtWithParamMarkers.pl
DBD-DB2-1.80/tests/perld088_stmtSelectXMLUsingBindColumns.pl
DBD-DB2-1.80/tests/perld064_testExecuteArray.pl
DBD-DB2-1.80/tests/perld047_stmtCompareReturnRowsResultforExecuteAndRows.pl
DBD-DB2-1.80/tests/perld060_pingConnWithNormalDisconnect.pl
DBD-DB2-1.80/tests/perld036_stmtInsertPrepareExecuteBITData.pl
DBD-DB2-1.80/tests/perld016_disconWithoutCallingFinish.pl
DBD-DB2-1.80/tests/perld044_stmtCheckActiveAttrForStmtHandleAfterFinish.pl
DBD-DB2-1.80/tests/perld072_connIncorrectProtocolRemote.pl
DBD-DB2-1.80/tests/perld049_stmtCompareReturnRowsResultforExecuteAndRows2.pl
DBD-DB2-1.80/tests/perld021_stmtUpdateReturnRowsAffected.pl
DBD-DB2-1.80/tests/perld087_stmtSelectXMLUsingBindCol.pl
DBD-DB2-1.80/tests/perld017_disconWithAutocomOFFRollback.pl
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"
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...
Looks good
Checking if your kit is complete...
Looks good
Writing Makefile for DBD::DB2::Constants
Writing Makefile for DBD::DB2
cp DB2.pm blib/lib/DBD/DB2.pm
cp lib/Bundle/DBD/.copyarea.db blib/lib/Bundle/DBD/.copyarea.db
cp lib/.copyarea.db blib/lib/.copyarea.db
cp lib/Bundle/.copyarea.db blib/lib/Bundle/.copyarea.db
cp lib/Bundle/DBD/DB2.pm blib/lib/Bundle/DBD/DB2.pm
cp DB2.pod blib/lib/DBD/DB2.pod
make[1]: Entering directory
`/root/.cpan/build/DBD-DB2-1.80-YvtLsl/Constants'
cp Constants.pm ../blib/lib/DBD/DB2/Constants.pm
AutoSplitting ../blib/lib/DBD/DB2/Constants.pm
(../blib/lib/auto/DBD/DB2/Constants)
/usr/local/perl/bin/perl /usr/local/perl/lib/5.10.1/ExtUtils/xsubpp
-typemap /usr/local/perl/lib/5.10.1/ExtUtils/typemap  Constants.xs >
Constants.xsc && mv Constants.xsc Constants.c
cc -c  -I"/usr/include" -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"
Constants.c
Running Mkbootstrap for DBD::DB2::Constants ()
chmod 644 Constants.bs
rm -f ../blib/arch/auto/DBD/DB2/Constants/Constants.so
cc  -shared -O2 -L/usr/local/lib Constants.o
-o ../blib/arch/auto/DBD/DB2/Constants/Constants.so      \
        \

chmod 755 ../blib/arch/auto/DBD/DB2/Constants/Constants.so
cp Constants.bs ../blib/arch/auto/DBD/DB2/Constants/Constants.bs
chmod 644 ../blib/arch/auto/DBD/DB2/Constants/Constants.bs
make[1]: Leaving directory
`/root/.cpan/build/DBD-DB2-1.80-YvtLsl/Constants'
/usr/local/perl/bin/perl /usr/local/perl/lib/5.10.1/ExtUtils/xsubpp
-typemap /usr/local/perl/lib/5.10.1/ExtUtils/typemap  DB2.xs > DB2.xsc &&
mv DB2.xsc DB2.c
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  DB2.c
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
  /usr/bin/make -- NOT OK
Running make test
  Can't test without successful make
Running make install
  Make had returned bad status, install seems impossible
Failed during this command:
 IBMTORDB2/DBD-DB2-1.80a.tar.gz               : make NO


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