IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

User Cancels the job


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
PANDU1

New User


Joined: 16 Nov 2016
Posts: 7
Location: india

PostPosted: Sat Mar 04, 2017 8:21 pm
Reply with quote

HI All,

I have a small question from db2 cursor.

If a cursor updates 5K records when a condition satisfied and commit is not-used yet till 4K record.

If the user cancels the job from spool, will all updates(till 4K) be reflected in the table? or will get roll back?

Thanks in advance.
Pandu
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Mon Mar 13, 2017 4:34 pm
Reply with quote

updates are in the table, but all updated rows will be locked until a commit is issued. a cancel before the commit will roll back all those changes (that's why a cancel can take some time ).

If you dare to read with UR you might see the updated values.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Revoke on DB2 to remove an user DB2 4
This topic is locked: you cannot edit posts or make replies. Is there a way to restrict user login... All Other Mainframe Topics 11
No new posts DITTO/ESA R3 User's Guide and Referen... IBM Tools 2
No new posts conversational program not reading t... IMS DB/DC 2
No new posts User question - dbzTHEdinosaur General Talk & Fun Stuff 2
Search our Forums:

Back to Top