473,396 Members | 2,129 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,396 software developers and data experts.

An SQL error "-911" occurred during processing

DB2 7.2. I do an export each night of important tables.
Nothing else should be touching the DB at this time.
About every 2 days I get the error below on the same tables
most of the time.
What could be causing this??????

SQL3104N The Export utility is beginning to export data to file
"/db2/data/crprod/exports/TBL_PREMINDERS_CA.ixf".

SQL3015N An SQL error "-911" occurred during processing.

SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "2". SQLSTATE=40001

SQL3105N The Export utility has finished exporting "9202778" rows.

Thanks

Oct 5 '06 #1
1 22266
Reason Code 02 is a DEAD LOCK.
Reason Code 68 is a LOCK TIME OUT.

So clearly there is a contention for your EXPORT with another process
on that table.
Schedule a DB2 EVENT MONITOR to find the SQL(applications) which are
involved in this DEAD LOCK.
Cheers...
Shashi Mannepalli
Willard Farwark wrote:
DB2 7.2. I do an export each night of important tables.
Nothing else should be touching the DB at this time.
About every 2 days I get the error below on the same tables
most of the time.
What could be causing this??????

SQL3104N The Export utility is beginning to export data to file
"/db2/data/crprod/exports/TBL_PREMINDERS_CA.ixf".

SQL3015N An SQL error "-911" occurred during processing.

SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "2". SQLSTATE=40001

SQL3105N The Export utility has finished exporting "9202778" rows.

Thanks
Oct 5 '06 #2

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

Similar topics

1
by: Oliver Stratmann | last post by:
Hello All, could anyone give me a clou about the above reason code? (Database Version 7.2 UDB on a Windows 2000 Machine) This is what i did: <Begin-Quote> db2 => insert into e_deka_einzel...
9
by: Mairhtin O'Feannag | last post by:
Hello, We have two machines we wish to use DPF. They are both RH ES 2.1, with DB2 8.2. I read the documentation CAREFULLY, and added the following line to my db2nodes.cfg file : 1 egret 0
5
by: Kivak Wolf | last post by:
Hey everyone, I have a textbox in my web page that is going to be used to enter an E-mail into (just plain text, no HTML). Now, this will interact with a SQL database where the contents of the...
2
by: P. Adhia | last post by:
Hello All, I am trying to redirect-restore a backup of a DB2 V6.x system (AIX 4.x) on DB2 V8.2 system (AIX 5.2). I get the above error with no other details. db2diag.log has a series of error...
0
by: smkkaleem | last post by:
I am stuck with the error I have posted above in the question title I am developing ASP.NET 2.0 web site and I have added a new rdlc file to my project by using the following process: -Right...
6
by: Jurgen Haan | last post by:
Hi hi, I'm trying to perform a redirected restore, but I get a nice error returned. Does anyone have an idea of what the -5130 errorcode means? db2inst@ELMO:~> db2 restore db efproddb into...
0
by: AnalogKid17 | last post by:
<full error> An error has occurred during report processing. Exception has been thrown by the target of an invocation. Login failed for user '\$'. </full error> I have a web based winforms app...
0
by: geeteshss | last post by:
i am pasting the code in which i am finding the error this is happening when i click on the update button of the datagrid which is fired when i click the edit button public void BindData()...
1
by: reeferz | last post by:
hi all, i created the most basic webservice the one that vs 2005 creates for u with the hello world method, and decided to post it onto my website.... however i keep getting this error : ...
6
by: jfitz261 | last post by:
We are moving from 7.2 to 9.x. So I'm trying to restore a 7.2 backup to a 8.1 and I'm getting a sqlcode 2038N with system error of 1062. We have to got 8.x then move 9.x. Here is the command...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
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.