Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Error code -911 SQLCA:SQLCA :40001 00C9008E

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
Sajitha S

New User


Joined: 10 May 2010
Posts: 2
Location: India

PostPosted: Mon May 17, 2010 7:51 pm    Post subject: Error code -911 SQLCA:SQLCA :40001 00C9008E
Reply with quote

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
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon May 17, 2010 7:56 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Sajitha S

New User


Joined: 10 May 2010
Posts: 2
Location: India

PostPosted: Mon May 17, 2010 8:04 pm    Post subject: Reply to: Error code -911 SQLCA:SQLCA :40001 00C9008E
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon May 17, 2010 9:51 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon May 17, 2010 10:11 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us