16.10 - Software Components - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)

The following figure illustrates the software components in mainframe-attached clients that play important roles in getting requests to and from Teradata Database.

The following table describes these software components.

Component Description
Client application
  • Written by a developer in your company
  • Written under contract to you by Teradata
  • One of the Teradata Database-provided utilities

Users use these applications to submit SQL statements, maintain files, and generate reports.

For details on supported programming languages, the Teradata Preprocessor2, and embedded SQL requirements, see Teradata Preprocessor2 for Embedded SQL Programmer Guide .

CLIv2 A low-level interface to Teradata Database. It consists of system calls that:
  • Create sessions
  • Allocate request and response buffers
  • Create and deblock parcels of information
  • Fetch response information for the requesting client.

For more information, see Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems or Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems .

TDP Manages communication between mainframe clients and Teradata Database. Functions include:
  • Session initiation and termination
  • Logging, verification, recovery, and restart of client applications
  • Physical input to or output from PE vprocs
  • Security
  • Session balancing across multiple PEs
  • Control of the default client character set to be used during sessions originating through this TDP (unless overridden by the user with a BTEQ.SET SESSION CHARSET command)

See TDP Functionality and Teradata Director Program Reference.