Show TOC

Procedure documentationValidating the Database Structure with BR*Tools Locate this document in the navigation structure

 

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

Prerequisites

Procedure

  1. Start BRGUI or BRTOOLS.

  2. Choose   Database check and verification   Validation of database structure  

  3. 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.

    1. To start processing with the selected options, choose Continue.

    2. 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 Logs with BR*Tools.