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

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 < 2 > 3 4 5 6 7 8 .. 218 >> Next

Teradata RDBMS Database Administration 1 - 1 Preface



December 2002 (continued)

Developed new chapter, Chapter 15: "Managing Resources", to group and document new and enhancements tools, including: Cylinder Read, which can read all cylinder-resident blocks with a single I/O rather than one block at a time. A new Priority Scheduler Administrator GUI and enhancements to Priority Scheduler

Increased capability of TDQM

Administrative considerations of partitioning and partitioned primary indexes (PPI), which allows rows to be distributed as usual but stored in partitions on each AMP based on some set of columns, then ordered by hash within that partition

Priority Scheduler enhancements, including capacity on demand and Priority Scheduler Administrator (PSA) Reconfiguration enhancements, including MOVE operation, time estimator, and status report

Implementation of user-level security control

Remove limits on maximum lockout duration of a user

Create and implement roles and profiles

Change implementation of privileges granted to PUBLIC

Developed new section for Global Defaults, providing an overview of the system defaults and administrative global controls

Developed a new subsection for the internationalization enhancements, enabling local formatting of various data types, including date and monetary symbols

ResUsage enhancements, including number of statements and transactions, transaction lock activity and impact, new fields for Cylinder Index

Value-list compression of multiple values in the same column, in an unlimited (except by row length) number of columns.

Soft and batch referential integrity, where you can specify that the constraint is to be ignored, or that checking is to be performed on qualified rows within a transaction Identity column, using a system-generated, table-level unique number for the column value in every inserted row. The insertion may be a single or a bulk insert operation.

Resource Check Tools improvements Stored procedure enhancements

Enhancements to data captured in LogonSource field of DBC.SessionInfo view, including application and user names Increase in DBC.Crashdumps size recommendations from 100 MB to 500 MB (with fallback)

Teradata RDBMS Database Administration Preface

Date Description
December 2002 (continued) Redefined owner, creator, automatic, implicit, and explicit privileges Described ARC capability of BakBone NetVault software
July 2001 New work on this book for V2R4.1 includes: Developed new chapter, Chapter 12: "Troubleshooting" Developed new "Database Initialization" material, Appendix E Developed all new material for dumps on Windows 2000 Condensed ResUsage and Priority Scheduler descriptions, eliminating redundancies and two appendices General reorganization, rewrite, reformatting to enhance usability New or enhanced features reflected in this book for V2R4.1 include: New SHOWFSP command of Ferret utility for determining candidates for disk packing Increased number of volatile tables to 1,000 Increased number of instances of materialized global tables to 2,000
June 2001 ResUsage can report by GroupID for differing node groups on a Teradata RDBMS co-existence configuration New Resource Check Tools, dbschk and syscheck, for determining the state of Teradata RDBMS Support for Single Sign On capability so passwords do not need to be sent over the network Ability of ARC COPY command to replace creatorname Effects of new Battery Status value, set via ctl/xctl utilities New HASH INDEX syntax and processing support Improved use of single-table, partial-covering join index Much of the capability of Database Query Manager (DBQM) ported from client to Teradata RDBMS Change to implementation of Query Capture Feature (QCF)
September 2000 Reorganization and rewrite
June 2000 First publication

Teradata RDBMS Database Administration Preface

About This Book

About This Book


This book discusses the administration of the disks and software components, and creation, administration, and security of the relational objects such as databases, tables, views, macros, triggers, indexes, and stored procedures, that make up your Teradata Relational Database Management System (RDBMS).

Teradata RDBMS Database Administration is not a tutorial. The NCR Customer Education department provides courses on Teradata database administration among its offerings. You can visit the NCR Customer Education home page at to review or enroll in courses.


This book is intended for Database Administrators (DBAs) who are

maintaining the Teradata RDBMS configuration and data. It is also useful for

Teradata RDBMS security administrators and operations control users.

How This Book Is Organized

This book contains the following chapters:

Chapter 1: "Database Hierarchy" describes the objects in the hierarchy of the Teradata RDBMS. It is assumed that hardware configuration and software installation have been completed.
Previous << 1 < 2 > 3 4 5 6 7 8 .. 218 >> Next