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 .. 15 16 17 18 19 20 < 21 > 22 23 24 25 26 27 .. 76 >> Next


Database Window Communication

Introduction to the Teradata RDBMS for UNIX

2-33
Teradata RDBMS Architecture

Database Window

Functions Provided by the Database Window

Supervisor Subwindow

Utilities Available from the Supervisor Subwindow

Supervisor Commands Available from the Database Window

The system console provides all of the following functions:

• Displays system status

• Displays the current system configuration

• Displays performance statistics

• Controls various AMP utilities

The DBW has a main window and several subwindows. The principal subwindow, called the Supervisor Subwindow, permits an operator to run utilities and enter various commands.

Many utilities used to control, monitor, and configure the RDBMS are available from the Supervisor subwindow. A partial list of the utilities invoked from the DBW is provided in Chapter 12, “System Administration,” in the section “System Utility Software.”

The following table lists the commands available from the Supervisor Subwindow of the Database Window.

Command Function
CNSGET Displays the setting for the CNS variables.
CNSSET DBWTIMEOUT Sets how often the CNS checks the connection between the CNS and the DBW.
CNSSET LINES Sets the number of lines that are saved and available to you in the output display area after a reconnect to the CNS.
CNSSET STATEPOLL Sets how often the CNS checks the RDBMS state and substate.
CNSSET TIMEOUT Sets the interval between the time you type a request and the time the DBW rejects it because a program did not solicit the input.
DISABLE LOGONS Prevents new sessions from logging on.
ENABLE LOGONS Restores the ability of new sessions to log on.
GET CONFIG Displays the current system configuration.
GET LOGTABLE Displays the status of logging to the specified resource usage tables.
GET RESOURCE Displays the resource collection and logging rates, and the memory clearing rate of a vproc or node.
GET TIME Displays the current date and time.
GET VERSION Displays the PDE and RDBMS version numbers.

2-34

Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

Database Window

Command Function
LOG Logs the specified text into the errorlog.
QUERY STATE Displays the current state of the RDBMS.
RESTART TPA Restarts the RDBMS.
SET LOGTABLE Enables or disables logging to the specified resource usage tables.
SET RESOURCE Sets the resource collection and logging rates, and the memory buffer clearing rate of a vproc or node.
START Starts a RDBMS utility in a DBW application subwindow.
STOP Stops a RDBMS utility in a DBW application subwindow.

Introduction to the Teradata RDBMS for UNIX

2-35
Teradata RDBMS Architecture RDBMS Gateway

RDBMS Gateway

The RDBMS Gateway maps the external network protocols onto the internal database message protocols. It is a server program that provides a pathway for applications running on a network-connected client to access the Teradata server.

The RDBMS Gateway also permits clients running locally to communicate with the Teradata RDBMS.

There is one RDBMS Gateway per machine, controlling up to 600 sessions per node.

2-36

Introduction to the Teradata RDBMS for UNIX
Teradata RDBMS Architecture

Database Utility Software

Database Utility Software

Database utilities are used to perform maintenance functions on the Teradata RDBMS.

They are invoked from the Database Window with the following exceptions:

Utility Name Runs under . . .
xmppconfig UNIX as an application.
pdeconfig UNIX as an application.
DIP control of BTEQ as well as the Database Window.
XPT UNIX as an application.
xperfstate UNIX as an application.

The system utilities include:

Utility Name Function
AbortHost Aborts outstanding transactions.
Checktable Checks for table inconsistencies.
Config Specifies logical database configuration (AMPs and PEs).
XCTL Displays and modifies the fields of the Control Parameters Globally Distributed Objects (GDO) of the Parallel Database Extension (PDE) software. Accessed from an xterm window.
DBSControl Specifies global runtime flags for database software.
VprocManager Provides status for vprocs and permits manipulation of their attributes.
GtwGlobal Manages LAN connections.

Introduction to the Teradata RDBMS for UNIX

2-37
Teradata RDBMS Architecture

Database Utility Software

Utility Name Function
Ferret Displays and sets various disk space utilization attributes without destroying the data for which the File System is responsible. For new attributes, Ferret reconfigures the stored data dynamically to match them. Utilities running under Ferret include the following: • Scandisk • Showspace • Packdisk
Filer Displays information used to correct problems within the File System.
pdeconfig Allocates PE and AMP vproces to physical resources, including all of the following: • Configuring disk arrays • Assigning logical units (LUNS) to the disks • Allocating disks to AMPs • Allocating LANs and channels to PEs Always run xmppconfig before running pdeconfig.
Previous << 1 .. 15 16 17 18 19 20 < 21 > 22 23 24 25 26 27 .. 76 >> Next