View previous topic :: View next topic
|
Author |
Message |
Sajitha S
New User
Joined: 10 May 2010 Posts: 2 Location: India
|
|
|
|
I have a SQL query to update 2 rows of the table
Sample Data:
[size=9] SECURE RUNDATE INVIND VIN CONTROL
CHAR(1) DATE CHAR(1) CHAR(11) CHAR(8)
---------- ----------- ---------- ----------- -----------
****** **************************** TOP OF DATA *********************
000001 1 2009-10-22 1 GAJG9C00165 36428996
000002 1 2009-10-22 1 GAJG9C00165 36428996
****** ************************** BOTTOM OF DATA ********************[/size]
ACTIVE INACTIVE
DATE DATE
---------- ------------
**************************
2009-10-21 2010-01-01
2010-01-01 ----------
**************************
REMIND_KZ REMIND_DATE
CHAR(1) DATE
------------- ---------------
********************* TOP OF DA
----------
----------
******************* BOTTOM OF D
SQL:
EXEC SQL
UPDATE STATUS
SET REMIND_KZ = :XTESTUFE
,REMIND_DATE = CURRENT DATE
WHERE CONTROL = :CONTROL
AND VIN = :VIN
END-EXEC
When I execute the above query getting an -911 abend with code as "40001 00C9008E".
When I tried to find the reason for Error code "40001 00C9008E" it was as follows given in the attachment. Can you please provide me a sloution to resolve this error. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Can you please refrain from postint attachments as not everybody can open, or chooses to open them. This reduces the number of available help sources and may increase the time delay before getting help.
The error messages denote a timeout, so it might be best if you talk to your DBA's and see if they can help you. |
|
Back to top |
|
|
Sajitha S
New User
Joined: 10 May 2010 Posts: 2 Location: India
|
|
|
|
Hi,
Thanks for your suggestion I attached the document to show the reason for abend. I know that it is a time out. If possible provide a solution |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Quote: |
so it might be best if you talk to your DBA's and see if they can help you |
Your problem is on your system. You need to work with your database support people to identify what is holding the resource(s) that caused the timeout.
The solution is to make sure things are not held so long. Usually this is caused by a poorly designed/coded implementation. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Sajitha S wrote: |
I attached the document to show the reason for abend |
No, the attached document provides a description of a generic -911 rc ....
within the sqlca message:
THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON reason code, TYPE OF RESOURCE resource type, AND RESOURCE NAME resource name
resource type
and
resource name
describes the objects in your system
and since you are unable to relate the resource in your system
is why you need to talk to your dba's.
if you had enough knowledge of db2,
you could have told us what the resource was.
you can't, so we can't help you.
talk to your support people |
|
Back to top |
|
|
|