View previous topic :: View next topic
|
Author |
Message |
kartik krishna
New User
Joined: 03 May 2008 Posts: 2 Location: hyd
|
|
|
|
hello,
i am having a problem with accessing a VSAM file. I have a VSAM KSDS . i am using this file in my batch prog.The same file is used by 1 more person in a CICS online program.Now the problem is once the person access the vsam file using the browse command in his cics program, I cannot open the file.It gives an error msg that file is already in use.Though the person has performed end browse,ended his transaction and logged out of cics region i am not able to open it through ditto ( vsam browse) or cannot run my batch prog.
Can anybody give me a solution for this problem. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
NO
- not that we do not know how, but we do not know anything about Your standards
sharing VSAM datasets is heavily installation dependent,
ask Your support
- I am adamant to give suggestions without knowing the environment an the standards |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Do you have SMStvs installed - an IBM pay for product that allows CICS & batch to share VSAM files. |
|
Back to top |
|
|
kartik krishna
New User
Joined: 03 May 2008 Posts: 2 Location: hyd
|
|
|
|
hi ,
i have got a simple solution for the prob.Actually i was only reading from the file in both batch and online prog.One of a senior member advised me to define the VSAM cluster with shareoption(2,3).And it worked for me.
The description given by him is as follows
Use SHAREOPTIONS(2 3) while defining the VSAM Cluster using IDCAMS.
Note: The share option "2,3" is very similar to the "1,3" option, but it does not provide read integrity. In other words, it is possible for a read user to access the same control interval that another user is updating, thus losing read integrity. There is no problem in updating with this option because VSAM ensures that only one user has a control interval for update. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
but it does not provide read integrity |
This may also be known as a "dirty read". One problem with a dirty read is that a process can retrieve values that will not "balance" because at the time of the read, only part of a multi-record update has been done.
Can your process can tolerate some out-of-balance condition?
Successful execution may not mean valid data. . . |
|
Back to top |
|
|
|