DBComparer
DBComparer is part of the TAFJ-DB tools. It compares the structure and data from two databases defined in the configuration file (the main database and the comparer). It stops as soon as it finds a difference and the same is displayed in the console.
Prerequisites
For the targeted database, the following properties must be set to define the comparer:
- temn.tafj.jdbc.url.comparer
- temn.tafj.jdbc.driver.comparer
- temn.tafj.jdbc.username.comparer
- temn.tafj.jdbc.password.comparer
The following options are available to customize the process:
- -ignorefiles: A comma separated list of files without spaces. These files are ignored during the comparison.
- -files: A comma separated list of files without spaces. These files are included (without whole VOC) during the comparison.
- -startwithfile: All files available before the file specified in the VOC are skipped.
- -threads: Number of threads to start (default is 1).
Syntax
DBComparer
To run a comparison that starts at the mentioned file in the VOC.
DBComparer –startswithfile FBNK.CURRENCY
In case of difference in the structure, the following output is displayed:
___________________________________DBComparer__________________________________ Voc Record Key: %DATA.ACC.VOC Voc Record Key: %DATA.ACCOUNT Voc Record Key: %DICTIONARY Voc Record Key: %OTHER.VOC Unable to correctly select VOC record from comparer database: %OTHER.VOC
In case of difference in the data, the following output is displayed:
___________________________________DBComparer__________________________________ pool-1-thread-1 file: (-1) F.TT.TELLER.HP.VERSIONS Checking record: 1 pool-1-thread-1 file: (-1) F.TSA.WORKLOAD.PROFILE$HIS Checking record: 1 pool-1-thread-1 file: (-1) F.TSA.WORKLOAD.PROFILE Checking record: 1 java.lang.RuntimeException: DB::SSELECT::Comparer returned count 214 where other returned count 219 Comparer list: Other list: F.TSA.STATUS cancelling other threads.
In this topic