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 identify a program based on the data of vsam?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 236

PostPosted: Mon Oct 11, 2010 1:07 pm    Post subject: How to identify a program based on the data of vsam?
Reply with quote

Hi all,

I have a vsam file with some records in it.
I can't find the program which wrtites the data into it. Is it possible to identify the program which writes the data into the VSAM using SMS?

The Method used to search the program which writes the data into VSAM

1.Endevor Search using the logical file name/ddname/physical file name
2.Searched in CICS programs with 'Write' Syntax.
3.Searched in Batch programs with 'Write' Syntax.

Note:
How the records are written into VSAM file?
While invoking the front end screen the VSAM file was written for a particular function. From front end a trans-id is invoked but the file is not used for writting in mainframe end.

Thanks,
Murali.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Mon Oct 11, 2010 1:17 pm    Post subject: Reply to: How to identify a program based on the data of vsa
Reply with quote

what about looking at the application specs ?

the only way to find out something on file access from a system point of view
is to process the SMF data

but it will tell You only <who> opened the dataset
see the SMF documentation for the meaning of <who>

a free tool to find out a lot about dataset access processing smf data is DAF
http://home.pacbell.net/mcleary/freeware.html

very useful, very smart
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Oct 11, 2010 2:10 pm    Post subject:
Reply with quote

Have you considered that the VSAM cluster is merely loaded by IDCAMS or SORT ?
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: Mon Oct 11, 2010 9:26 pm    Post subject:
Reply with quote

Hello,

Is the vsam file read only or is the data updated only by loading?
Back to top
View user's profile Send private message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 236

PostPosted: Mon Oct 18, 2010 11:59 am    Post subject:
Reply with quote

IDCAMS/SORT is not used to load the data.Also it's not a read only file, it is updated using CICS COBOL programs.
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: Mon Oct 18, 2010 7:13 pm    Post subject:
Reply with quote

Hello,

Then you will need to search the source for modules where this file is used and within that list determine which actually update the file.

Proper documentation would show which transactions and batch processes update this data. If the documentation does not exist, you will be creating the first set of it. . .
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Mon Oct 18, 2010 10:15 pm    Post subject:
Reply with quote

Or loaded ( add, update, del ... ) by cobol program A then the name is altered by IDCAMS.
Why not?
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: Mon Oct 18, 2010 10:51 pm    Post subject:
Reply with quote

Hello,

If i understand the situation, it is known that some COBOL programs update the file but nothing has been found that puts data into the file.

Quote:
IDCAMS/SORT is not used to load the data
How is this known?

Is there some process that regularly does a delete/define for this file? There would be a load to follow. . .
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Mon Oct 18, 2010 11:34 pm    Post subject:
Reply with quote

dick scherrer wrote:
Proper documentation would show which transactions and batch processes update this data.

"Proper documentation"?

"Proper documentation"?

"Proper documentation"?

36_11_6.gif
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Oct 19, 2010 12:03 am    Post subject:
Reply with quote

Akatsukami wrote:
dick scherrer wrote:
Proper documentation would show which transactions and batch processes update this data.

"Proper documentation"?

"Proper documentation"?

"Proper documentation"?

36_11_6.gif


Is there really such a thing as PROPER DOCUMENTATION I thought that was a fable like political ethics?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Oct 19, 2010 12:22 am    Post subject:
Reply with quote

Proper Documentation has the wrong phrase.
ANY Documentation.

and there are political ethics,
problem is there are no ethical politicians.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm


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