- To confirm that the database is up, type: # pdestate -aFor 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:~ #
- At the shell prompt, type bteq.
- At the log on prompt, type:.logon 127.0.0.1/dbc
- At the password prompt, type dbc.If successful, the Basic Teradata Query (BTEQ) session reports that you are logged into BTEQ.
- Run the SQL test script by typing the following:select * from dbc.dbcinfo;A successful test returns: *** Query completed.
- To quit BTEQ, type .quit.