How to find out Equalent dataset in proc for a file in prgm

balakrishna reddy · Posted: Fri Sep 21, 2007 10:27 pm

Hi All,

I have a big problem

I am having alist of programs, Now i need to find out what is the equivalent dataset used for a particular file in each and every program.

some of the programs are db2 and some are cics programs.I know the manual process how to find out the dataset but i have less time and around 3000 programs to find out.

can anybody give me solution which take less time and effort to do this.

dick scherrer · Posted: Fri Sep 21, 2007 10:33 pm

Hello,

If you more clearly describe your requirement, more of us may be able to offer suggestions.

Anuj Dhawan · Posted: Mon Sep 24, 2007 10:52 am

Devzee · Posted: Mon Sep 24, 2007 11:02 am

Check if your company has any Impact Analysis Tool

balakrishna reddy · Posted: Mon Sep 24, 2007 11:41 am

Hi Anuj,

You got my problem exactly, I have a list of programs of which some are pure cobol programs , some are using db2 tables and rest are cics programs.

I am giving you the manual process i am doing so that you will get some idea of what i want.

i have a list of copybooks which i will take and search in the programs and find out the file that is using its layout, After that i note the physical name of the file from the program and search the program name in the proc library.

After getting the output i will take the procs that is used by the program and try to match the dd-name in the procs and find out the dataset that matches the file.

If this information is not clear, Please tell where you have not understood.

enrico-sorichetti · Posted: Mon Sep 24, 2007 11:59 am

Why read the source programs ???

A jcl cross referencing tool would give You the info needed as far as real datasets, plans/packages, psb's;

a source cross referencing tool will give You the info needed from a copybook point of view.

If Your organization has a change management tool ( SCLM, endevor, ....)
there should be such and option as far as the the second scenario is concerned

( I do know for sure that SCLM has it , I used it )

regards

e.s

balakrishna reddy · Posted: Mon Sep 24, 2007 12:24 pm

Hi enrico-sorichetti,

Unfortunately we don't have any of the tools you specified.

We use only change-man and file-aid.

Anuj Dhawan · Posted: Mon Sep 24, 2007 1:19 pm

Hi Reddy,

I know this in not the answer you are looking for, but let me know, what will you do with the end result, once you are done with that, what's the fianl motive behind, to get all that information?

balakrishna reddy · Posted: Wed Sep 26, 2007 12:53 pm

Hi anuj,

Actually we want to know how the data is flowing from the files to the copybook variables and viceversa..

i am facing problem when the copybook is declared in working-storage section. Like if it is used in file-section i am getting the dd-name directly and easily i can find the file that is declared with this dd-name.

But when it is used in working-storage section , I am not getting any idea about how to get the file name that is used by that copybook.

Can you give me any solution to this.

murmohk1 · Posted: Wed Sep 26, 2007 12:58 pm

Reddy,

dick scherrer · Posted: Wed Sep 26, 2007 8:37 pm

Hello,

If the copybook is in WS, look for code where it is "read into", "written from" or mentioned in a move to/from an FD entry.

If i needed to match files to programs, i would talk with the storage management people with a list of dataset names and ask them to create an SMF report showing which jobs/steps used those dsns for the last n months. When i had a list of jobs/steps, i would look at the code and do what i needed to do.

It is possible that i do not completely understand your request. If i've missed, please clarify.

balakrishna reddy · Posted: Thu Sep 27, 2007 9:13 pm

Hi Dick,

We are doing now the same process which you have said

dick scherrer · Posted: Thu Sep 27, 2007 9:46 pm

Hello,

If you get a list of the jobs/steps that use the datasets in queston, you can look at the jcl, determine which DD statements are the ones for the datasets you are interested in, get the DDNAME(s) and program id for the step, then look in the program and see what FD is asigned to the DD.

You can also see in the code if the data is moved from the FD to some other group item in WS or the Linkage section.

Good luck