Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to find CICS regions accessing VSAM file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
Marimuthu R

New User


Joined: 03 Nov 2010
Posts: 3
Location: Chennai

PostPosted: Tue Dec 21, 2010 7:03 am    Post subject: How to find CICS regions accessing VSAM file
Reply with quote

Hi all,
I have to update some records thro JCL in a vsam file, which is used by some cics region. Before updating, the file needs to be closed in the cics regions. So I need to know what are regions are accessing this file.. Any idea to find the region details..? can anyone pls help me..



Thanks & Regards

Marimuthu
Back to top
View user's profile Send private message

Bill O'Boyle

CICS Moderator


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

PostPosted: Tue Dec 21, 2010 7:13 am    Post subject: Reply to: How to find CICS regions accessing VSAM file
Reply with quote

From an Application Programmer point of view, logon to all the regions you suspect are accessing this file, clear the screen and issue -

Code:

CEMT INQ FIL('FILENAME')

If the region has this file defined, then the response will be NORMAL. Write down this region name and then go on to the next region until there aren't anymore.

Otherwise, contact your CICS System Programmer, who can use another IBM transaction (which is not normally available to Application folks), explain what you're looking for and he/she will return a list of regions.

BTW, substitute 'FILENAME' with the actual name.

There's also a "trick" you can perform from ISPF 3.4, where you try and rename the target VSAM file, but of course, this is illegal.

With that, you'll probably get back a list of resources who have Exclusive Control. These should be your region names.

Some shops have a routine named "WHOHAS" or "WHOUSE", which you type next to the VSAM file name from ISPF 3.4.

Give it a try....

Bill
Back to top
View user's profile Send private message
Marimuthu R

New User


Joined: 03 Nov 2010
Posts: 3
Location: Chennai

PostPosted: Tue Dec 21, 2010 7:30 am    Post subject: Reply to: How to find CICS regions accessing VSAM file
Reply with quote

Thanks Bill..
We have n number of cics regions and also we don't kmow the all region list.. so i am not sure using 'CEMT I FI(FILENAME)'.. Since i need to run in production i dont think, i can check the rename concept also. i have physical file name of the vsam. with this, is there any chance to find the cics regions accessing this file..

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

Global Moderator


Joined: 06 Jun 2008
Posts: 7993
Location: Bellevue, IA

PostPosted: Tue Dec 21, 2010 7:57 am    Post subject:
Reply with quote

Quote:
i have physical file name of the vsam. with this, is there any chance to find the cics regions accessing this file..
Contact your site support group and get their assistance.

Otherwise, there is no simple way to get that information -- you could, if you have access (many applications programmers do not), look at the CSD file for each CICS region and extract the file names to see if any match your file name. Of course, if the DD name is in the CICS region JCL, that DSN could override the CSD entry -- so you're not guaranteed that looking at the CSD files alone will give you all of them.

If I needed to do this, I'd run a batch job that allocated the DSN DISP=OLD and then find out which CICS regions are in contention for the data set name (console command D GRS,C for example). But many application programmers do not have access to console commands, either.
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Tue Dec 21, 2010 10:24 am    Post subject:
Reply with quote

Hello,

Why not schedule your updates to run when the regions are down . . .
Back to top
View user's profile Send private message
Marimuthu R

New User


Joined: 03 Nov 2010
Posts: 3
Location: Chennai

PostPosted: Wed Dec 22, 2010 7:21 pm    Post subject: Reply to: How to find CICS regions accessing VSAM file
Reply with quote

Thanks everyone.. I got the region details with the help of cics team..
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 1 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 3 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us