Maintaining Audit Snapshot Data

Audit snapshot data is the supplemental data for the auditing and effective dating feature. Auditing and effective dating information is stored on each business object whose business class implements the auditing and/or effective dating patterns.

To maximize runtime efficiency, audit snapshot data is stored in a different form than business class data. This utility allows a Lawson administrator to verify whether the audit snapshot data is in sync with the auditing and effective dating logs, and correct any inconsistencies that might occur. The datamaint utility is often used as part of an upgrade or update in order to verify the integrity of any changes to the data that occurred as part of the update or upgrade.

You can also use the datamaint utility at other times to verify the aspects of the data covered by this utility. A typical sequence would be to run datamaint with the --auditsnapshot option in the verify mode, examine the log files that are created, and then run the appropriate updates. For example, you can run datamaint -–auditsnapshot for a single business class if that is all that needs fixing. You can also run datamaint -–auditsnapshot without the -c option if the log file indicates no Current Row/AuditLog mismatches that need fixing.

You can find log files at

%LALOGDIR%\datamaint\auditsnapshot.log.dataArea.Stamp

At a Landmark command prompt, type

datamaint --auditsnapshot -V|-U|-F|-H [-cdtrACS] [-n NN] [-f filter] [-w workFileName] dataArea [businessClass]

Consider the following

Program Option Description
-A Perform a data type validation against all persistent audited fields. For example, an audited date value of "02190202" would be reported as an invalid date as it is outside the common date range of "18000101" and "21991231". This option is only valid if the -V option is also specified.
-V Validate snapshot data is in sync with auditing and effective dating logs.
-U Update snapshot data from auditing and effective dating logs if out of sync.
-F Force delete and recreate of all snapshot data. This option acquires an exclusive lock on the data area.
-H Access help for this command.
-r Prompt for repeat when done.
-d Show more detailed output.
-t Show terse output (default).
-c Correct or verify current row/audit view inconsistencies.
-C Do NOT correct or validate current row/audit view inconsistencies (this is the default for an update mode).
-S Do NOT correct or validate snapshot data.
-n NN Use multiple concurrent threads when running datamaint. This is useful if you have multiple CPUs available.
-f filter Filter criteria. (Valid only when business class is specified.)
-w workFileName Process the business classes listed in the specified work file.
dataArea Select a data area to work with.
businessClass Select a specific business class to work with.