How to find the user who has cteated a dataset?

David_Li · New User Joined: 05 Apr 2006 Posts: 10

If a dataset exists on system, I want to know who creates it, how to do it?

DASDMan0108 · New User Joined: 05 Apr 2006 Posts: 2 Location: Omaha, NE

You can find this by using SMF (System Management Facilities). Use the MVS SMF manual to see the layout of the Type 15 record. You can then either write a program to read the SMF records, or use something like SAS or EasyTrieve to retrieve and format the data. There are also third party packages that can assist you. I believe CA-Disk has this ability.

rohit jaiswal · Posted: Thu Apr 06, 2006 11:08 am

hi dasdman

can you please expalin thee above explaied information in detail and if possible do attach some programs

thank you

regards
rohit

David_Li · New User Joined: 05 Apr 2006 Posts: 10

Thanks for your reply for this. Could you please give me more detail info about how to use the MVS SMF to get the answer?l

DASDMan0108 · New User Joined: 05 Apr 2006 Posts: 2 Location: Omaha, NE

You should be able to find the doc at this link:

www.mainframes.com/books.htm

Look for the layout of Type 15 record. I'll paste the EasyTrieve parms below. You would need to find the area of the record that contains USER information, and add that to the parms:

PARM DEBUG(FLOW)
FILE SMF VBS (22528 4086)
RECTYPE 2 1 B
JOBDATE 27 4 P
JOBNAME 15 8 A
JOBMASK 15 2 A
NUMDEV 51 1 B
VOLUME 271 6 A
DDCARD 53 8 A
DSNAME 65 42 A
EXTENTS 282 1 B
FILE RPT1 PRINTER

JOB INPUT SMF
IF RECTYPE EQ 15
IF EXTENTS GT 10
IF JOBMASK EQ 'WO' OR JOBMASK EQ 'CO' OR JOBMASK EQ 'WA'
PRINT RPT1
END-IF
END-IF
END-IF
*
REPORT RPT1 PRINTER RPT1 TALLYSIZE 10
TITLE 1 'SMF DSN EXTENTS'
LINE 1 JOBDATE +
JOBNAME +
DDCARD +
DSNAME +
VOLUME +
NUMDEV +
EXTENTS

Not much to it. If you use SAS, that's another option. I know a lot of people write their own retrieval software in COBOL or ASSEMBLER. If your company has CA-DISK, formerly SAMS-DISK, look into the BrightStor option. Good luck.

Bill McCoy · New User Joined: 18 May 2006 Posts: 3

SMF type 15 records are written for outputs to sequential records. You should first determine if the dataset is sequential or vsam, and you will need to determine the dataset's creation date. If the dataset is vsam, then you should look for SMF type 61 (define). You need to know create date so you can determine which SMF datasets to process. Good hunting!