Viewing Teradata Database Configuration - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

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” on page 145.

  • 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
  • Note: 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)
  • Note: These numbers come from the DBC.DBCInfoTbl system table.