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 IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm

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