Data Integrity Checker

The Data Integrity Checker (DIC) enables you to check the integrity of your FTM SWIFT database. It detects if data was manipulated, that is, if a record was inserted, updated, or deleted by a person or program that is not authorized to do so. Furthermore, you also use this utility to initialize the data integrity framework and re-build data integrity information.

The DIC writes events into the FTM SWIFT event log, for example:
DNPD1233E Found 560 additional problem(s) in table DNF_OAMS

If the DIC reports a data manipulation, your system was probably tampered and you must take appropriate actions. After you have ensured the validity of your data, you can re-build the associated control tables by issuing the DIC with command build. If the verified data is not valid, you can use the dispose command to remove the data.

In addition, you are advised to do the following to ensure the integrity of your FTM SWIFT data:
  • Run the DIC command check periodically (for example, every two weeks). To do this, you can, for example, set up a cron job.
  • Check the return code of the DIC after termination. For information on return code values, see Return codes.
  • Monitor the FTM SWIFT event log for messages of the data integrity framework as described in Monitoring data integrity.
  • Change the password that is used by the data integrity framework according to your policies. To change the password, issue the DIC command changepw. Note that changing the data integrity password requires an FTM SWIFT downtime.
  • Dispose manipulated data entries of the FTM SWIFT database SIPN FIN services tables. To dispose a data entry, issue the DIC command dispose.