Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 130
Location: Guntur

PostPosted: Fri Sep 21, 2007 10:27 pm    Post subject: How to find out Equalent dataset in proc for a file in prgm
Reply with quote

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.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Sep 21, 2007 10:33 pm    Post subject:
Reply with quote

Hello,

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

Quote:
Now i need to find out what is the equivalent dataset used for a particular file
I do not understand what is an "equivalent dataset".

If you provide a few examples, it should help very much.

I am also confused by the reference to db2 in connection with "the dataset".

The better you explain, the better replies you will receive.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Sep 24, 2007 10:52 am    Post subject:
Reply with quote

dick scherrer wrote:
I do not understand what is an "equivalent dataset".

Hi Dick,

I think above can be understood as:

Consider the following statement from some COBOL program,
Code:
SELECT file-1   ASSIGN TO DD-Name-1.

Now in JCL, where this program will be EXECuted, JCL will've a statement for DD-Name-1, as below
Code:
//DD-Name-1 DD DSN=HLQ.SLQ.LLQ


Hopefully, OP is referring to 'HLQ.SLQ.LLQ' by the word "equivalent dataset".

However, expecting some more information from OP, as asked by you.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Mon Sep 24, 2007 11:02 am    Post subject:
Reply with quote

Check if your company has any Impact Analysis Tool
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 130
Location: Guntur

PostPosted: Mon Sep 24, 2007 11:41 am    Post subject: Reply to: How to find out Equalent dataset in proc for a fil
Reply with quote

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.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Mon Sep 24, 2007 11:59 am    Post subject: Reply to: How to find out Equalent dataset in proc for a fil
Reply with quote

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
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 130
Location: Guntur

PostPosted: Mon Sep 24, 2007 12:24 pm    Post subject:
Reply with quote

Hi enrico-sorichetti,

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

We use only change-man and file-aid.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Sep 24, 2007 1:19 pm    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 130
Location: Guntur

PostPosted: Wed Sep 26, 2007 12:53 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Sep 26, 2007 12:58 pm    Post subject:
Reply with quote

Reddy,

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

??????

Your post is not clear.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Sep 26, 2007 8:37 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 130
Location: Guntur

PostPosted: Thu Sep 27, 2007 9:13 pm    Post subject:
Reply with quote

Hi Dick,

We are doing now the same process which you have said
Quote:

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.



But as you have told like if we get the list of jobs/steps my problem can get solved. can you please explain me how we can do that using that list
i will be very thankful to you.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Sep 27, 2007 9:46 pm    Post subject:
Reply with quote

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 icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us