DBD-DB2 - RE: DBD::DB2 Module compiles and installs on AIX 5.3 but throws a run-time error

Posted on Tue Jun 21 02:45:18 2005 by grassman
RE: DBD::DB2 Module compiles and installs on AIX 5.3 but throws a run-time error
Hi, I am trying to get my perl DBD::DB2 to run error-free on my IBM p570 development machine which itself is running on AIX 5.3 and also has the DB2 UDB v8.2 development client installed. 1. It (i.e. the DBD::DB2 CPAN module) fails (i.e. only 60% of the tests pass) the "make test" invocation and complains about not being able to find "$DB2_HOME/sqllib/lib/libdb2.a", even though I have set $DB2_HOME as per suggested by the "CAVEATS" file that comes bundled with the module: "This usually means that you are not in a properly configured DB2 client shell. A typical case would be that you installed DB2 to /home/inst1/sqllib and now you are using root to install DBD::DB2. The root id does not have the DB2 Client configured. The fix for this scenario is as follows: export DB2_HOME=/home/inst1/sqllib perl Makefile.PL (This will create the proper INC)" 2. The "make install" invocation completes without error. 3. When I invoke the perl DBI module which obviously invokes the DBD::DB2 module I receive a similar run-time error: "Can't load '/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi/auto/DBD/DB2/DB2.so' for module DBD::DB2: 0509-022 Cannot load module /db2home/db2fald1/sqllib/lib/libdb2.a(shr.o). 0509-150 Dependent module /db2home/db2fald1/sqllib/lib/libdb2osse.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive 0509-022 Cannot load module /usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi/auto/DBD/DB2/DB2.so. 0509-150 Dependent module /db2home/db2fald1/sqllib/lib/libdb2.a(shr.o) could not be loaded. at /usr/opt/perl5/lib/5.8.2/aix-thread-multi/DynaLoader.pm line 229." I know that the CCFLAGS are set to include the "$DB2_HOME/sqllib/lib" directory and that the file "libdb2.a(shr.o)" is located there. Any ideas as to what I might be missing in terms of environmental set-up needed for running a proper "make" invocation, would be highly appreciated. Cheers grassman
Write a response