Page 1 of 1

Who created the VSAM file?

Posted: Mon Feb 29, 2016 2:16 pm
by VijayMatutiDeshekar
Hi,

Can you tell if there is a way to tell who has created a given VSAM file? Like the way we can find it for PDS using "G" in front of the PDS. Can we produce similar results for VSAM too? Please let me know.

Re: Who created the VSAM file?

Posted: Mon Feb 29, 2016 10:26 pm
by zprogrammer
Try this

Code: Select all

//STEP01 EXEC PGM=IDCAMS                                        
//SYSPRINT DD  SYSOUT=*                                          
//SYSOUT   DD  SYSOUT=*                                          
//SYSIN    DD  *    
   LISTCAT ENT('<VSAM FILE NAME>') ALL 
/*   

Re: Who created the VSAM file?

Posted: Tue Mar 01, 2016 9:17 am
by Robert Sample
Can you tell if there is a way to tell who has created a given VSAM file?
Questions like this are always tough to answer -- partly because you didn't provide enough information, and partly because the answer may well depend upon the site. For example, if the VSAM data set (only Unix System Services on z/OS has files -- VSAM is not in Unix and hence is not a file, although a VSAM data set could be a Unix mount point which is totally off the point) was created by a batch job and the batch job was run by the scheduler and the batch job was added to the schedule 11 years ago by someone who hasn't worked for the company for 4 years and the OWNER field was set in IDCAMS to someone who hasn't worked for the company in 2 years -- who created the VSAM data set?

Furthermore, I suspect the putting a 'G' in front of the data set may be something site-specific to your site, so you may want to talk to your site support group about your request.

Re: Who created the VSAM file?

Posted: Tue Mar 01, 2016 11:31 am
by Anuj Dhawan
LISTCAT can have owner listed as "NULL"! May be you can look at SMF Record Type 61 which is written during any processing that results in a DEFINE request to Catalog Management Services. But even though what Robert has said remains very much relevant.

Re: Who created the VSAM file?

Posted: Tue Mar 01, 2016 4:37 pm
by VijayMatutiDeshekar
Pandora-Box wrote:Try this

Code: Select all

//STEP01 EXEC PGM=IDCAMS                                        
//SYSPRINT DD  SYSOUT=*                                          
//SYSOUT   DD  SYSOUT=*                                          
//SYSIN    DD  *    
   LISTCAT ENT('<VSAM FILE NAME>') ALL 
/*   
I know LISTCAT but it does not talk about any 'creator' of it? Where should I look for this info? Or you mean something else by this job?

Re: Who created the VSAM file?

Posted: Tue Mar 01, 2016 4:48 pm
by VijayMatutiDeshekar
What further info you might need Robert? But I understand the way you explain it. But for test and QA testing we might need such information, even there it can not be done?

G worked for me for both the companies worked for, so I thought it's a universal command.

Re: Who created the VSAM file?

Posted: Tue Mar 01, 2016 5:12 pm
by Anuj Dhawan
VijayMatutiDeshekar wrote:
Pandora-Box wrote:Try this

Code: Select all

//STEP01 EXEC PGM=IDCAMS                                        
//SYSPRINT DD  SYSOUT=*                                          
//SYSOUT   DD  SYSOUT=*                                          
//SYSIN    DD  *    
   LISTCAT ENT('<VSAM FILE NAME>') ALL 
/*   
I know LISTCAT but it does not talk about any 'creator' of it? Where should I look for this info? Or you mean something else by this job?
Unless 'am mistaken, he meant you to look for OWNER in the LISTCAT listing.

Re: Who created the VSAM file?

Posted: Tue Mar 01, 2016 5:49 pm
by enrico-sorichetti
G worked for me for both the companies worked for, so I thought it's a universal command.
I checked the ISPF ( zOS 2.1 ) manuals for the G command
and it is used on the member list panel to reset the ispf statistics
B Browse the member
C Copy the member
D Delete the member
E Edit the member
I Data set information
G Reset the member
J Submit the member
M Move the member
P Print the member
R Rename the member
T TSO command
VView the member
W WS command
= Repeat last command
wiser to double check before posting misleading information ( whatever the source might be )
and anyway the ID is available ONLY for PDS[e] members with the statistics turned on

Re: Who created the VSAM file?

Posted: Wed Mar 02, 2016 3:08 pm
by VijayMatutiDeshekar
oh sorry for the confusion it might created. What I meant was G in front of the member of a PDS and not of PDS.

Re: Who created the VSAM file?

Posted: Wed Mar 02, 2016 3:51 pm
by enrico-sorichetti
and it is used on the member list panel to reset the ispf statistics
What I meant was G in front of the member of a PDS and not of PDS.
thats exactly what the quote tells

You are still confusing things

Re: Who created the VSAM file?

Posted: Mon Mar 07, 2016 1:55 pm
by VijayMatutiDeshekar
Enrico I am afraid that I am not following you. Can you explain what do you want to convey?