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 .. 55 56 57 58 59 60 < 61 > 62 63 64 65 66 67 .. 76 >> Next

DIP Executes one or more of the standard DIP (Database Initialization Program) SQL scripts packaged with the RDBMS
XPT Installs multiple copies of the same software across all nodes of an MPP system. XPT is not valid on single node systems.
xperfstate Provides real time display of PDE system performance, including system-wide CPU utilization and disk utilization.

Introduction to the Teradata RDBMS for UNIX

12-23
System Administration

For More Information

For More Information

For more information on the topics presented in this chapter, see the following Teradata RDBMS manuals.

IF you want to learn more about . . . THEN see this manual . . .
System administration in general Teradata RDBMS for UNIX Database Design and Administration
Performance monitoring Teradata RDBMS for UNIX Resource Usage Macros and Tables Teradata RDBMS for UNIX Performance Monitor Reference
The Teradata Manager Teradata Manager for the Teradata RDBMS on UNIX User’s Guide

12-24

Introduction to the Teradata RDBMS for UNIX
Operating and Configuration Specifications

Chapter 13

Operating and Configuration Specifications

Introduction to the Teradata RDBMS for UNIX
Operating and Configuration Specifications

Introduction to the Teradata RDBMS for UNIX
Operating and Configuration Specifications

About This Chapter

Introduction

About This Chapter

This chapter is a compendium of operation and configuration issues you need to consider when installing and using a server that runs the Teradata RDBMS.

Topics described include:

• Performance

• Database capacities

• Storage capacity

• Channel-attached client requirements

• Network-attached client requirements

Introduction to the Teradata RDBMS for UNIX

13-1
Operating and Configuration Specifications

Performance

Introduction

Scalability

Performance

This topic describes very broad guidelines for increasing performance on your NCR System systems.

Each MPP system is certified to support as many as 32 nodes. More nodes can be added on a custom basis.

The general rule is to consult your NCR Global Information Solutions representative.

The word to remember is scalability. The NCR massively parallel systems are designed to scale performance nearly linearly with increased nodes.

13-2

Introduction to the Teradata RDBMS for UNIX
Operating and Configuration Specifications

Database Capacities

Database Capacities

Introduction

This topic describes the data storage capacities for the Teradata RDBMS servers.

Teradata RDBMS Capacities

The following table lists the database capacities of the Teradata servers.

Category Capacity
Maximum number of databases 32,000
Maximum number of tables per database 32,000
Maximum number of columns per table 256
Maximum row length in bytes 32,000
Maximum name length in characters 30
Maximum number of fields per index 16
Maximum number of primary index per table (clustered) 1
Maximum number of secondary indexes per table (unclustered) 32

Introduction to the Teradata RDBMS for UNIX

13-3
Operating and Configuration Specifications

IBM Channel-Attached Client Requirements

IBM Channel-Attached Client Requirements

This topic supplies information about supported IBM mainframe IntroduCtion clients. For information about hardware requirements for other

mainframe clients, see the appropriate platform-specific documentation.

The following table lists the hardware and software requirements Supported Environments for IBM and plug compatible clients to support the Teradata

environment.

Mainframe Client Hardware Operating Systems Transaction Processing Monitors Application Languages
• 370/148 with DAT • OS/VS-MVS, • CICS 1.6 and • Preprocessor2:
• 370/155 with DAT Release 3.8 and above • ANSI COBOL,
• 370/158 above, including • TSO X3.23-1974
• 370/168 MVS/SP Release 1 • CMS • PL/I
• 370/303X • 370/308X • 370/309X or 2. SP Release 1.3 is required for CICS • CLI: • COBOL • FORTRAN
• 370/43XX • Plug compatibles • • support MVS/XP VM/SP Release 3 • Pascal • PL/I •C • Assembler • any language with a CALL statement
and above

13-4

Introduction to the Teradata RDBMS for UNIX
Operating and Configuration Specifications

Network-Attached Client Requirements

Network-Attached Client Requirements

You can access the Teradata RDBMS through a network-attached client interface. Both hardware and software are required to make an interface from the network-attached client to the Teradata RDBMS. The interface software consists of one portion residing on the Teradata server and another portion residing on each network-attached client that is communicating with the Teradata RDBMS.

The following table lists software environments supported for the Teradata RDBMS in a network-attached client environment.

NCR Interface Software Environment
CLIent for DOS MS-DOS 3.2 or higher
Teradata Omni Access Module for Teradata RDBMS This interface supports Sybase access to the Teradata RDBMS UNIX SunOS 4.2x AT&T 3000 UNIX and COP interface software, Release 4.1 or higher.
Previous << 1 .. 55 56 57 58 59 60 < 61 > 62 63 64 65 66 67 .. 76 >> Next