Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to manage VSAM file update conflict and corruption

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ocjohnh

New User


Joined: 19 Sep 2007
Posts: 3
Location: hong kong

PostPosted: Sat Jul 21, 2018 6:04 am    Post subject: How to manage VSAM file update conflict and corruption
Reply with quote

Hi, I am a rookie for VSAM.

We are going to built a self-developed VSAM KSDS file with a few AIX,
there are chances that records in the file are online-queried by in-house TSO users and updated by batch jobs at the same time.

The records for online query might be acquired by repro utility in TSO background and then they are plugged into an ISPF table for online display. On the other hands update batch jobs could be COBOL, EASYTRIEVE OR simply a IDCAMS REPRO (yet to be confirmed).

In this situation I wonder if share-option is the best way to manage access conflict between users and batch jobs. Also should every batch job need to make a copy of the VSAM file by repro before update?
that seems a little bit clumsy for recovery. How often would a VSAM file get corrupt !?

Am I getting anything wrong !? hope for helps
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8378
Location: Dubuque, Iowa, USA

PostPosted: Sat Jul 21, 2018 7:29 am    Post subject: Reply to: How to manage VSAM file update conflict and corruption
Reply with quote

Quote:
I wonder if share-option is the best way to manage access conflict between users and batch jobs.
Actually, the shareoption setting is the ONLY way to manage access conflict -- you set the shareoption values depending upon what you are trying to do. And, depending upon the selected values, you may have to implement ENQUEUE / DEQUEUE logic in each program using the VSAM data set.
Quote:
How often would a VSAM file get corrupt !?
Depending upon the way it is defined, and how it is accessed as well as the enqueue / dequeue facility used, the answer to this question could be never, or once in a while, or once a year, or once a month, or once a week, or once a day, or once an hour, or pretty much every time it is accessed.

And it is a data set, not a file -- z/OS has files on tape or in Unix System Services only; every disk data set (and VSAM is on disk) is a data set not a file.

If you have not downloaded / read the Redbook VSAM Demystified you need to do so -- NOW! It should be required reading for every VSAM rookie.
Back to top
View user's profile Send private message
ocjohnh

New User


Joined: 19 Sep 2007
Posts: 3
Location: hong kong

PostPosted: Sat Jul 21, 2018 4:34 pm    Post subject:
Reply with quote

thx for the help.. icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join 2 File using a Join Key scorp_rahul23 DFSORT/ICETOOL 6 Tue Aug 14, 2018 7:36 am
No new posts JCL to send email along with formated... wik123 JCL & VSAM 5 Thu Aug 09, 2018 9:48 am
No new posts How can we create a flat file in JAVA... jasorn Java & MQSeries 2 Wed Aug 08, 2018 3:08 pm
No new posts Need Help on sending email by includi... wik123 JCL & VSAM 9 Mon Jul 30, 2018 2:59 pm
No new posts finding anydata between positions of ... ram_vizag SYNCSORT 13 Tue Jul 17, 2018 9:14 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us