Page 1 of 1

VSAM file auditing

PostPosted: Fri Jun 29, 2012 10:39 am
by jaggz
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

Re: VSAM file auditing

PostPosted: Fri Jun 29, 2012 2:32 pm
by Robert Sample
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.

Re: VSAM file auditing

PostPosted: Sat Jul 07, 2012 10:23 pm
by Anuj Dhawan
As Robert has indicated there is no way out for such a thing, however - why do you need this? What purpose will it serve?

Re: VSAM file auditing

PostPosted: Sun Jul 08, 2012 2:37 am
by dick scherrer
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.