Show TOC

Validating the Database Structure with BR*ToolsLocate this document in the navigation structure

Prerequisites

Context

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

Procedure


  1. Start BRGUI or BRTOOLS.

  2. Choose Start of the navigation path Database check and verification Next navigation step Validation of database structure End of the navigation path

  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.

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

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