Test the Database Installation - Teradata Vantage Express

Teradata Vantageā„¢ Express Installation and Configuration Guide

Product
Teradata Vantage Express
Release Number
20.00
Published
December 2025
ft:locale
en-US
ft:lastEdition
2025-12-19
dita:mapPath
zwx1745870081921.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
gvq1467245026747
Product Category
Cloud
  1. To confirm that the database is up, type: # pdestate -a
    For example:
    VantageExpress20.00_Sles15:~ # pdestate -a
    PDE state is RUN/STARTED.
    DBS state is 5: Logons are enabled - The system is quiescent
    VantageExpress20.00_Sles15:~ #
  2. At the shell prompt, type bteq.
  3. At the log on prompt, type:
    .logon 127.0.0.1/dbc
  4. At the password prompt, type dbc.
    If successful, the Basic Teradata Query (BTEQ) session reports that you are logged into BTEQ.
  5. Run the SQL test script by typing the following:
    select * from dbc.dbcinfo;
    A successful test returns: *** Query completed.
  6. To quit BTEQ, type .quit.