Viewing Teradata Database Configuration

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K
View the Teradata Database configuration where the execution plan is captured.

Load an execution plan before viewing the Teradata Database configuration. For more information, see Loading and Viewing an Execution Plan.

  • Click .

    The Teradata Database Configuration dialog box appears. Information in this dialog box cannot be altered. The table describes the information displayed in this dialog box.

    Box Name Description
    Database Name Name of the database to which the user was connected when the execution plan was captured.
    Number of AMPs Number of AMPs on the system where the plan is captured.
    Number of PEs Number of PEs on the system where the plan is captured.
    Number of Nodes Number of nodes on the system where the plan is captured.
    Release When the plan is captured, the release level of the software loaded on Teradata Database. For example:
    • V2R.nn.nn.nn.nn for releases earlier than 12.00.00
    • nn.nn.nn.nn for release 12.00.00 and later
    This attribute comes from the DBC.DBCInfoTbl system table.
    Version When the plan is captured, the version of the software on Teradata Database. For example, 05.01.02.03 represents the:
    • Major release number (05)
    • Minor release number (01)
    • Maintenance release number (02)
    • E-fix or patch release number (03)
    These numbers come from the DBC.DBCInfoTbl system table.