Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
Rollback on Abended Program

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

New User

Joined: 25 Sep 2009
Posts: 9
Location: Bangalore

PostPosted: Fri Jan 28, 2011 10:43 pm    Post subject: Rollback on Abended Program
Reply with quote


When a job is abended (say after processing 100 records), does DB2 issues a rollback on its own so that all the 100 records are rollbacked?

On situations where both the database and log file (KSDS) are getting updated simultaneously, how to maintain the integrity between file and database?

Please let me know if the question doesn't make sense.

Many thanks for your valuable time.
Back to top
View user's profile Send private message


Active User

Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Tue Feb 01, 2011 5:17 am    Post subject:
Reply with quote

Default action for DB2 connections is to issue a commit if the application terminates normally, and a rollback if the termination is abnormal. And yes, that means that if you have done 100 inserts or updates, all rows are restored to the state they were in when the program started.

If you want to maintain integrity between files and (DB2-) databses in an environment, you have to execute your applications in a DB or DB/DC environment like IMS or CICS. IMS can execute batch programs in BMP or DBB mode.

DB/DC processing is also often called TP environments, transaction processing. Here, 1 transaction is normally defined as 1 logical unit of work, that can be committed or rolled back based on the termination of the transaction.
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 How to display offset thru cobol prog... tvinodkumar7 CICS 1 Sun Apr 22, 2018 8:42 pm
No new posts How do you attach a DB2 plan to a CIC... John Poulakos DB2 0 Wed Apr 18, 2018 1:49 am
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts Mantis Program Compiled? luis carlos CICS 2 Sat Apr 07, 2018 8:59 pm
No new posts Undefined Report Program socker_dad COBOL Programming 2 Fri Mar 30, 2018 1:45 am

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