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 can we find out who created a particular dataset?

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

New User


Joined: 19 Feb 2008
Posts: 2
Location: Pune

PostPosted: Thu May 15, 2008 11:44 am    Post subject: How can we find out who created a particular dataset?
Reply with quote

How can we find out who created a particular dataset?
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: Thu May 15, 2008 12:10 pm    Post subject:
Reply with quote

SMF type 61 records should do the trick

Example on the forum - I posted it
Back to top
View user's profile Send private message
babathakur855
Warnings : 1

New User


Joined: 19 Feb 2008
Posts: 2
Location: Pune

PostPosted: Thu May 15, 2008 1:05 pm    Post subject: Please eloborate it
Reply with quote

expat wrote:
SMF type 61 records should do the trick

Example on the forum - I posted it


Hi,

I am not able to get your point on SMF type 61 could you please eloborate where exactly i need to specify this?
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: Thu May 15, 2008 2:23 pm    Post subject:
Reply with quote

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.

Code:

//EXTRACT  EXEC PGM=SORT                     
//SYSOUT   DD SYSOUT=*                       
//SORTIN   DD DSN=Dumped SMF dataset
//SORTOUT  DD DSN=Your output dataset         
//            DISP=(,CATLG,DELETE),           
//            SPACE=(TRK,(75,75),RLSE),       
//            RECFM=FB,LRECL=330             
//SYSIN    DD *                               
 SORT      FIELDS=COPY                       
 INCLUDE   COND=(6,1,CH,EQ,X'3D',AND,         
                 121,44,SS,EQ,C'Find this DSN')
 OUTFIL    OUTREC=(51,8,X,67,8,X,121,44)     
Back to top
View user's profile Send private message
Sahoo

New User


Joined: 08 Jun 2006
Posts: 53

PostPosted: Wed Jul 01, 2009 7:53 am    Post subject: Reply to: How can we find out who created a particular datas
Reply with quote

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?
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: Wed Jul 01, 2009 8:52 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
manojkumar.sesuraj

New User


Joined: 15 Apr 2009
Posts: 43
Location: Mumbai

PostPosted: Thu Jul 02, 2009 11:07 am    Post subject:
Reply with quote

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.
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: Thu Jul 02, 2009 1:06 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
manojkumar.sesuraj

New User


Joined: 15 Apr 2009
Posts: 43
Location: Mumbai

PostPosted: Thu Jul 02, 2009 3:07 pm    Post subject:
Reply with quote

Thanks Expat, the problem is coming from OUTFIL only... Now, It is working good... icon_biggrin.gif
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: Thu Jul 02, 2009 3:09 pm    Post subject:
Reply with quote

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

try
Code:

  OUTFIL OUTREC=(1,4,51,8,X,67,8,X,121,44)   


Ooops, should have hit "REFRESH" before posting and saw that you fixed it. Well done for fixing it yourself icon_wink.gif
Back to top
View user's profile Send private message
manojkumar.sesuraj

New User


Joined: 15 Apr 2009
Posts: 43
Location: Mumbai

PostPosted: Thu Jul 02, 2009 4:28 pm    Post subject:
Reply with quote

It is working fine... icon_biggrin.gif
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 Browse dataset cvnlynn CLIST & REXX 4 Tue Jul 18, 2017 3:52 am
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts LISTCAT on a dataset with symbolic pa... shreya19 JCL & VSAM 5 Fri Apr 07, 2017 5:43 pm


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