15.10 - Glossary - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

2PC

Two-Phase Commit

AMP

Access Module Processor

API

Application Program Interface

ARC

Teradata Archive/Recovery Utility

BTEQ

Basic Teradata Query

CLI

Call Level Interface

CLIv2

Call Level Interface, Version 2

COD

Capacity on Demand

DBS

Database System or Database Software

DBW

Database Window

DSS

Decision Support System

FE

Field Engineer

HSI

Host System Interface

HUT

Host Utility

I/O

Input/Output

IPE

Incremental Planning and Execution

LSN

Logon Sequence Number

MPP

Massively Parallel Processing

OLTP

Online Transaction Processing

PDE

Parallel Database Extensions

PE

Parsing Engine

PMPC

Performance Monitor and Production Control

PRPD

Partial Redistribution and Partial Duplication

ResUsage

Resource Usage

RSS

Resource Sampling Subsystem. The RSS provides a method to gather statistics from across the Teradata Database system, and provides the ability to access the statistics through an API. Resource usage uses the RSS data from the RSS API to log data to the selected resource usage tables.

SLES

SUSE Linux Enterprise Server

SLG

Service Level Goals

SMF

System Management Facility

SMP

Symmetric Multi-Processing

Tactical Workload Management Method

This workload yields the fastest available response time and executes at the highest tier, preempting all resource needs of other tiers. This method is well suited for critical, short-running queries that require fast response times. For more information, see Teradata Viewpoint User Guide.

TDP

Teradata Director Program

TDWM

Teradata Dynamic Workload Management

TASM

Teradata Active System Management. TASM is a set of products, including system tables and logs, that interact with each other and a common data source. It helps manage the system automatically and reduces the effort required by database administrators, application developers, and support personnel. TASM can improve and optimize your workload management and performance. It can also improve response times and ensure more consistent response times for critical work.

Timeshare Workload Management Method

This workload can be assigned to one of four stepped access levels, Top, High, Medium, or Low. The higher access levels are given larger access rates than the lower levels. For example, an SQL request assigned to a Timeshare WD with a Top access level, which has an access rate of 8, would receive eight times the amount of resources than an SQL request assigned to a Low access level.

Timeshare workloads are assigned resources remaining after all allocations have been made for tactical and Workload Share Percent workloads. For more information, see Teradata Viewpoint User Guide.

TSR

Tequel Start Request

vproc

Virtual Processor

Workload Share Percent Management Method

This workload is assigned a proportion of the resources that are available after allocations have been made for tactical workloads. The percentage of resources is divided equally between all requests running in the WD. For example, if the Workload Share Percent is 5% and there are five SQL requests, each SQL request will get 1% of the share resources. For more information, see Teradata Viewpoint User Guide.

WQM

Workload Query Manager