MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

DASD File Owner? - Not a Production file

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
Bharath.AK
Beginner


Joined: 13 Jul 2007
Posts: 34
Topics: 10
Location: Los Angeles

PostPosted: Fri Mar 28, 2008 1:34 am    Post subject: DASD File Owner? - Not a Production file Reply with quote

Hi,

I was trying to find out who is the owner of a flat file on DISK, which is not a production file to track the catalog details through file touch method.

It is very hard to find out the creation job of that particular test file. If the file is on TAPE, then we can get the creation job and other details through TMS options. But, is there any way to find out the file owner/creation job details for this disk file?

Please suggest.
_________________
Regards,
BK

***** " If You Have To Do It, You Might As Well Do It Right.....If It Is Worth Doing At All, It's Worth Doing It Right !!! " *****
Back to top
View user's profile Send private message
expat
Intermediate


Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales

PostPosted: Sat Mar 29, 2008 2:37 am    Post subject: Reply with quote

Have you tried looking at the SMF type 61 records to show which job and/or userid created the dataset, or type 15 to see who last updated it ?

My posted ( and amended Embarassed ) code from a similar thread on another forum.
Code:

//EXTRACT  EXEC PGM=SORT
//SYSOUT   DD SYSOUT=*
//SORTIN   DD DSN=Your SMF data,DISP=SHR
//SORTOUT  DD SYSOUT=*
//SYSIN    DD *
 SORT      FIELDS=COPY
 INCLUDE   COND=(6,1,CH,EQ,X'3D',AND,
                 121,44,SS,EQ,C'Dataset name')
 OUTFIL    OUTREC=(51,8,X,67,8,X,121,44)

You can find the creation date of the file from 3.4

You know the dataset name to be entered into the SORT statements

You just need to find the correct SMF dataset to use as input based on the file creation date and the naming standards for your SMF dataset archives. Maybe ask your sysprogs for some guidance on this topic.
Back to top
View user's profile Send private message
shash_modi
Beginner


Joined: 22 Apr 2008
Posts: 26
Topics: 9
Location: Mumbai

PostPosted: Wed Apr 23, 2008 4:06 am    Post subject: Reply with quote

Could you please elaborate more on the above posted code? For example what to be include in sort parameter?
Back to top
View user's profile Send private message
Nic Clouston
Advanced


Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home

PostPosted: Wed Apr 23, 2008 2:25 pm    Post subject: Reply with quote

what more do you need? all you have to do is supply the smf dataset at //SORTIN and the dataset to be searched for at 'Dataset name'
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.
Back to top
View user's profile Send private message
shash_modi
Beginner


Joined: 22 Apr 2008
Posts: 26
Topics: 9
Location: Mumbai

PostPosted: Wed Apr 23, 2008 11:57 pm    Post subject: Reply with quote

Could you please tell how the code would be if my dataset name is "NUSOM12.ADDACS.CODE"?
Back to top
View user's profile Send private message
Nic Clouston
Advanced


Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home

PostPosted: Thu Apr 24, 2008 4:29 am    Post subject: Reply with quote

You have already been informed about that. The first time should be pretty obvious in the INCLUDE statement itself and my explanation:-
Code:
dataset to be searched for at 'Dataset name'
is pretty clear too (I think). But just for you:

Replace the string 'Dataset name' with the dataset name you are querying i.e. change 'Dataset name' to 'NUSOM12.ADDACS.CODE'
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.
Back to top
View user's profile Send private message
shash_modi
Beginner


Joined: 22 Apr 2008
Posts: 26
Topics: 9
Location: Mumbai

PostPosted: Thu Apr 24, 2008 4:39 am    Post subject: Reply with quote

Thanks for that. When I submitted the JCL given below:

//EXTRACT EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=NUSOM12.ADDACS.CODE,DISP=SHR
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(6,2,CH,EQ,X'3D',AND,
121,19,SS,EQ,C'NUSOM12.ADDACS.CODE')
OUTFIL OUTREC=(51,8,X,67,8,X,121,19)
//*


I am getting the error as shown below:

ICE201I E RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE027A 2 END OF FIELD BEYOND MAXIMUM RECORD LENGTH
ICE751I 0 C5-K21008 C6-K90007 C7-K90000 C8-K90007 E7-K11698
ICE026I 1 SMF RECORD NOT WRITTEN TO THE SMF DATA SET(RC=20)
ICE052I 3 END OF DFSORT

So now could you please help me in solving the above error.
Back to top
View user's profile Send private message
shash_modi
Beginner


Joined: 22 Apr 2008
Posts: 26
Topics: 9
Location: Mumbai

PostPosted: Thu Apr 24, 2008 5:45 am    Post subject: Reply with quote

The length of the dataset NUSOM12.ADDACS.CODE is FB 80.
shash_modi wrote:
Thanks for that. When I submitted the JCL given below:

//EXTRACT EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=NUSOM12.ADDACS.CODE,DISP=SHR
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(6,2,CH,EQ,X'3D',AND,
121,19,SS,EQ,C'NUSOM12.ADDACS.CODE')
OUTFIL OUTREC=(51,8,X,67,8,X,121,19)
//*


I am getting the error as shown below:

ICE201I E RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE027A 2 END OF FIELD BEYOND MAXIMUM RECORD LENGTH
ICE751I 0 C5-K21008 C6-K90007 C7-K90000 C8-K90007 E7-K11698
ICE026I 1 SMF RECORD NOT WRITTEN TO THE SMF DATA SET(RC=20)
ICE052I 3 END OF DFSORT

So now could you please help me in solving the above error.
Back to top
View user's profile Send private message
Nic Clouston
Advanced


Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home

PostPosted: Thu Apr 24, 2008 6:43 am    Post subject: Reply with quote

Please READ ALL that is written - your SORTIN dataset is the dataset containing the SMF data at the time the dataset you are trying to find the owner of was created. Think, how do you expect to find the owner in the data inside the dataset?If it was there you could read it yourself with your eyes. This job is using the DFSORT utility to extract the relevant records from the SMF data (system logging information).
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.
Back to top
View user's profile Send private message
shash_modi
Beginner


Joined: 22 Apr 2008
Posts: 26
Topics: 9
Location: Mumbai

PostPosted: Thu Apr 24, 2008 7:06 am    Post subject: Reply with quote

Ok got it. But how can we find the SMF data?
Back to top
View user's profile Send private message
Bill Dennis
Advanced


Joined: 03 Dec 2002
Posts: 579
Topics: 1
Location: Iowa, USA

PostPosted: Thu Apr 24, 2008 8:00 am    Post subject: Reply with quote

Check with your system administrator or SYSPROG to see where the SMF data is kept. You'll need the SMF data for the time when the dataset was created. Find the created date from the VTOC listing.
_________________
Regards,
Bill Dennis

Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group