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.10.xx.xx RELEASE 16.10.xx.xx LANGUAGE SUPPORT MODE Standard
- If the database does not respond, access the server through SSH.
-
If you cannot access the server, see the appropriate Knowledge Article.
For more information, log in to https://access.teradata.com and search for
- Teradata Database single-node systems: Knowledge Article KAC13A25E
- Teradata Database MPP systems: Knowledge Article KAC13D39E