MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

CICS rollback - would like to confirm

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> CICS and Middleware
View previous topic :: View next topic  
Author Message
deepa12
Beginner


Joined: 05 Apr 2005
Posts: 131
Topics: 64
Location: chennai

PostPosted: Tue Oct 28, 2014 3:53 am    Post subject: CICS rollback - would like to confirm Reply with quote

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
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12357
Topics: 75
Location: San Jose

PostPosted: Tue Oct 28, 2014 10:25 am    Post subject: Re: cics rollback - would like to confirm Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
deepa12
Beginner


Joined: 05 Apr 2005
Posts: 131
Topics: 64
Location: chennai

PostPosted: Tue Oct 28, 2014 8:51 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12357
Topics: 75
Location: San Jose

PostPosted: Wed Oct 29, 2014 11:33 am    Post subject: Reply with quote

deepa12 wrote:
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


Deepa12,

You need to understand the importance of SHROPTIONS coded when creating the VSAM cluster.

Scroll Down to read about SHROPTIONS

After you are done reading that then please read

1.Differences between VSAM RLS access and non-RLS access

2.Locking (enqueuing on) resources in application programs
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
deepa12
Beginner


Joined: 05 Apr 2005
Posts: 131
Topics: 64
Location: chennai

PostPosted: Wed Oct 29, 2014 11:25 pm    Post subject: Reply with quote

Ok. Thanks
_________________
deepa
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> CICS and Middleware All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group