VSAM file auditing



Help for IBM's record-oriented filesystem VSAM, ESDS, KSDS, RRDS, LDS and Storage management Subsystems

VSAM file auditing

Postby jaggz » Fri Jun 29, 2012 10:39 am

Dear Forum Users,

We have a set of VSAM files with some number of records inserted on a periodic basis. Can we track the changes made to a VSAM file based on the Dates(Including the deletion of Records ). Could anyone please shed some light on the above or an RTFM link would be really helpful.

Jaggz
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 5 times

Re: VSAM file auditing

Postby Robert Sample » Fri Jun 29, 2012 2:32 pm

Unless the application is designed to log changes, there's nothing really in the system that will give you what you asked. SMF records can tell you that the VSAM file was changed, but there's nothing recorded in them to indicate what was changed, whether records were added, deleted, or updated, and so forth.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: VSAM file auditing

Postby Anuj Dhawan » Sat Jul 07, 2012 10:23 pm

As Robert has indicated there is no way out for such a thing, however - why do you need this? What purpose will it serve?
Anuj
Anuj Dhawan
 
Posts: 273
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times

Re: VSAM file auditing

Postby dick scherrer » Sun Jul 08, 2012 2:37 am

Hello,

If the file is backed up periodically (daily, weekly, etc), a backup might be compared against the previous backup to identify inserts, deletes, and changes.

Depending on how backups are implemented, different methods would be used to do the compare.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post