By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,742 Members | 773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,742 IT Pros & Developers. It's quick & easy.

Perl DBD::DB2 Connection Error

P: n/a
Can anyone shed some light on what is causing this, please?

Using Perl 5.8.5 (64 bit) on RH enterprise Linux AS release 4
(2.6.9-22.ELsmp) I'm receiving the following error:
DBI connect('psygrid','db2inst1',...) failed: [IBM][CLI Driver]
SQL1042C An unexpected system error occurred. SQLSTATE=58004

The Perl code in question is:
my( $dbh ) = DBI->connect( "DBI:DB2:$options{database}",
$options{username}, $options{password} );

This definately works on different server (same OS).

The db2diag.log shows the following message:

007-05-22-16.31.03.051711+060 I19813486E454 LEVEL: Error
PID : 17611 TID : 182894183488
FUNCTION: DB2 Common, Cryptography, cryptContextRealInit, probe:40
MESSAGE : ECF=0x90000403 Unexpected cryptographic error
DATA #1 : Hex, 4 bytes
0x0
DATA #2 : Hex, 4 bytes
0x0
DATA #3 : Hex, 4 bytes
0x0
DATA #4 : String, 108 bytes
/home/db2inst1/sqllib/lib/icc/icclib/libicclib.so: cannot open shared
object file: No such file or directory

^^The file libicclib.so exists and has read permissions.

May 30 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
lu*********@gmail.com wrote:
Can anyone shed some light on what is causing this, please?
[...]
/home/db2inst1/sqllib/lib/icc/icclib/libicclib.so: cannot open shared
object file: No such file or directory

^^The file libicclib.so exists and has read permissions.
You should also make sure that whatever user you're running your perl code
under (e.g., apache or whatever) has access to the .so file, including its
directory, and every directory above it. For
example, /home, /home/db2inst1, /home/db2inst1/sqllib, DB2DIR (all parts of
it), DB2DIR/lib32, DB2DIR/lib32/icc, DB2DIR/lib32/icc, and
DB2DIR/lib32/icclib, where DB2DIR is wherever you've installed DB2 (if v9,
where you can [finally] choose the install location).
May 31 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.