User Cancels the job

PANDU1 · New User Joined: 16 Nov 2016 Posts: 7 Location: india

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

GuyC · Posted: Mon Mar 13, 2017 4:34 pm

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.