(470) Data verification between AS400 and the target database

QMirror/DB provides a rapid yet low loading function for data verification between AS400 and the target database.

The function first compares record counts between AS400 and the target database, then deletes the extra records and downloads the missing records.

If you want to verify a specified AS400 table at once, set the verification flag TBVRFY to ‘A’ in system table QMIRROR.ZAMTBF, or set the verification flag TBVRFY to ‘X’ to omit that specified AS400 tables.

For the updated tables, QMirror/DB sets their TBVRFY to ‘U’ and does data verification in the next early morning.

Previous (460) Remove tables from QMirror/DB table list
Next (480) Large object (LOB) processing