Validating the Database Structure with BR*Tools - SAP Documentation

Validating the Database Structure with BR*Tools

You can use BR*Tools for Oracle to validate the database structure with BR*Tools.

Prerequisites

Make sure you have set the necessary BRCONNECT parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRCONNECT.
The database must be open.

Procedure

Start BRGUI or BRTOOLS.
Choose Database check and verification Validation of database structure

Set the required options:

Menu Entry	Equivalent BRCONNECT Command Option
BRCONNECT profile (profile)	-p\|-profile
Database user/password (user)	-u\|-user
Validate mode (validate)	-f stats -v\|-validate
Database owner for validate (owner)	-f stats -o\|-owner
Exclude from validate (exclude)	-f stats -e\|-exclude
Tables for validate (table)	-f stats -t\|-table
Confirmation mode (confirm)	-c\|-confirm
Query mode (query)	-q\|-query
Parallel degree (parallel)	-f stats -p\|-parallel
Time limit (limit)	-f stats -l\|-limit
Force time limit (force)	-f stats -f\|-force limit
Extended output (output)	-o\|-output
Message language (language)	-l\|-language
BRCONNECT command line (command)	This shows you the BRCONNECT -f stats -v\|-validate command that is to be executed using the current settings.

To start processing with the selected options, choose Continue.
Check the results in the BRCONNECT logs.
- The summary log conn<DBSID>.log displays the return code.
- The detail log c<encoded timestamp>.vst displays the progress.
For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.