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 

Checking Last Access to dataset

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF
View previous topic :: View next topic  
Author Message
nakapako
Beginner


Joined: 21 Nov 2004
Posts: 8
Topics: 7

PostPosted: Wed Aug 22, 2007 10:19 pm    Post subject: Checking Last Access to dataset Reply with quote

Hi All,
Need assistance with RACF. How do I check what userid had last updated a dataset?

thanks for your assistance.

danteb
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 Aug 23, 2007 8:30 am    Post subject: Reply with quote

We use SMF data to see who had a dataset OPEN for OUTPUT or UPDATE. Processing SMF data can be difficult due to formats used (variable length sections with OFFSET, LEN flags).
_________________
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
expat
Intermediate


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

PostPosted: Thu Aug 23, 2007 11:02 am    Post subject: Reply with quote

Yes, SMF is the only way to do this.

Fortunately the type 15 records are fairly easy to disect.

If you have SAS available here's the code to get you what you want

Code:

IF RECTYPE = 15 THEN DO;
     INPUT   @003     SMFTIME    ??   SMFSTAMP.
             @011     SYSTEMID        $4.
             @015     JOBNAME         $8.
             @053     DDNAME          $8.
             @065     DATASET         $44.;

_________________
If it's true that we are here to help others,
then what exactly are the others here for ?
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 2:58 am    Post subject: Reply with quote

Could you please tell us how the JCL will look like if want to see who has updated the dataset say 'NUSOM12.ADDACS.CODE" last time?
Back to top
View user's profile Send private message
acevedo
Beginner


Joined: 03 Dec 2002
Posts: 127
Topics: 0
Location: Europe

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

IMHO, not a good idea believe JCL is the panacea for all our problems.
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:32 am    Post subject: Reply with quote

I guess the JCL would be the same as for the previous requirement - just need to change the dataset names to match your own shop. Your SAS code will change as you will be searching for a different dataset name from the OP.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.
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 -> TSO and ISPF 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