DB2 error : Abnormal Termination of Cobol+DB2 programs

job1919 · New User Joined: 19 Jul 2010 Posts: 21 Location: Chennai

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

CICS Guy · Posted: Mon Jul 19, 2010 5:11 pm

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.

job1919 · New User Joined: 19 Jul 2010 Posts: 21 Location: Chennai

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

thanks CICS Guy.

job1919

CICS Guy · Posted: Mon Jul 19, 2010 5:53 pm

Before rebinding, I'd look into why "The unit of work was placed in a state where a rollback operation is required"...

job1919 · New User Joined: 19 Jul 2010 Posts: 21 Location: Chennai

hmmm..

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

Thanks
Job1919

dbzTHEdinosauer · Posted: Tue Jul 20, 2010 1:27 pm

how many rows are fetched?

is the a Stored Procedure or just a cobol program?

what is the cursor declaration?