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



Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message

New User

Joined: 18 Jan 2010
Posts: 3
Location: India

PostPosted: Sun Jan 24, 2010 10:55 pm    Post subject: IMS Transaction COMMIT/ROLLBACK
Reply with quote

Hi All,

I am working on an application. The application gets the Database update request through distributed online applications through the IMS Transactions.

This requests are processed through COBOL applications and updates the DB2 tables. The requests are dealt by a single COBOL routine(Say program A, COBOL DB2), as part of my requirement i am supposed to trigger a subroutine B(COBOL DB2). If any update through program A goes wrong then i am supposed to trigger subroutine B to create an Audit Trail.

Problem: If there is any issue in subroutine A then the whole transaction is rolled back. In that case the subroutine B updates will also be rolled back as that is triggered through A. In subroutine B i am updating only 1 DB2 table. Is there anyway i can sustain my updates(Subroutine B) only for that particular table.

Due to specific requirements i cant put any explicit COMMIT/ROLLBACK in either program A or subroutine B.

Any pointers??
Back to top
View user's profile Send private message

dick scherrer

Site Director

Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jan 25, 2010 1:04 am    Post subject:
Reply with quote


There is no provision to "keep some" / "throw away some" in the commit/rollback environment. The entire design depends on an entire "unit of work".

If you are not permitted to issue the proper commit/rollback to discard the problem yet keep the audit, you will have to do the audit in some other way. IMHO, not a good idea. . .
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member

Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Feb 03, 2010 4:37 pm    Post subject:
Reply with quote

May be you can "unload" the DB2 table to a QSAM and update the file instead of DB2-table when needed, and update the file without any check-point logic in program...but it's a nasty way of doing things.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1


Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts How to calculate an specific transact... lind sh CICS 2 Tue Sep 13, 2016 9:20 pm
No new posts Start a CDBM transaction whit appropr... lind sh CICS 2 Sun Apr 10, 2016 1:46 pm
No new posts Transaction Profile amitc23 CICS 1 Thu Feb 04, 2016 3:10 pm
No new posts Commit limit for Delete query through... mf_karthik DB2 10 Thu Dec 17, 2015 12:56 am

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