View previous topic :: View next topic |
Author |
Message |
deepa12 Beginner
Joined: 05 Apr 2005 Posts: 131 Topics: 64 Location: chennai
|
Posted: Tue Oct 28, 2014 3:53 am Post subject: CICS rollback - would like to confirm |
|
|
Pls consider the following scenario:
A VSAM File has field 1: fld1 VALUE 10
Transaction 1 sees 10 in fld1, increments and updates to 11
in the meanwhile transaction 2 sees value 11 in fld1, increments & updates the same to 12
Now transaction 1 rollsback . Now i think the fld1 in FILE will have 10
And any transaction which acceses this field after the rollback will read the value of this field as 10 & not 11
Pls confirm _________________ deepa |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12359 Topics: 75 Location: San Jose
|
Posted: Tue Oct 28, 2014 10:25 am Post subject: Re: cics rollback - would like to confirm |
|
|
deepa12 wrote: | Pls consider the following scenario:
A VSAM File has field 1: fld1 VALUE 10
Transaction 1 sees 10 in fld1, increments and updates to 11
in the meanwhile transaction 2 sees value 11 in fld1, increments & updates the same to 12
Now transaction 1 rollsback . Now i think the fld1 in FILE will have 10
And any transaction which acceses this field after the rollback will read the value of this field as 10 & not 11
Pls confirm |
Deepa,
1. How does transaction 2 see a value of 11 without a syncpoint? without a syncpoint , transaction 2 would only see 10.
2. Aren't you having a row-level lock for the update? _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
deepa12 Beginner
Joined: 05 Apr 2005 Posts: 131 Topics: 64 Location: chennai
|
Posted: Tue Oct 28, 2014 8:51 pm Post subject: |
|
|
The file is non rls. In this environment i had seen some progams using syncpoint and some not using the syncpoint.
What i understand is:
In non rls its a ci size lock. The exclusive lock(ie read update access) is available for other transactions only after SYNCPOINT from transaction 1.
In the meanwhile that the lock is not released, the changed data is available for other transactions in read mode ( i have checked this in intertest also; i.e shared read access)
Pls confirm my understanding _________________ deepa |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12359 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
deepa12 Beginner
Joined: 05 Apr 2005 Posts: 131 Topics: 64 Location: chennai
|
Posted: Wed Oct 29, 2014 11:25 pm Post subject: |
|
|
Ok. Thanks _________________ deepa |
|
Back to top |
|
|
|
|