After deploying the database, verify the database is accessible and responsive.
- Start BTEQ. No additional installation is required. BTEQ is installed on the Teradata Database (TPA) node for Teradata Database on VMware.
- Using the default credentials, log on to the database.
-
Run select * from dbc.dbcinfo to see if the database is responding.
Sample result indicating response:
sel * from dbc.dbcinfo; *** Query completed. 3 rows found. 2 columns returned. *** Total elapsed time was 1 second. InfoKey InfoData –-------------------------------------- VERSION 16.20.xx.xx RELEASE 16.20.xx.xx LANGUAGE SUPPORT MODE Standard
- If the database does not respond, access the server through SSH.