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

Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR

NCR Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR, 1998. - 315 p.
Download (direct link): inntroduktionteradata1998.pdf
Previous << 1 .. 14 15 16 17 18 19 < 20 > 21 22 23 24 25 26 .. 76 >> Next

PL/I IBM mainframe clients
COBOL • IBM mainframe clients
• Selected workstation clients
C • IBM mainframe clients
• UNIX clients

The Call-Level Interface (CLI) is an application programming Call-Level Interface 2 interface that provides facilities that enable any client application

programming language that supports a CALL statement to query the Teradata RDBMS.

The CLI is also supported directly on NCR servers running the Teradata RDBMS.

A Windows®-based version of CLI, called WinCLI, is also available.

Introduction to the Teradata RDBMS for UNIX

2-29
Teradata RDBMS Architecture

Application Programming Facilities

ODBC

Open Database Connectivity (ODBC) is an industry standard application programming interface you can use with Microsoft Windows®, Windows® NT, and Windows 95 to make SQL queries against a Teradata RDBMS database.

The ODBC Driver for Teradata RDBMS provides Core-level SQL and Extension-level 1 (with some Extension-level 2) function call capability using the Windows® Sockets (WinSock) TCP/IP communications software interface.

An additional software package, the Database Query Manager, permits the Teradata RDBMS to manage requests from applications running under Windows®, Windows® NT, and Windows® 95 using ODBC.

ODBC operates independently of CLI and WinCLI.

2-30

Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

Archiving and Data Loading Utilities

Archiving and Data Loading Utilities2

Introduction

The Teradata RDBMS provides several utilities for archiving and restoring the database and for data loading. Data loading utilities are typically used in a decision support environment where the client machine gathers data during the day and dumps it to the server over night. This topic briefly describes these utilities.

Archive and Restore Utility and ASF2

The Archive and Restore utility and the Archive Storage Facility (ASF2) support archiving of databases, individual tables, or permanent journals to any of the following media:

• 3500/4500/5100 tape (ASF2 only)

• Client tape

• Client file

The utility also restores databases from those archival media to the Teradata RDBMS.

Archive and Restore is supported in the MVS and VM environments only.

BulkLoad

The BulkLoad utility permits batch insert, update, and delete operations on an existing database. The program moves large quantities of data from a client to the Teradata RDBMS on the server.

BulkLoad is supported in the MVS and VM environments only.

The FastLoad utility permits you to load unpopulated tables only. FastLoad 2 The program is similar to BulkLoad except that it runs much faster

and does not support update and delete operations.

FastLoad is supported in both the client and server environments.

The MultiLoad utility loads large quantities of data into unpopulated tables. MultiLoad also supports bulk inserts, updates, and deletions against populated tables.

MultiLoad is supported in both the client and server environments.

The FastExport utility exports large quantities of data from the FastExport 2 Teradata RDBMS to a client and is the functional complement of the

FastLoad and MultiLoad utilities.

Introduction to the Teradata RDBMS for UNIX

2-31
Teradata RDBMS Architecture

Administrative Workstation

Administrative Workstation

The Administrative Workstation (AWS) performs many of the functions of a system console for multinode Teradata RDBMS systems.

Single node systems do not have an AWS.

It is an intelligent workstation attached to an SMP node and its primary roles are to:

• Monitor system performance

• Provide an input mechanism for the system administrator.

2-32

Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

Database Window

Database Window

The console software for the Teradata RDBMS for UNIX is called the Introduction Database Window (DBW). It runs in the following X windows

environments:

• System console

• Administrative workstation (AWS)

• Remote workstation or PC

The Database Window provides an interface to all the following windows:

• Supervisor

• Database Message

• Application Windows (including any currently active support utilities)

Some of the workstation types are available only on specific

Workstation Types and platforms.

Available Platforms 2

The following table shows which workstations are appropriate for the different platforms and how they are connected to the node.

Type of Workstation Platform Description
System console SMP Connected directly to the SMP node
Administrative workstation MPP LAN-connected through an Ethernet card on the node. The AWS provides a single operational view of the multiple-node system.
Remote connection through LAN: • UNIX workstation • PC with X Windows server Both LAN-connected through an Ethernet card on the node.

The DBW communicates with the Teradata RDBMS through the console subsystem (CNS), which is part of the PDE. Because the DBW is managed by the CNS, you will occasionally see CNS messages in the DBW.
Previous << 1 .. 14 15 16 17 18 19 < 20 > 21 22 23 24 25 26 .. 76 >> Next