473,399 Members | 3,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

SQL30020N Execution failed because of a Distributed Protocol Error

The Error in play is
CLI Driver][DB2/6000] SQL30020N Execution failed because of a
Distributed Protocol Error that will affect the successful execution of
subsequent commands and SQL statements: Reason Code "". SQLSTATE=58009
sqlstate = 40003

My Target is a DB2/UDB 8.2.2 database on SuSE Linux.

This has been happening regularly.

First is my hope that there is a quick fix to get over this problem.

Secondly, however, I'd like to understand how connection timeouts, lock
timeouts etc affect DB2 and what are the settings to tweak and play
around with to find the optimum for my environment.

The Client in this transaction is a INFORAMTICA Workflow making
Insert/Updates in Normal Mode.

The error is from the DB2 database.

Nov 12 '05 #1
1 6369
Ian
Zri Man wrote:
The Error in play is
CLI Driver][DB2/6000] SQL30020N Execution failed because of a
Distributed Protocol Error that will affect the successful execution of
subsequent commands and SQL statements: Reason Code "". SQLSTATE=58009
sqlstate = 40003


Are you seeing anything in the db2diag.log? What version/fixpack of the
DB2 client software are you running on the Informatica server?

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Richard Maher | last post by:
Hi, I am seeking the help of volunteers to test some software that I've developed which facilitates distributed two-phase commit transactions, encompassing any resource manager (e.g. SQL/Server...
3
by: xixi | last post by:
hi, we are using db2 udb v8.1 on win 64 bit with fp3 with type 4 db2jcc.jar driver. i have this problem happened sometimes when try to execute a query and failed. ...
0
by: Lyn Duong | last post by:
Hi we are writing an applicatiion which accesses a db2 for vm 7.2 database from a ado connection in a .asp script which runs on a IIS server. We receive the error SQLGetDiagRec(...
3
by: apngss | last post by:
When an application needs to get information from another machine over the network, how many distributed computing choices out there? Here are the choices in microsoft technology: ..NET is...
2
by: Bassel Tabbara | last post by:
I wrote the following code: oApp = new Outlook.Application(); oApp = new Outlook.Application(); oNameSpace= oApp.GetNamespace("MAPI"); oNameSpace.Logon(null,null,true,true); //gets defaultfolder...
0
by: silviu | last post by:
Hello I'm trying to install Microsoft SQL 2005 Server Express Edition but I'm getting the following error: SQL Server Setup unexpectedly failed... Then it says something about a log file. Here's...
7
by: Prashanth | last post by:
Hi, We are facing some issues in COM+ deployment. We get system error "Unable to enlist in a distributed transaction" . It has a very inconsistant behaviour. On refreshing the screens couple of...
5
by: Cirene | last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting...
2
Frinavale
by: Frinavale | last post by:
I thought it would be nice to share the solution to my IIS headache with the rest of the world. I have developed a web application that has been distributed. Upon installing my application, some...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
Oralloy
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,...
0
tracyyun
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...
0
agi2029
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,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.