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
 

 

User Cancels the job

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: User Cancels the job
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: 1280
Location: Belgium

PostPosted: Mon Mar 13, 2017 4:34 pm    Post subject:
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    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 region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts SORT - E15 and E35 using same user ex... Abhi Nature DFSORT/ICETOOL 12 Mon Oct 03, 2016 4:33 pm
No new posts User exit in COBOL programs ganasrinivasan PL/I & Assembler 0 Thu Aug 18, 2016 12:48 pm
No new posts Data set is allocated to another job ... Seppe CLIST & REXX 2 Wed Aug 03, 2016 4:31 pm
No new posts user abend 4038 occurred in module CE... Musab Ahmed PL/I & Assembler 1 Wed Mar 30, 2016 10:49 am


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