IBM Mainframe Forum

I need need some help on the CICS administration side,
we are trying to develop a utility or process to do an impact analysis and find the following cross reference

“ TXN to PGM to VSAM file” for a CICS installation.

a cross reference to see which program is using which file, which transaction is using which program, etc. So that we can reverse engineer the current legacy system in a more meaningful way.

Please provide suggestion to track this reference

Since programs are related to transactions in the CICS tables, it is very easy to extract the data for the CSD file used by the region to find transactions and programs and their relationship.

I know of no way, however, to relate files to programs except by reading the code manually. You could run a utility against your program library to identify the EXEC CICS READ, WRITE, DELETE, START, etc statements (depending, of course, upon your site coding standards -- this might not work in all cases) but the file name could be a constant in the command, or it could be an elementary variable in WORKING-STORAGE or LINKAGE section, or it could be a group variable in WORKING-STORAGE or LINKAGE section. Somebody would have to review the output of the utility to identify the file names.

Robert, don't forget that programs can be used under an entirely different transaction through XCTL and LINK, so the CEDF will give you a good start, but will not give you a complete list. Only way I can see is through SMF records, but if you do not have a tool to extract the information .......