Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need Clarification On Rollback in Db2

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

New User


Joined: 29 May 2008
Posts: 15
Location: CHENNAI

PostPosted: Tue Jul 07, 2009 10:39 am    Post subject: Need Clarification On Rollback in Db2
Reply with quote

If a program opens a cursor and tried to fetch values, in the meantime it was deadlocked with some other transaction.
Now, the rollback process happens as a recovery of deadlock
after the roll back, what would be the status of the CURSOR whcih was opened earlier ?
Can anyone please clarify ..?
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: Tue Jul 07, 2009 7:24 pm    Post subject:
Reply with quote

Hello,

When a rollback occurs, all of the updates for that unit of work are "undone".

You would need to either have restart code that would re-sync and open a new cursor to continue or reload the data from the beginning of the run an restart from the beginning.

If you are experiencing a deadlock (rather than a timeout), it is probably a design error and correcting the code will eliminate the deadlock. If you are unable or unwilling to correct the design that permits the deadlock, you might avoid the deadlock by scheduling.
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 Need clarification of VSAM FCT and DF... pkmurali CICS 15 Sun Apr 10, 2016 1:06 am
No new posts Clarification regarding BUFNI & B... thirumalasetty JCL & VSAM 14 Tue Jun 17, 2014 8:22 pm
No new posts TWA variable having junk value after ... Gopalakrishnan V CICS 1 Tue May 13, 2014 7:59 pm
No new posts DB2 9 - Utilities - COPY,REORG Clarif... gylbharat DB2 3 Mon Oct 22, 2012 12:30 pm
No new posts Handle ROLLBACK in EXCI interface Pandora-Box CICS 12 Fri Sep 21, 2012 2:38 pm


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