How can we find out who created a particular dataset?

babathakur855 · New User Joined: 19 Feb 2008 Posts: 2 Location: Pune

expat · Posted: Thu May 15, 2008 12:10 pm

SMF type 61 records should do the trick

Example on the forum - I posted it

babathakur855 · New User Joined: 19 Feb 2008 Posts: 2 Location: Pune

expat · Posted: Thu May 15, 2008 2:23 pm

The system will create SMF records for each and every event that happens on the system, unless they have been switched off for particular functions, which is most rare.

Type 61 records are for the creation of a catalog record, i.e. a dataset is being cataloged which in 99.99% of cases means being created.

The job below which you could not find, or perhaps bother looking for, will extract the information from the required SMF records to answer your question.

May I suggest that you swat up on SMF data as it really is quite useful at times.

Sahoo · New User Joined: 08 Jun 2006 Posts: 53

Is there any other method to find out this information?

To list all the datasets in the DASD and who created the dataset and when was it created?

dick scherrer · Posted: Wed Jul 01, 2009 8:52 am

Hello,

If you want complete info, you need to use the smf data. . .

You will often not be able to detemine "who" created a dataset because it was not created by "someone", but rather by some process.

manojkumar.sesuraj · New User Joined: 15 Apr 2009 Posts: 43 Location: Mumbai

Expat, I tried with your code. But, I got the abend ABENDU0126. My code was,

//EXTRACT EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=SYSZ.SMF.HEATHER.WEEKLY.G0394V00,DISP=SHR
//SORTOUT DD DSN=T1.S88.#Z774.USER,
// DISP=(,CATLG,DELETE),
// SPACE=(TRK,(75,75),RLSE),
// RECFM=V,LRECL=330
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(6,1,CH,EQ,X'3D',AND,
121,44,SS,EQ,C'T1.S88.#Z774.TEST')
OUTFIL OUTREC=(51,8,X,67,8,X,121,44)

The error message was,
SORT FIELDS=COPY
INCLUDE COND=(6,1,CH,EQ,X'3D',AND,
121,44,SS,EQ,C'T1.S88.#Z774.TEST')
OUTFIL OUTREC=(51,8,X,67,8,X,121,44)
E RECORD TYPE IS V - DATA STARTS IN POSITION 5
9 INCONSISTENT SORTOUT IFTHEN 0 REFORMATTING FIELD FOUND
0 C5-K26318 C6-K90007 C7-K90000 C8-K23476 E9-K90007 E7-K24705

SYSZ.SMF.HEATHER.WEEKLY.G0394V00 is the weekly backup of SMF data. Im new to SMF data. Please assist me on this.

expat · Posted: Thu Jul 02, 2009 1:06 pm

I do recall at the time of posting the original code that there was a slight problem, but can not recall what it was.

I think it may have been the OUTFIL statement.

manojkumar.sesuraj · New User Joined: 15 Apr 2009 Posts: 43 Location: Mumbai

Thanks Expat, the problem is coming from OUTFIL only... Now, It is working good...

expat · Posted: Thu Jul 02, 2009 3:09 pm

In fact, at a guess I would say that you have forgotten to put 1,4, at the start of your OUTREC statement.

try

manojkumar.sesuraj · New User Joined: 15 Apr 2009 Posts: 43 Location: Mumbai

It is working fine...