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


AMPs.............................................................................................................................D-2

System Disks ................................................................................................................ D-2

Pdisks ............................................................................................................................ D-2

Vdisks............................................................................................................................D-2

LAN Connection.......................................................................................................... D-3

Gateway........................................................................................................................ D-3

Channel Connection.................................................................................................... D-3

Channel Driver ............................................................................................................ D-3

PEs.................................................................................................................................D-3

Memory.........................................................................................................................D-3

BYNET...........................................................................................................................D-3

Vnet................................................................................................................................ D-3

Resource Check Tools....................................................................................................D-4

PM/API Dynamic Data.................................................................................................D-6

How PM/API Collects Data......................................................................................D-6

Collecting and Reporting Processor (node/vproc) Data.......................................D-6

xxviii Teradata RDBMS Database Administration Contents

Collecting and Reporting Session-level Usage Data..............................................D-7

Teradata Performance Monitor....................................................................................D-8

Monitoring Capabilities..............................................................................................D-8

Starting MONITOR.....................................................................................................D-8

ABORT SESSION Command.....................................................................................D-9

ResUsage Reports.........................................................................................................D-11

Using the Reports......................................................................................................D-11

Reporting Capability.................................................................................................D-11

TDP Transaction Monitor............................................................................................D-14

Appendix E: Database Initialization

Database Initialization Program (DIP).........................................................................E-2

The DIP Utility..............................................................................................................E-2

The DIP SQL Script Files.............................................................................................E-2

Index..........................................................................................................................Index-1

xxviii

Teradata RDBMS Database Administration Chapter 1:

Database Hierarchy

This chapter describes the objects in the hierarchy of the Teradata Relational Database Management System (RDBMS).

Note: Because this book concentrates on Teradata RDBMS administration, it assumes that software installation and resource configuration have been completed.

Topics discussed include:

An overview of the database hierarchy

The initial Teradata database and the database administration user

Databases versus users

Owners, parents, children, and the creator versus the owner

Changing the hierarchy with GIVE

Deleting and dropping objects

Teradata RDBMS Database Administration

1 - 1 Chapter 1: Database Hierarchy

Database Hierarchy Overview

Database Hierarchy Overview

Initially, the special system user DBC owns all space in the Teradata Database. Some space is assigned from DBC to the system users and databases named SysAdmin, SystemFE, Crashdumps, and Sys_Calendar.

Everyone higher in the hierarchy is a parent or owner. Everyone lower in the hierarchy is a child.

Every object has one and only one creator. The creator is the user who executes the CREATE statement.

Previous << 1 .. 14 15 16 17 18 19 < 20 > 21 22 23 24 25 26 .. 218 >> Next