How can I tell what version the database I have?

Teradata Database on AWS
Teradata Employee

How can I tell what version the database I have?

 
Tags (1)
2 REPLIES
Teradata Employee

Re: How can I tell what version the database I have?

To check which version of PDE/DBS is running, run the following command:

# pdepath -i

Teradata Employee

Re: How can I tell what version the database I have?

From Linux:

lnx2078:~ # /usr/pde/bin/pdepath -i

PDE: 15.10.00.09        <=== PDE Version

TDBMS: 15.10.00.09   <=== Database Version

TDGSS: 15.10.00.05

TGTW: 15.10.00.01

PDEGPL: 15.10.00.09

From Bteq or SQL Assistant:

sel * from dbc.dbcinfo;

 *** Query completed. 3 rows found. 2 columns returned. 

 *** Total elapsed time was 1 second.

InfoKey                        InfoData

------------------------------ --------------------------------------------

VERSION                        15.10.00.09    <=== Database Version

LANGUAGE SUPPORT MODE          Standard

RELEASE                        15.10.00.09    <=== PDE Version