| View previous topic :: View next topic | 
	
	
		| Author | Message | 
	
		| nakapako Beginner
 
 
 Joined: 21 Nov 2004
 Posts: 8
 Topics: 7
 
 
 | 
			
				|  Posted: Wed Aug 22, 2007 10:19 pm    Post subject: Checking Last Access to dataset |   |  
				| 
 |  
				| 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 |  | 
	
		|  | 
	
		| Bill Dennis Advanced
 
  
 Joined: 03 Dec 2002
 Posts: 579
 Topics: 1
 Location: Iowa, USA
 
 | 
			
				|  Posted: Thu Aug 23, 2007 8:30 am    Post subject: |   |  
				| 
 |  
				| 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 |  | 
	
		|  | 
	
		| expat Intermediate
 
  
 Joined: 01 Mar 2007
 Posts: 475
 Topics: 9
 Location: Welsh Wales
 
 | 
			
				|  Posted: Thu Aug 23, 2007 11:02 am    Post subject: |   |  
				| 
 |  
				| 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 |  | 
	
		|  | 
	
		| shash_modi Beginner
 
  
 Joined: 22 Apr 2008
 Posts: 26
 Topics: 9
 Location: Mumbai
 
 | 
			
				|  Posted: Thu Apr 24, 2008 2:58 am    Post subject: |   |  
				| 
 |  
				| 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 |  | 
	
		|  | 
	
		| acevedo Beginner
 
  
 Joined: 03 Dec 2002
 Posts: 127
 Topics: 0
 Location: Europe
 
 | 
			
				|  Posted: Thu Apr 24, 2008 5:07 am    Post subject: |   |  
				| 
 |  
				| IMHO, not a good idea believe JCL is the panacea for all our problems. |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| Nic Clouston Advanced
 
 
 Joined: 01 Feb 2007
 Posts: 1075
 Topics: 7
 Location: At Home
 
 | 
			
				|  Posted: Thu Apr 24, 2008 6:32 am    Post subject: |   |  
				| 
 |  
				| 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 |  | 
	
		|  | 
	
		|  | 
	
		|  |