I'm attempting to connect to a DB2 database using DBD::DB2 running on
a Linux device. I'm getting the following error:
** connect: Unable to get database handle: DBI
connect('p88fla q','ip88flaq',. ..) failed: [IBM][CLI Driver] SQL1042C
An unexpected system error occurred. SQLSTATE=58004
at /usr/lib/perl5/site_perl/5.8.5/Oasis2/DBConn.pm line 2155
I've installed the DB2 client for the user in question:
../db2icrt -a SERVER_ENCRYPT -s client -w32 orbit
The user CAN connect using the db2 command line interface.
I know (think!) that I need to install the 'Developers Toolkit' but I
can't find any reference as to how to install this.
I have another account on the same device that CAN connect usiing
DBD::DB2 but I can't remember what I did to get this user working.
The DB2 DBA that we had up and quit and didn't leave behind many
notes :-(
Any help would be appreciated!
3  2706 
on the two accounts, type the following commands and see if they are
pointing to two different installations of db2:
db2level
also check if the perl and db2 dbi module are installed on the system
as a whole or is custom for the user which is capable of running it.
regards,
dotyet
On Aug 9, 3:54 pm, roxrox_1...@yah oo.com wrote:
I'm attempting to connect to a DB2 database using DBD::DB2 running on
a Linux device. I'm getting the following error:
** connect: Unable to get database handle: DBI
connect('p88fla q','ip88flaq',. ..) failed: [IBM][CLI Driver] SQL1042C
An unexpected system error occurred. SQLSTATE=58004
at /usr/lib/perl5/site_perl/5.8.5/Oasis2/DBConn.pm line 2155
I've installed the DB2 client for the user in question:
./db2icrt -a SERVER_ENCRYPT -s client -w32 orbit
The user CAN connect using the db2 command line interface.
I know (think!) that I need to install the 'Developers Toolkit' but I
can't find any reference as to how to install this.
I have another account on the same device that CAN connect usiing
DBD::DB2 but I can't remember what I did to get this user working.
The DB2 DBA that we had up and quit and didn't leave behind many
notes :-(
Any help would be appreciated!
On Aug 9, 5:12 pm, dotyet <dot...@yahoo.c omwrote:
on the two accounts, type the following commands and see if they are
pointing to two different installations of db2:
db2level
also check if the perl and db2 dbi module are installed on the system
as a whole or is custom for the user which is capable of running it.
regards,
dotyet
On Aug 9, 3:54 pm, roxrox_1...@yah oo.com wrote:
I'm attempting to connect to a DB2 database using DBD::DB2 running on
a Linux device. I'm getting the following error:
** connect: Unable to get database handle: DBI
connect('p88fla q','ip88flaq',. ..) failed: [IBM][CLI Driver] SQL1042C
An unexpected system error occurred. SQLSTATE=58004
at /usr/lib/perl5/site_perl/5.8.5/Oasis2/DBConn.pm line 2155
I've installed the DB2 client for the user in question:
./db2icrt -a SERVER_ENCRYPT -s client -w32 orbit
The user CAN connect using the db2 command line interface.
I know (think!) that I need to install the 'Developers Toolkit' but I
can't find any reference as to how to install this.
I have another account on the same device that CAN connect usiing
DBD::DB2 but I can't remember what I did to get this user working.
The DB2 DBA that we had up and quit and didn't leave behind many
notes :-(
Any help would be appreciated!
Thanks,
The perl is installed so that everyone has access.
The db2level shows that the user that 'works' has 64 bit vs 32 bit for
the user that doesn't 'work'. I'll see if I can fix that.
[root@mdsxocd1 ~]# su - orbit
[orbit@mdsxocd1 ~]$ db2level
DB21085I Instance "orbit" uses "64" bits and DB2 code release
"SQL08026" with
level identifier "03070106".
Informational tokens are "DB2 v8.1.3.120", "s060801", "MI00167", and
FixPak
"13".
Product is installed at "/opt/IBM/db2/V8.1".
[orbit@mdsxocd1 ~]$
[root@mdsxocd1 ~]# su - appit
[appit@mdsxocd1 ~]$ db2level
DB21085I Instance "appit" uses "32" bits and DB2 code release
"SQL08026" with
level identifier "03070106".
Informational tokens are "DB2 v8.1.3.120", "s060801", "MI00167", and
FixPak
"13".
Product is installed at "/opt/IBM/db2/V8.1".
[appit@mdsxocd1 ~]$
On Aug 10, 9:14 am, roxrox_1...@yah oo.com wrote:
On Aug 9, 5:12 pm, dotyet <dot...@yahoo.c omwrote:
on the two accounts, type the following commands and see if they are
pointing to two different installations of db2:
db2level
also check if the perl and db2 dbi module are installed on the system
as a whole or is custom for the user which is capable of running it.
regards,
dotyet
On Aug 9, 3:54 pm, roxrox_1...@yah oo.com wrote:
I'm attempting to connect to a DB2 database using DBD::DB2 running on
a Linux device. I'm getting the following error:
** connect: Unable to get database handle: DBI
connect('p88fla q','ip88flaq',. ..) failed: [IBM][CLI Driver] SQL1042C
An unexpected system error occurred. SQLSTATE=58004
at /usr/lib/perl5/site_perl/5.8.5/Oasis2/DBConn.pm line 2155
I've installed the DB2 client for the user in question:
./db2icrt -a SERVER_ENCRYPT -s client -w32 orbit
The user CAN connect using the db2 command line interface.
I know (think!) that I need to install the 'Developers Toolkit' but I
can't find any reference as to how to install this.
I have another account on the same device that CAN connect usiing
DBD::DB2 but I can't remember what I did to get this user working.
The DB2 DBA that we had up and quit and didn't leave behind many
notes :-(
Any help would be appreciated!
Thanks,
The perl is installed so that everyone has access.
The db2level shows that the user that 'works' has 64 bit vs 32 bit for
the user that doesn't 'work'. I'll see if I can fix that.
[root@mdsxocd1 ~]# su - orbit
[orbit@mdsxocd1 ~]$ db2level
DB21085I Instance "orbit" uses "64" bits and DB2 code release
"SQL08026" with
level identifier "03070106".
Informational tokens are "DB2 v8.1.3.120", "s060801", "MI00167", and
FixPak
"13".
Product is installed at "/opt/IBM/db2/V8.1".
[orbit@mdsxocd1 ~]$
[root@mdsxocd1 ~]# su - appit
[appit@mdsxocd1 ~]$ db2level
DB21085I Instance "appit" uses "32" bits and DB2 code release
"SQL08026" with
level identifier "03070106".
Informational tokens are "DB2 v8.1.3.120", "s060801", "MI00167", and
FixPak
"13".
Product is installed at "/opt/IBM/db2/V8.1".
[appit@mdsxocd1 ~]$
BINGO!
I reinstalled the client with the following command:
../opt/IBM/db2/V8.1/instance/db2icrt -a SERVER_ENCRYPT -s client -w 64
appit
After I registered the database I could connect.
Many thanks!!! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Philip Nelson |
last post by:
Noticed today that there have been two new versions of the DB2 driver
released over the last week.   This is the first time IBM has released an
update since October 2001, so to give us two releases in a week is a bit
much to cope with <G> !!!
0.77 fixes a number of problems, including one which I reported to IBM (and
helped to...
|
by: Larry |
last post by:
I'm having problems getting any CLI trace info from my Perl script
(which uses DBI and DBD::DB2). I did:
db2 update cli cfg for section common using trace 1
db2 update cli cfg for section common using traceflush 1
db2 update cli cfg for section common using tracecomm 1
db2 update cli cfg for section common using \
tracefilename...
|
by: bastb |
last post by:
Hi,
We've been using the perl DBD::DB2 driver on Perl version 5.8.0
(aix_thread_multi) for a project we're working on without any problems
until now.
We've been using DBD::DB2 version 0.78 on DB2 Version 8.1 (the db2 cli
reports 8.1.0) and we've recently updated DB2 using FixPack 7. The
project we're working on uses the DB2 driver for...
|
by: Larry |
last post by:
I have a Perl script using DBD::DB2, that runs during system startup on
a Solaris system. The script is working fine during startup on many
machines, except on one machine it fails complaining about a missing
".so" file, with Perl flagging the "use DBD::DB2" line. (I don't have
the exact message since I'm heard about it from a remote...
|
by: Tomas |
last post by:
Hey all,
I'm trying to parse the output from the get_dbsize_info procedure with
a Perl script, using the DBI and the DB2 DBD. Below is the relevant
part of the code:
my $dbsql = "call get_dbsize_info(?,?,?,?)";
my $dbsqlh = $dbh->prepare($dbsql);
$dbsqlh->bind_param_inout(1,\$snapshottimestamp,20,{db2_param_type=>SQL_PARAM_OUTPUT});...
| | |
by: Evie |
last post by:
I'm attempting to connect to a DB2 database using perl DBD::DB2. I'm
consistently getting the following error:
SQL1042C An unexpected system error occurred.
SQLSTATE=58004
What I have done:
Installed the DB2 client, registered the database and verified
connectivity using the db2 command line utility.
|
by: lucybridges |
last post by:
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:
SQL1042C An unexpected system error occurred. SQLSTATE=58004
The Perl code in question is:
my( $dbh ) =...
|
by: bijoej |
last post by:
Can anybody tell me about the following error:
"String Not Found"
I'm new to Perl so please help me out...
Thanks in Advance...
Regards
Bij
|
by: rajpar |
last post by:
Environment: Solaris (client + server)
db2 version 7.2 latest fixpak (DB2 v7.1.0.111", "s050516" and
"U803330")
Compiler: gcc
Here is my SP code executed on the client:
CREATE PROCEDURE db2user.x (IN value INT)
LANGUAGE SQL
BEGIN
INSERT INTO db2dba.t1 values (value);
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
