Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 A sample of exit program for exit XMN... lind sh CICS 2 Mon Oct 03, 2016 5:07 pm
No new posts Need points to tune IMS Checkpoint Pr... satish.ms10 IMS DB/DC 2 Fri Sep 30, 2016 4:12 pm
No new posts ISPF program to set SCRNAME prino TSO/ISPF 5 Fri Sep 30, 2016 2:18 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
This topic is locked: you cannot edit posts or make replies. How to supply called sub-program from... dchristensen JCL & VSAM 25 Wed Sep 14, 2016 11:36 pm

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