Description

With the bdbvalidate tool you can read the tables of specified company numbers to verify if the data is according to the domain constraints as defined in data dictionary. Adding the –R option will create a report of the file.

With the bdbvalidate tool several internal consistency rules for multilanguage fields (MLFs) can be verified.

The bdbvalidate command can print information such as:

• Names
• Number of records
• Errors

Use the –s option to suppress the messages that are produced by bdbvalidate at run time.

These options are available:

• –U/u

  Usage information.

• –V/v

  Version information.

• -d

  Check domain constraints.

• -r

  Check referential integrity.

• -H

  Check for high ASCII characters in single byte strings.

• -h

  Allow high ASCII in single byte string fields, strict mode only.

• -b

  Buffering on: Report is sorted and printed when last task is ready.

  The bdbvalidate command runs multiple tasks in parallel. The order in which the output is produced is unpredictable. Each "task" is the validation of a single table. The default operating mode is to produce the output for the report file and stderr as soon as a task is completed. This implies that the order in which tables are reported is unpredictable, but progress can be tracked. When the -b option is used, all output is buffered internally. When the last task is finished the result is sorted, on table name and company number, and printed. See also the -J option to control parallelism.

• –p package combination

  The name of the package combination to be used.

• –s

  This suppresses error messages and other information.

• –z number

  This option limits the number of reported errors for each table.

• -y

  Do not allow UTC times later than 2038-01-19 03:14:07 (numerical value above signed 32-bit maximum 2147483647).

• –C

  Company numbers for a given table in these formats:

  • Specific company numbers, for example, 001 002.
  • Range of company numbers, for example, 001-010.

    You can specify multiple (space separated) company numbers or ranges of numbers.

• –I file

  Validate all tables of which the names are listed in the specified file. Each table name in file must be on a separate line. A table name may include a company number. For example, table tccom100 in company 570 is specified as tccom100570.

• -J number of parallel tasks

  Specifies the number of parallel tasks that the bdbvalidate command will run. Every table validation is a "task". Parallel execution can speed up the validation of many tables considerably. The minimum valid value is 1 (sequential behavior). The default is 4, the maximum is 128. Be careful when selecting this value: too much parallelism can cause system overload and database connection problems.

  You can also set the parameter using the bdbvalidate_parallel resource value or using a BDBVALIDATE_PARALLEL environment variable. See the -b option to control the order in which output of parallel tasks is printed.

• -l locale

  Set the BSE_LOCALE.

• -i

  Intended (iso) install locale, for high ASCII in strict mode.

• –N table [table…]

  List of tables to be validated.

• –E file

  Redirects errors to error file.

• –R file

  Create a report file which lists all errors found, per table.