View Software Release and Version | Teradata Vantage - 17.00 - 17.05 - Viewing the Software Release and Version - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
There are several methods for determining the current software release and version.
  • From any console or any client session, you can view the currently running Advanced SQL Engine version and release level with the following query:
    SELECT * FROM DBC.DBCInfoV;
    You must have the SELECT privilege on the DBC.DBCInfoV view to use this query. Typically, this view grants SELECT access to PUBLIC by default.

    The query returns the version and release level in the following form:

    *** Query completed. 3 rows found. 2 columns returned.
    *** Total elapsed time was 3 seconds.
    
    InfoKey                        InfoData
    -----------------------------  -----------------------
    RELEASE                        NN.nn.nn.nn
    LANGUAGE SUPPORT MODE          Standard
    VERSION                        NN.nn.nn.nn
    
    BTEQ -- Enter your DBC/SQL request or BTEQ command:

    Where NN.nn.nn.nn is equal to the number of the current release. For example, 15.10.00.00.

  • You can use the GET VERSION command in Supvr window of Database Window to view the current version of the PDE, DBS, GTW, TCHN, RSG, and TDGSS.

For more information on Database Window, see “Database Window (xdbw)” in Teradata Vantage™ - Database Utilities , B035-1102 .