Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 error : Abnormal Termination of Cobol+DB2 programs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
job1919

New User


Joined: 19 Jul 2010
Posts: 21
Location: Chennai

PostPosted: Mon Jul 19, 2010 4:53 pm    Post subject: DB2 error : Abnormal Termination of Cobol+DB2 programs
Reply with quote

HI ,

I am running a COBOL + DB2 Program , and the job abnormally terminates giving me this error " DSNE949E COMMIT PROCESSING ABNORMAL TERMINATION, REASON CODE X'00E70115' "

I have already recompiled the program , and the program only fetches from the table.

Thanks
job1919
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Mon Jul 19, 2010 5:11 pm    Post subject:
Reply with quote

00E70115
Explanation: The unit of work was placed in a state where a rollback operation is required. This can happen when an abend occurs during the execution of a stored procedure, a user defined function (UDF), or a restricted SQL operation was issued from a stored procedure.
Back to top
View user's profile Send private message
job1919

New User


Joined: 19 Jul 2010
Posts: 21
Location: Chennai

PostPosted: Mon Jul 19, 2010 5:37 pm    Post subject:
Reply with quote

If I understand corectly from your response, I will have recheck my query and also rebind it .

thanks CICS Guy.

job1919
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Mon Jul 19, 2010 5:53 pm    Post subject:
Reply with quote

Before rebinding, I'd look into why "The unit of work was placed in a state where a rollback operation is required"...
Back to top
View user's profile Send private message
job1919

New User


Joined: 19 Jul 2010
Posts: 21
Location: Chennai

PostPosted: Tue Jul 20, 2010 12:08 pm    Post subject:
Reply with quote

hmmm..

even I am wondering why a rollback was performed when I am only fetching .

Thanks
Job1919
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Jul 20, 2010 1:27 pm    Post subject:
Reply with quote

how many rows are fetched?

is the a Stored Procedure or just a cobol program?

what is the cursor declaration?
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help - DB2 Dynamic SQL Program e... NikhilGuptaGaya DB2 4 Sat Jun 23, 2018 1:58 pm
No new posts ERROR - NO ESD ENTRIES, EXECUTION IMP... Ashishpanpaliya COBOL Programming 6 Thu Jun 21, 2018 8:57 pm
This topic is locked: you cannot edit posts or make replies. Issue in suppressing leading zeros &a... Vijay_Sirisha COBOL Programming 21 Thu Jun 07, 2018 8:01 pm
No new posts VBS to VB in COBOL and JCL srajendran2 COBOL Programming 12 Fri Jun 01, 2018 3:04 am
This topic is locked: you cannot edit posts or make replies. Rexx code to find greater then symobl... Bharath Vikraman CLIST & REXX 8 Tue May 29, 2018 9:40 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us