16.10 - Viewing the Software Release and Version - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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 Teradata Database 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 Utilities.