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 to identify the edit user for the VSAM file in prod?

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

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Wed Dec 15, 2010 8:45 pm    Post subject: How to identify the edit user for the VSAM file in prod?
Reply with quote

Hi VSAM Gaints!

I have to identify the user who edit the production VSAM file dataset.

(Or)

Need information whether the production VSAM file dataset is edited or not? If edited, on which date and time?

Thanks!
Rajesh S.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10234
Location: italy

PostPosted: Wed Dec 15, 2010 8:51 pm    Post subject: Reply to: How to identify the edit user for the VSAM file in
Reply with quote

please explain better....
production datasets are never edited , they are UPDATED according to the application specifications

generally EDITING is considered a non procedural task, with no auditing, no validation, no ..., no ..., no ...,NO to all the things that preserve the integrity and consistency of the data!

if on the other side You use edit as a substitute for update, well that' part of the application specification
and if this possibility has not been accounted for into the initial requirement
it will not easy to add it later on
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Dec 15, 2010 9:08 pm    Post subject:
Reply with quote

SMF records?

Type 60 records updates to the VSAM volume Dataset (VVDS). Updates are recorded as INSERTED, DELETED or UPDATED. As SMS puts NVR entries into the VVDS for non-VSAM files, this can give you comprehensive audit activity for who has been creating, deleting and updating files. Some of the information this record provides is date, time, jobname, action, filename, volume(s), catalog, sms classes and newname if appropriate.

Type 61/65/66 -- These all involve IDCAMS VSAM processing. Type 61 is a DEFINE, Type 65 is a DELETE and Type 66 is an ALTER.

Type62/64 -- These records relate to VSAM component or cluster processing. Type 62 is for a cluster open, and type 64 for a cluster close or volume switch. The records include the catalog and volumes that relate to the cluster, the date and time the cluster was opened, and the job name. The type 64 record also contains information about SMB, NSR and LSR usage.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Dec 15, 2010 9:21 pm    Post subject:
Reply with quote

Anuj,

will smf records be generated when someone 'edits' a vsam dataset with File-Aid?
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 Dec 15, 2010 9:32 pm    Post subject:
Reply with quote

Hello,

Quote:
I have to identify the user who edit the production VSAM file dataset.
If your organization permits users to edit vsam datasets, someone needs to stop this practice immediately. . .

Or report this to the auditors who will have it stopped. . .

Possibly, "edit" was not the proper term. . .
Back to top
View user's profile Send private message
Rajesh S
Warnings : 1

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Wed Dec 15, 2010 10:07 pm    Post subject:
Reply with quote

There is no permits to edit or update the production other than production support team. Before edit or update the dataset they have to get proper approval.

but I could not track those information.

Before edit or update the production file. They will take a backup file.

In my case backup file also missing..
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: Thu Dec 16, 2010 12:22 am    Post subject:
Reply with quote

Hello,

How long ago was the edit of interest done?

If it was not recently, it is quite possible that all of the "footprints" are gone. . .

Other than assigning blame, what would be the use of finding "who". What has been described is a very dangerous way of processing and that needs to be addressed rather than worry about "who" made some particular undocumented change to the data.

If proper approval was gotten before the change was made, there should still a record of "who" did "what".
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8004
Location: Bellevue, IA

PostPosted: Thu Dec 16, 2010 1:13 am    Post subject:
Reply with quote

dbz: I verified that using File Aid to edit a KSDS VSAM file does generate SMF records for the updates. I saw the usual type 60, 62, 64 records so I assume the others would be generated if I did deletes in the file as well.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2432
Location: Netherlands, Amstelveen

PostPosted: Thu Dec 16, 2010 12:26 pm    Post subject:
Reply with quote

I would eventually go for a RACF audit trail.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Dec 16, 2010 2:14 pm    Post subject:
Reply with quote

thx Robert.
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 Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


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