Platform Framework
R24 AMR | Min(s) read

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

Copyright © 2020- Temenos Headquarters SA

Published on :
Monday, May 27, 2024 5:14:17 PM IST