Checking if a vSAM file is open

[DanM]

I am looking to create a batch job to check if a CICS VSAM file is open or not. Does anybody know of a way to do this without trying to open the file and checking the return code?

[dbzthedinosaur]

you mean OPEn and ENAbled?

requires setup, but IBM has a facility called The EXCI programming interfaces
Allows you to issue CICS commands thru batch, e.g. CEMT.
Not only can you inquire, you can CLose and DISAble,
and then OPEn and ENAble after the batch run.

there are a million third party tools that do this, also.

[petwir]

The EXCI solution is the best. We do that here, so our batch jobs can control the opening/closing of our CICS/VSAM files. Not every shop has EXCI services set up though.

Depending upon your scenerio, you may prefer to design an application solution. The processes that cause the file to OPEN could be modified to update a state-field in a DB2 row. Then your batch application could query this DB2 row to determine the files state.

update <db2table>
set FILE_STATE = 'OPEN'
where <rowselectionrule>
and FILE_STATE <> 'OPEN'

And of course you'd have to design another event to set FILE_STATE to 'CLOSED' at the appropriate time.

[yarnseeker]

We use something called DADS for that.