Issue with DBD:DB2 on Unix environment.

Issue with DBD:DB2 on Unix environment.

am 28.09.2005 17:57:04 von Teresa

Hi,=20

We have installed DBI and DBD:DB2 on our OS/390 Unix environment.=20
When we try to connect to one of our datasources, we get an error that we a=
re not sure what it means.

It seems that its failing when we try to connect. Does anyone have any ide=
as as to what we could be doing wrong.

By the way, we installed the Windows version of Perl from ActiveState, call=
ed ActivePerl and then downloaded the DBI and DBD:DB2 and the connect strin=
g worked. So, we are thinking that there is something wrong on our Unix sy=
stem.

We get the following error:

Name "main::pass" used only once: possible typo at dbi_try.pl line 7.
Name "main::cbh" used only once: possible typo at dbi_try.pl line 16.
DBI 1.48-nothread default trace level set to 0x0/2 (pid 90624)
-> DBI->connect(dbi:DB2:DBP2@NCDAB2B:3700, VRUWEBAP, ****)
-> DBI->install_driver(DB2) for aix perl=3D5.008007 pid=3D90624 ruid=
=3D269 euid=3D269
install_driver: DBD::DB2 version 0.78 loaded from /usr/local/lib/p=
erl5/site_perl/5.8.7/aix/DBD/DB2.pm
connect for DBD::DB2::dr (DBI::dr=3DHASH(0x30149628)~0x30328e2c 'DBP=
2@NCDAB2B:3700' 'VRUWEBAP' **** HASH(0x30329168))
connect 'DBP2@NCDAB2B:3700', 'VRUWEBAP', **** Connect failed error -1 rec=
orded: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=3DHY009
-> DESTROY for DBD::DB2::db (DBI::db=3DHASH(0x30329198)~INNER)
DESTROY for DBI::db=3DHASH(0x30329198) ignored - handle not init=
ialised
ERROR: -99999 '[IBM][CLI Driver] CLI0124E Invalid argument value.=
SQLSTATE=3DHY009' (err#0)
$DBI::errstr (&) FETCH from lasth=3DHASH
>> DBD::DB2::dr::errstr
$DBI::errstr (&) FETCH from lasth=3DHASH
>> DBD::DB2::dr::errstr
disconnect_all for DBD::DB2::dr (DBI::dr=3DHASH(0x30149628)~0x30328e=
2c)
DESTROY in DBD::_::common for DBD::DB2::dr (DBI::dr=3DHASH(0x30328e2=
c)~INNER)
! =20