Database Administration | Teradata Vantage - Introduction - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

Using the Database Administration Content

Teradata Vantage™ - Database Administration covers the basics of database administration, giving you the essential tasks and the procedures for doing them. Sections in this document are either designed for all DBAs or split tasks into two major groupings indicated in the section title: those for application DBAs, who are concerned with the design and performance of queries, and administrative DBAs, who are responsible for the day-to-day operation and maintenance of the Teradata Vantage™ system.

Why Would I Use this Content?

Database administrators use this content to perform a variety of administrative tasks. For example:
  • Configure databases, users, roles, and profiles
  • Create tables and views
  • Create stored procedures and user-defined functions
  • Load and export data
  • Use Database Query Logging (DBQL) to track query statement counts and response times, and make refinements to workload groups and scheduling, and so on
  • Learn about administrative tools to troubleshoot problems

How Do I Use this Content?

If you are configuring a new Vantage system, start at the with Setting Up Your Administrative Environment: All DBAs and proceed through the rest of the content to set up your system. If Vantage is already configured, select a topic related to what you want to do.

References to Other Relevant Content

These publications are directly related to the information in this document:
  • Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
  • Teradata Vantage™ - Database Utilities, B035-1102
  • Teradata Vantage™ - Analytics Database Security Administration, B035-1100
  • Teradata Vantage™ - Data Dictionary, B035-1092
It may be helpful to review these publications:
  • Teradata Vantage™ - Database Introduction, B035-1091
  • Teradata Vantage™ - Database Design, B035-1094
  • Teradata Vantage™ - SQL Fundamentals, B035-1141