[users@httpd] DBI driver for DB/2 V9.5 fails to find/load libdb2.so.1

["Andrew T. Robinson" <at...@nmi.net>]

I am running Apache 2.2.3 (build date 2011-05-04) under CentOS 5.5 
(2.6.18-238.19.1.el5xen #1 SMP Fri Jul 15 08:16:59 EDT 2011 x86_64 
x86_64 x86_64 GNU/Linux).

The following problem began on Wednesday 2011-09-07.  There were no 
known system changes made prior to that date, other than an automatic 
YUM update on 2011-09-01.  The system did suffer a traumatic power cycle 
due to the most recent Hurricane in the northeast USA.  It is possible 
that changes from the YUM update took effect at that time.

[Fri Sep 09 11:05:26 2011] [error] [client 127.0.0.1] 
install_driver(DB2) failed: Can't load 
'/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/DB2/DB2.so' 
for module DBD::DB2: libdb2.so.1: cannot open shared object file: No 
such file or directory at 
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 
230., referer: https://localhost/staff/
[Fri Sep 09 11:05:26 2011] [error] [client 127.0.0.1]  at (eval 5) line 
3, referer: https://localhost/staff/
[Fri Sep 09 11:05:26 2011] [error] [client 127.0.0.1] Compilation failed 
in require at (eval 5) line 3., referer: https://localhost/staff/
[Fri Sep 09 11:05:26 2011] [error] [client 127.0.0.1] Perhaps a required 
shared library or dll isn't installed where expected, referer: 
https://localhost/staff/
[Fri Sep 09 11:05:26 2011] [error] [client 127.0.0.1]  at 
/usr/lib/perl5/site_perl/5.8.8/XXX/XXX.pm line 336, referer: 
https://localhost/staff/

Attempted corrective measures:
1.  Added IBM directories to /etc/ld.so.confd
2. Added a SetEnv directive LD_DIRECTORY_PATH to my httpd.conf file 
pointing to the specified library
3. Added an explicit set for LD_DIRECTORY_PATH in XXX.pm.

libdb2.so.1 exists in the specified directory and is world-readable:

175768009 20852 -r-xr-xr-x   1 bin      bin      21317242 Dec  3  2010 
/opt/ibm/db2/V9.5/lib64/libdb2.so.1
175767993    0 lrwxrwxrwx   1 root     root           11 Dec  3  2010 
/opt/ibm/db2/V9.5/lib64/libdb2.so -> libdb2.so.1

The same program that produced the message above will run on the Linux 
command line without error, but this problem is also occurring in other 
application environments such as sendmail.

There is no known IBM issue or Apache issue related to this problem that 
I have been able to locate.

Andy