DBCheck
DBCheck is part of the TAFJ-DB tools. It checks your database integrity by selecting all the tables from TAFJ_VOC.. It performs the following tasks for all the tables:
- Open the table and check its type
- Write a test record on it
- Read that test record
- Read that test record and lock it
- Delete the test record
These operations are displayed on the console in the following format:
Table name - Table type - W(write) R(read) RU (read and lock) D (delete) - Time elapsed
Syntax
DBCheck [-cf <configuration>[.properties]]
The targeted database is defined in your default configuration file or in the configuration specified by the -cf option.
DBCheck
The resulting output looks like this:
___________________________________DB Check_________________________________ 1) FBNK.AA.ARR.ACTIVITY.API$HIS Type =XML WRRUD 407 ms [DONE ] 2) FEU1.AA.ARR.ACTIVITY.API$NAU Type =XML WRRUD 31 ms [DONE ] 3) FBNK.AA.ARR.ACTIVITY.CHARGES Type =XML WRRUD 31 ms [DONE ] 4) FMF1.AA.ARR.ACTIVITY.CHARGES$NAU Type =XML WRRUD 47 ms [DONE ] 5) FSG1.AA.ARR.ACTIVITY.CHARGES$SIM Type =XML WRRUD 47 ms [DONE ] 6) FEU1.AA.ARR.ACTIVITY.MAPPING$NAU Type =XML WRRUD 47 ms [DONE ] ……. 17673) FSG1.SC.FEE.GROUP.HIST Type =XML WRRUD 31 ms [DONE ] 17674) FSG1.SC.FEE.GROUP.HIST$NAU Type =XML WRRUD 16 ms [DONE ] 17675) FSG1.SC.FEES.MODIFY Type =XML WRRUD 15 ms [DONE ] 17676) FSG1.SC.FUND.FLOW Type =XML WRRUD 32 ms [DONE ] _____________________________________________________________________________
In this topic