Perl DBD::DB2 Connection Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lucybridges@gmail.com - 30 May 2007 09:38 GMT

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.

Reply to this Message

Darin McBride - 31 May 2007 02:25 GMT

> 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).

Reply to this Message