Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 182 183 184 185 186 187 < 188 > 189 190 191 192 193 194 .. 218 >> Next


A - 26 Teradata RDBMS Database Administration

Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

TDP Functionality

IF the item is ... THEN the available commands are .
AUTHORIZ USERID
ALL
JOB
SAF MODIFY
DISABLE
ENABLE
CHANNEL PROCESSORS DISPLAY
SESSION PROCESSORS DISPLAY

A - 26

Teradata RDBMS Database Administration Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

Channel Environment

Network Environment

In a network environment, each workstation on the network has a copy of Teradata software, including the utilities, programs, and drivers needed to access the Teradata database.

Functionality

The three elements that comprise the Teradata Client Software in a LAN-attached environment are:

• MTDP—Micro Teradata Director Program

• CLI—Call Level Interface

• MOSI—Micro Operating System Interface

In a network environment, MTDP and gateway software in the node handle the functions that TDP handles in a channel-attached environment.

A network interface card connects workstations directly to the network, and an Ethernet card in the MCA bay connects the network directly to a node. These connections provide workstation access to the gateway software in the node.

Redundancy is provided with two separate connections to the network. There are two network cards in the MCA bay and two Ethernet cables to the network.

Software Components

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

Teradata RDBMS Database Administration

A - 23 Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

Channel Environment

Network-Attached System

KY01A024

The following table describes these software components.

Component Description References
Client application Either: • Teradata Preprocessor2
• Written by a developer in your Programmer Guide
company • Teradata Application
• Written under contract to you Programming
by NCR
• One of the Teradata RDBMS-
provided utilities
Users use these applications to
submit SQL statements, maintain
files, and generate reports.

A - 32

Teradata RDBMS Database Administration A - 23 Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

Channel Environment

Component Description References
Teradata call-level interface (CLI) A low-level interface to the Teradata RDBMS, CLI consists of routines that perform functions similar to CLI system calls on channel-attached clients, including: • Logging sessions on and off • Submitting SQL queries • Receiving responses with the answer set • Teradata Call-Level Interface Version 2 Reference for Network-Attached Systems • Teradata Call-Level Interface Version 2 Developer Kit for Microsoft Windows
Micro Teradata Director Program (MTDP) Library of session management routines that perform for network-attached clients many of the TDP functions, such as session control and parcel transmission. • Teradata Call-Level Interface Version 2 Reference for Network-Attached Systems • Teradata Call-Level Interface Version 2 Developer Kit for Microsoft Windows • Teradata Preprocessor2 Programmer Guide • Teradata Warehouse Builder Operators Programmer Guide
Micro Operating System Interface (MOSI) Library of routines that provide operating system independence for client access to the Teradata RDBMS. • Teradata Call-Level Interface Version 2 Reference for Network-Attached Systems • Teradata Call-Level Interface Version 2 Developer Kit for Microsoft Windows • Teradata Warehouse Builder Operators Programmer Guide • Teradata Driver for the JDBC Interface User Guide
Database connectivity drivers A variety of drivers for open connectivity products, such as ODBC and JDBC. • Teradata Driver for the JDBC Interface User Guide

Teradata RDBMS Database Administration

A - 23 Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

The Network Gateway

The Network Gateway

The gateway software is the interface between the network and the Teradata RDBMS. It runs on the Teradata RDBMS server as a separate operating system task. Client sessions that communicate through the gateway to the Teradata RDBMS may be resident on the NCR server, or may be installed and running on network-attached workstations.

In contrast, sessions originating from a channel-attached mainframe access the Teradata RDBMS through channel connections and TDP software, and bypass the gateway completely.

Tools are available to administer your Teradata Gateway, including:

Tool Name Function
Gateway Control Globally Distributed Object GTWCONTROLGDO Defines the current values of gateway defaults throughout all nodes in the Teradata RDBMS configuration.
Gateway Control Utility gtwcontrol Recommended for use only by your NCR field support engineer, to: • Control the defaults in the Gateway Control GDO, such as the number of sessions per gateway. (Typically, these are set only by an NCR field support engineer.) • On a Windows 2000 installation, the SET SSO command and -F flag determine how you define the names of Teradata users and how they log on. For details, see: - "Implementing Single Sign On (SSO) (Windows 2000 Only)" on page 6-25 - "Diagnosing SSO Logon Errors (Windows 2000 only)" on page 12-14
Previous << 1 .. 182 183 184 185 186 187 < 188 > 189 190 191 192 193 194 .. 218 >> Next