How to confirm Teradata Version

Database
N/A

How to confirm Teradata Version

I am looking for some help to confirm the version of Teradata installed on a specific Teradata Server. Essentially is Teradata V2R.06 the same as V2R6.2? It would be helpful to know how to confirm the version information for a Teradata Server.
2 REPLIES
rgs
Enthusiast

Re: How to confirm Teradata Version

select * from dbc.dbcinfo;

There is no such version as V2R.06 (typo?)
Teradata Employee

Re: How to confirm Teradata Version

DBCInfo reports both the PDE "VERSION" and DBMS "RELEASE". Prior to TD12, the VERSION string has a "V2R." prefix while the RELEASE string does not. The general format of the release number is the same for both packages: major.minor.maintenance.e-fix
This is documented in the Data Dictionary manual.

Major/minor/maintenance numbers should match between PDE and DBMS, but the e-fix number often will not. (Think of the e-fix part as a "build sequence number", which is independent for each package; most DR fixes result in a change to one package or the other, not both.)