Page 1 of 1

Production VSAM file on hold and causing prod jobs to fail

Posted: Mon Oct 03, 2022 2:08 pm
by Dicta Mitra
Hi,

Good Day!

In the recent days, we have come across instances where developers ID holding prod VSAM files and prod jobs had failed.
This is happening while the VSAM files are opened in Fileaid mostly even it was opened in browse mode.

We are asked to close all the tools and logoff from TSO before logging off for the day.

Is this how it works at all the places? If not, what is the way to solve it.

Thanks!

Re: Production VSAM file on hold and causing prod jobs to fail

Posted: Sat Nov 05, 2022 3:43 pm
by DB2 Guy
I am not sure if 'browse by file-aid' creates a Job in background but your system team can set the priorities to cancel anything of this nature for production job execution. This is a pretty common scenario and I've not it happens in shops where I have been to.

Re: Production VSAM file on hold and causing prod jobs to fail

Posted: Thu Nov 17, 2022 7:11 pm
by LalitKumar
In my company, they say that our browse session will be canceled by someone from system

Re: Production VSAM file on hold and causing prod jobs to fail

Posted: Thu Nov 17, 2022 8:28 pm
by Robert Sample
The typical solution is to create test copies of production data sets and have the developers work with the test copies. In our shop, if a developer has a lock on a data set that a production batch job needs, we'll cancel the TSO user id.

Re: Production VSAM file on hold and causing prod jobs to fail

Posted: Mon Aug 21, 2023 1:09 pm
by Dicta Mitra
Is this cancel done manually? Or there is an automation behind it?

Re: Production VSAM file on hold and causing prod jobs to fail

Posted: Sat Sep 02, 2023 12:09 pm
by Dicta Mitra
I came to know that this cancel was done manually.