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 

VSAM Massinsert Write & locking

 
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: Wed Feb 25, 2015 12:50 am    Post subject: VSAM Massinsert Write & locking Reply with quote

With respect to the following link:
http://www-01.ibm.com/support/knowledgecenter/SSGMCP_5.2.0/com.ibm.cics.ts.applicationprogramming.doc/topics/dfhp3a9.html

where
The empty range is locked to stop other requests simultaneously adding records into it. Moreover, the record defining the end of the empty range cannot be removed during the add operation. If another transaction issues a request to add records into the empty range or to delete the record at the end of the range, the delete lock makes the transaction wait until the WRITE or WRITE MASSINSERT command is complete. The record held with a delete lock can, however, be updated by another transaction during the write operation if it is in another CI.

With respect to this:
I was suggested to use mass insert option since there can be say 100000 records. This file is a recording mechanism for incoming & outgoing messages (mainframe to non mainframe) For some messages the key values i.e 56 are a combination of alpha numeric & numeric. For the message am taking about it is ending with numeric

There is SYNCPOINT after every 3500 records

I think CI range lock will also be against the index sets, sequence sets of the INDEX component.

I am not sure whether while the MASSINSERT transaction is running some other transaction could also try to acquire the same CI Please let me know how to find this. Also is it that based on the key values that the 2 transactions could contend for same CI

Kindly pardon me if am requesting information without enough investigation
_________________
deepa
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


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

PostPosted: Wed Feb 25, 2015 1:56 pm    Post subject: Reply with quote

deepa12

Are you opening the VSAM file in RLS mode or non-RLS mode? For MASSINSERT operations on a file opened in RLS access mode, CICS acquires a separate update lock at the time each individual WRITE command is issued.

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 Feb 25, 2015 11:32 pm    Post subject: Reply with quote

The file will be opened in NON RLS Mode
_________________
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