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: 237

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: 10292
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: 237

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: 1772
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: 6968
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 Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts How do you create Eclipse based dialogs jasorn IBM Tools 0 Thu Aug 03, 2017 5:05 pm
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm
No new posts Paasing symbolic parameter to instrea... Robert Sample JCL & VSAM 2 Thu Jul 27, 2017 1:22 pm


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