Viewing Teradata Database Configuration - Visual Explain

Teradata Visual Explain User Guide

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

Viewing Teradata Database Configuration

View the Teradata Database configuration where the execution plan is captured.

To view the Teradata Database configuration

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

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