All Forums Teradata Database on AWS
au185006 32 posts Joined 12/12
31 Mar 2016
How can I tell what version the database I have?
dknham 9 posts Joined 06/15
31 Mar 2016

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

ac110057 16 posts Joined 07/11
31 Mar 2016

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

 

 

You must sign in to leave a comment.