datamaint - Data Maintenance

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

To maintain audit snapshot data, use the following command syntax:

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

Reporting on Effective Dated Changes

You can generate a report listing business objects that have pending future dated changes. The report lists the primary key of the object that has pending changes, the number of pending changes, and when the first pending change will apply.

This utility only takes action on data in business classes that use the implement Effective Dated pattern.

You can find log files at

%LALOGDIR%\datamaint\effectivedatedreport.log.DataArea.Stamp 

To run the effective dated report, use the following command syntax:

datamaint --effectivedatedrpt -H [-f filter] -[dt] dataArea [businessClass]

Maintaining Encrypted Data

You can verify or update the encryption status for data belonging to a business class that implements the Encrypted LPL pattern. This type of encryption is managed by the application layer, rather than the database interface layer, thus requiring an action other than a database reorganization to implement changes. Select a data area to work with.

This utility only takes action on data in business classes that use the implement Encryption pattern.

You can find log files at

%LALOGDIR%\datamaint\encryptionmaint.log.DataArea.Stamp

To maintain encrypted data, use the datamaint command with the following command syntax:

datamaint --encryption -V|-U|-H [-f filter
                    Select a data area to work with.] -[Fdt] dataArea [businessClass]

Propagating User List Modifications

You can propagate user list modifications from one user to other users. The --modifylist option enables a specific actor's UserList modifications to be cloned to another actor or all other actors. List modifications are stored in the UserList business class of the module repository. Lists already modified by a targetActor are skipped if -o is not specifie. If targetActor is not specified, the list modifications are cloned across all actors. Wildcards are accepted for businessClass and/or list (for example, datamaint --modifylist MyDataArea Fred "*" "*" Bob).

datamaint --modifylist [-H] [-od] dataArea actor businessClass list [targetActor]

Verifying/Updating Field Data for SQL Portability

User this datamaint option to verify and update field data so that it can ported to an SQL database. By default, this option identifies embedded NULLs in alpha and text fields, and replaces these with u+0020. You can also supply regular expressions to identify other bad data in alpha and text fields.

To verify or update field data for SQL portability, use the datamaint command with the following command syntax:

datamaint --baddata -V|-U [OPTIONS] dataarea [busClass ...]

datamaint --baddata -V|-U [OPTIONS] --prodline prodLine [busClass ...]

datamaint --baddata -V|-U [OPTIONS] --tenant tenant [busClass ...]

datamaint --baddata -V|-U [OPTIONS] --all [busClass ...]

datamaint --baddata -H

Maintaining Audit Corrections Data

This datamaint option provides the ability to validate and/or update incorrectly applied future audit corrections data. If the data is out of sync, data visability issues can arise. This utility allows a Lawson administrator to verify whether the audit correction data is in sync and correct inconsistencies if they exist.

After running the verification you can scan the LALOGDIR/datamaint/auditcorrectionmaint.log.XXX that was produced to identify specific business classes that need updates. The datamaint --auditcorrections also accepts a '-W workfile' argument where you can create a file with a list of business classes to process. If the verify identifies more than a couple than it may be easier to create a workfile instead of running the update on each individual business class.