IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Accessing VSAM file in CICS and Batch


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Tue Jul 24, 2012 8:54 pm
Reply with quote

Hi all,

Is there any other best way to access VSAM file from CICS ( Which just does a read ) and Batch process ( Updates the vsam file ) simultaneously apart from using RLS option which is not being an option in my shop??

Also this should be achieved without bothering CICS program execution.

Any suggestions or pointers will be really helpful indeed

Thanks
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Tue Jul 24, 2012 8:59 pm
Reply with quote

Are you expecting that the CICS region will be able to retrieve the updates made by the batch program?

There is a defined interface to allow batch programs access to CICS files (actually, there's even more than one such interface). You would do best by reading up on them.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Tue Jul 24, 2012 9:13 pm
Reply with quote

Quote:
Are you expecting that the CICS region will be able to retrieve the updates made by the batch program?


Doesnt RLS option in FCT support this??

I understand RLS is something like SHR (in JCL) which allows others to use the file so probably when it gets overwritten is it not possible to read updated data ?? Please correct my understanding icon_redface.gif

Since my shop doesnt support I coudnt try that out

Quote:
There is a defined interface to allow batch programs access to CICS files (actually, there's even more than one such interface). You would do best by reading up on them.


I am sorry I really dont know the name of the interface so only then I can read about them icon_sad.gif icon_sad.gif
Back to top
View user's profile Send private message
Peter cobolskolan

Active User


Joined: 06 Feb 2012
Posts: 104
Location: Sweden

PostPosted: Tue Jul 24, 2012 9:19 pm
Reply with quote

EXCI, EXternal Cics Interface, not to be mixed up with ECI, External Call Interface.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Tue Jul 24, 2012 9:43 pm
Reply with quote

Thanks Peter would try it and get back.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Tue Jul 24, 2012 9:44 pm
Reply with quote

Make up your mind what you want. This
Quote:
apart from using RLS option which is not being an option in my shop??
directly contradicts
Quote:
Doesnt RLS option in FCT support this??
If your site doesn't allow RLS, why do you keep bringing it up? If you're not using RLS, you need to be familiar with how CICS handles data going to and from a file -- for example, there's been more than one post on this forum where someone expected data written by CICS to be immediately available to a batch program and unless the application takes steps to ensure that CICS is flushing the buffers, the data won't necessarily be seen by batch programs for possibly many hours.

The CICS External Interfaces Guide manual is a good place to start reading on the EXCI interface.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Jul 24, 2012 10:06 pm
Reply with quote

Hi Robert,

I believe in this case, the CICS access will be only reads. If i understand the question (and i well may not), will the batch updates be visable to online reads?

Hope i've not provided any confusion/mis-direction.

The good news is that if i have, i can remove it icon_cool.gif

d
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Tue Jul 24, 2012 10:08 pm
Reply with quote

Hi Dick,

You got it right!!
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Jul 24, 2012 10:32 pm
Reply with quote

what you are asking for is a batch update to cause cics to refresh its buffers
(in the case the updated record is in a ci currently in a buffer)

i don't feel like spending the time to research in order to justify or refute the above.
i can only guess, so i will not.
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2501
Location: Atlanta, Georgia, USA

PostPosted: Tue Jul 24, 2012 10:33 pm
Reply with quote

SYSB II from H&W Computer Systems is a viable option -

www.hwcs.com/software/sysb-ii
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Tue Jul 24, 2012 10:39 pm
Reply with quote

That will depend upon whether or not the VSAM file is in an LSR pool. From the CICS Performance Guide in the VSAM Tuning section:
Quote:
Before issuing a read to disk when using LSR, VSAM first scans the buffers to check if the control interval it requires is already in storage. If so, it may not have to issue the read. This buffer "lookaside" can reduce I/O significantly.
So if you're using LSR, the batch update wouldn't necessarily be seen by CICS, although the manual is not clear about precisely what circumstances would cause a buffer read versus disk access. Either don't use LSR for the file (which may, in turn, cause other performance issues) or do some testing before implementing the situation you're talking about to see how it works in reality.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Wed Jul 25, 2012 12:09 am
Reply with quote

Looks like lot of reading need to be done ahead

Thanks all
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Wed Jul 25, 2012 11:21 am
Reply with quote

Hello,
Quote:
Is there any other best way to access VSAM file from CICS ( Which just does a read ) and Batch process ( Updates the vsam file ) simultaneously apart from using RLS

I think DFSMStvs - (transactional vsam services) allows VSAM sharing between CICS and Batch.
DFSMS Transactional VSAM Services (DFSMStvs) is an optional z/OS feature that enables batch jobs and CICS online transactions to update shared VSAM data sets concurrently. Multiple batch jobs and online transactions can be run against the same VSAM data sets, and DFSMStvs helps ensure data integrity for concurrent batch updates while CICS ensures it for online updates.

I have no personal experience in using it, just theoritical idea of how it works with coupling facility processors.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Wed Jul 25, 2012 7:36 pm
Reply with quote

Thanks all for your inputs & time very valuable indeed.

Also the design is changed to make sure the file is closed and opened again in FCT after VSAM file is updated
Back to top
View user's profile Send private message
Jose Mateo

Active User


Joined: 29 Oct 2010
Posts: 121
Location: Puerto Rico

PostPosted: Mon Jul 30, 2012 7:51 pm
Reply with quote

Good day to all!

Read up on VSAM share options. Specifing the correct share option you could do what you are asking for.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 4
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Using API Gateway from CICS program CICS 0
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top