Close the VSAM files for Batch use

Satheeshkumar · New User Joined: 20 Feb 2009 Posts: 51 Location: Chennai

Hi,

My requirement is that i have to create a JCL.

Close the VSAM files for Batch use, if the VSAM file is defined for online transactions.

Can any one help me on this?

expat · Posted: Wed May 12, 2010 3:06 pm

What do you mean by closing the VSAM files for batch use ?

Escapa · Posted: Wed May 12, 2010 3:09 pm

Bill O'Boyle · Posted: Wed May 12, 2010 4:41 pm

I guess you mean closing the VSAM files to CICS to allow Batch update?

Do your applications handle an INVREQ when the file is being updated by Batch and the application issues a READ for UPDATE, ADD or DELETE?

You can CLOSE the file to CICS, reset its attributes to REA BRO and reopen it if the applications recognize INVREQ.

There are a number of ways to close the file, such as a CEMT using a JES Modify command or an EXCI program from Batch which links to a CICS program which issues SET FILE API's or (as a last choice) to the older CEMT Programmable Interfaces DFHEMTA/DFHEMTP (neither are commended). Both of these interface usages requires a user-program in CICS which then issues a LINK-API to either. Note that DFHEMTA will return a return-code, whereas, DFHEMTP does not. The commarea passed to DFHEMTA consists of five 24-Bit storage addresses.

Bill

Satheeshkumar · New User Joined: 20 Feb 2009 Posts: 51 Location: Chennai

we have to ADD OR DELETE the record in VSAM KSDS through batch.

Robert Sample · Posted: Wed May 12, 2010 5:36 pm

I think you need to discuss your issue with your site support group. Some sites have packages to close online files, some don't and your site support group will know your environment far, far better than we could. The wording of your question seems to imply you want to prevent batch updates while the online system is up and there is no practical way to do that -- unless you use your site security package to restrict access.

Satheeshkumar · New User Joined: 20 Feb 2009 Posts: 51 Location: Chennai

we are going to delete few record from KSDS file, before deleting record if the VSAM file is defined(opened) for online transactions, it has to closed

Robert Sample · Posted: Wed May 12, 2010 5:57 pm

You need to talk to your site support group to find out what is available at your site. If your site does not have one of the packages that does this, as Bill said, there are a number of ways to do this. Which is used will depend upon your site standards and procedures, which we cannot know.

dick scherrer · Posted: Thu May 13, 2010 6:13 am

Hello,

Far less exciting, but many systems run these batch jobs when the online regions are down. Most users are not tolerant of taking away their access just because someone wants to run some batch job in the middle of the day.

If this file maintenance must be done while cics is up, why not run these updates in a cics program rather than a batch program?

Satheeshkumar · New User Joined: 20 Feb 2009 Posts: 51 Location: Chennai

We are going to delete more number of records thats why we cannot do this in CICS program.

if the VSAM file is defined(opened) for online transactions,we have close this using batch job JCL instead of manual closing using CEMT transaction.

Can any one help me to write JCL(batch job) for this.

Thanks,
Sat

dbzTHEdinosauer · Posted: Mon Jul 05, 2010 7:06 pm

Sat,