第1页 / 共270页
第2页 / 共270页
第3页 / 共270页
第4页 / 共270页
第5页 / 共270页
第6页 / 共270页
第7页 / 共270页
第8页 / 共270页
teradata manager user guide.pdf
Teradata Manager
User Guide
Preface
Purpose
Audience
Supported Releases
Prerequisites
Changes to This Book
Additional Information
Table of Contents
Chapter 1 Before You Begin
Where to Find Answers
Getting an Overview of Teradata Manager
Getting Help with Installation, or Viewing Program Fixes
Getting Instructions for Specific Tasks
Getting Help From Teradata Manager
Chapter 2 Late-Breaking News, Online Support and Related Documentation
Getting Help With Installation
Getting Information on Program Fixes and Change Requests
Finding Related Documentation
Chapter 3 Getting Started With Teradata Manager
What Is Teradata Manager?
Monitoring in Real Time: The Teradata Manager Dashboard
Investigating System Logs and Alerts
Analyzing Trends in Resource Usage
Administering Various Aspects of the Database
Finding Your Way Around the Teradata Manager Interface
File Menu
Edit Menu
Options Menu
Monitor Menu
Investigate Menu
Analyze Menu
Administer Menu
Window Menu
Help Menu
Teradata Manager File Locations
Printing or Saving the Currently Displayed Report or Graph
Creating a Batch Version of a Teradata Manager Report
Chapter 4 Configuring Teradata Manager
Step 1 - Creating the Teradata Manager Databases, Tables, and Macros
Setting Up Coexistence Systems
Step 2 - Adding Teradata Manager Users
Alternative to Steps 1 and 2 - Using the Setup Script Instead of Database Setup
Step 3 - Starting Teradata Manager
Step 4 - Restricting User Access with Profiles
Step 5 - Authorizing User Access to Profiles
Step 6 - Defining System Parameters
Step 7 - Enabling Data Collection
Perm Space Requirements for Historical Trend Data Collection
Configuring AMP Usage Data Collection Parameters
Configuring DBQL Data Collection Parameters
Configuring Dynamic Workload Management Data Collection Parameters
Configuring Heartbeat Query Data Collection Parameters
Configuring Priority Scheduler Data Collection Parameters
Configuring Resource Usage Data Collection Parameters
Configuring Spool Space Data Collection Parameters
Configuring Table Space Data Collection Parameters
Configuring Your Color Display Options
Checking the Status of the Teradata Manager Server
Teradata Manager Service Registration
Changing to a Different Teradata Manager Server
Choosing a Teradata Manager Profile
Restoring the Default Preferences
Adding Application Specific Entries to the Registry
Application Specific Entry Example
Adding Additional Applications to the Teradata Manager Menu Bar
Chapter 5 Configuring the SNMP Agent
The Teradata Manager Alerts SNMP MIB
MIB Object Structure
Viewing SNMP MIB Objects with CA Unicenter TNG Framework
Adding the Teradata Manager MIB to the CA Unicenter TNG Framework
Creating a Graph Using Unicenter TNG
SNMP Troubleshooting Tips
Install Teradata Manager as an Administrator
Configuration
The Trap Daemon
Set the System PATH Environment Variable on Windows 2000
Chapter 6 Monitoring Real-Time System Activity
Monitoring Overall System Activity Using the Dashboard
Viewing the Dashboard
Dashboard Display Contents
Getting History Data Details
Summary Graph Contents
Monitoring Virtual Utilization
Vproc Utilization Report Contents
Getting Virtual Utilization Details
Vproc Utilization Detail Report Contents
Monitoring Physical Utilization
Node Utilization Report Contents
Getting Physical Utilization Details
Node Utilization Detail Report Contents
Monitoring Session Status
Session Status Report Contents
Getting Session Details
Session Detail Report Contents
Modifying Session Priority
Session Priority Attributes
Aborting Sessions
Abort Session Report Contents
Viewing What the Selected Session is Blocking
Blocking Sessions Report Contents
Viewing What the Selected Session is Blocked By
Blocked By Report Contents
Monitoring Delay Queue Statistics
Workload Delay Queue Statistics Report Contents
Monitoring Object Logon Statistics
Object Logon Statistics Report Contents
Monitoring Object Query Statistics
Object Query Statistics Report Contents
Monitoring the Object Delay Queue List
Object Delay Queue List Report Contents
Using Performance Monitor (PMON)
Using Session Information
The Graph Legend
Chapter 7 Monitoring the Delay Queue
Viewing a Snapshot of the Workload Delay Queue
Getting Workload Delay Queue Details
Workload Delay Queue Detail Report Contents
Viewing Workload Delay Queue History
Workload Delay Queue History Report Contents
Viewing and Releasing Requests in the Workload Delay Queue
Workload Delay Queue Session List Contents
Chapter 8 Analyzing Workload Trends
Analyzing CPU Utilization
CPU Utilization Report Contents
Analyzing Disk I/O Utilization
Disk I/O Utilization Report Contents
Analyzing Table Growth
Table Growth Report Contents
Analyzing Spool/Temp Space Usage
Spool/Temp Space Usage Report Contents
Analyzing Heartbeat Query Response Time
Response Time Report Contents
Analyzing User Count
User Count Report Contents
Analyzing Resource Usage Trends
Resource Usage Report Contents: CPU Usage
Resource Usage Report Contents: Disk Usage
Resource Usage Report Contents: Memory Usage
Resource Usage Report Contents: Bynet Usage
Resource Usage Report Contents: System Utilization
Analyzing DBQL Usage Trends
DBQL Usage Report Contents: Condition Indicator Count
DBQL Usage Report Contents: Response Time
DBQL Usage Report Contents: Resource Usage
DBQL Usage Report Contents: Parallelism
Analyzing DBQL Step Usage Trends
DBQL Step Usage Report Contents
Viewing the DBQL Summary Histogram
DBQL Summary Histogram Contents
Chapter 9 Analyzing Historical Resource Utilization
Analyzing Node CPU Utilization
Node CPU Utilization Report Contents
Analyzing AMP CPU Utilization
AMP CPU Utilization Report Contents
Analyzing PE CPU Utilization
PE CPU Utilization Report Contents
Analyzing Node Utilization
Node Utilization Report Contents
Analyzing Disk Utilization
Disk Utilization Report Contents
Analyzing Network (Bynet) Utilization
Network Utilization Report Contents
Analyzing Memory Utilization
Memory Utilization Report Contents
Analyzing Host Utilization
Host Utilization Report Contents
Non-Grouped Reports
Non-Grouped Report Contents
The History Query Filter
Chapter 10 Investigating Disk Space Utilization
Reallocating Disk Space
Move Space Fields and Controls
Transferring Database Ownership
Viewing Database Space Usage
Space by Database Report Contents
Viewing Space Usage By Table
Table Space Report Contents
Viewing Table Space Usage by Vproc
Table Space by Vproc Report Contents
Viewing the Create Table Statement
Viewing All Objects In a Database
Help Database Report Contents
Viewing Hierarchical Space Usage
Hierarchy Report Contents
Viewing Overall Space Usage by Vproc
Space by Vproc Report Contents
Viewing Cylinder Space by Vproc
Cylinder Space by Vproc Report Contents
Chapter 11 Investigating System Behavior
Investigating the Error Log
Investigating Logon Activity
Investigating Lock Contentions
Investigating System Performance Parameters
Chapter 12 Investigating the Audit Log
Before You Can Begin Creating Audit Reports
Setting the Audit Log Filter to Narrow Your Results
Auditing Database and User Activity
Audit Database and Users Activity Report Contents
Auditing Table, View and Macro Activity
Audit Table, View, Macro Activity Report Contents
Auditing Grant and Revoke Activity
Audit Grant and Revoke Activity Report Contents
Auditing Index Activity
Audit Index Activity Report Contents
Auditing Checkpoint, Dump and Restore Activity
Audit Checkpoint, Dump and Restore Activity Report Contents
Auditing Denials
Audit Denials Report Contents
Creating an Audit Summary Report
Audit Summary Report Contents
Creating a Custom Audit Report
Chapter 13 Using Teradata Priority Scheduler Administrator
Introduction to Priority Scheduler Administrator
Priority Definition Set Framework
About Resource Partitions
About Performance Groups and Allocation Groups
Overview of Priority Scheduler Components
About Resource Partitions
Resource Partition Parameters
Limiting Resource Partition CPU Usage
Suggestions for Using Resource Partitions
About Performance Groups
Performance Groups and Allocation Groups
Performance Group and Weight Defaults for Default Resource Partition
Performance Group Name
Performance Group Value
Performance Group Values in the Default Resource Partition
About Performance Periods
Performance Period Components
Performance Period Type and Milestone Limit
Time-of-day
Resource Usage
About Allocation Groups
Allocation Group Parameters
Set Type
Allocation Group Weight
Number of Active Users Affects Query Response Time
Scheduling Policy
Using Scheduling Policies
Step 1 - Starting the Teradata Priority Scheduler Administrator
Step 2 - Defining PD Set/Resource Partitions Parameters
Define the parameters in the PD Set/Resource Partitions panel
Priority Definition Set Parameters
Resource Partition Parameters (schmon -b)
Step 3 - Defining Performance Group Parameters
Define the parameters in the Performance Groups panel
Step 4 - Defining Allocation Groups Parameters
Define the parameters in the Allocation Groups panel
Viewing a Priority Definition Set Description
Viewing the Schmon Commands Used to Create a Priority Definition Set
Saving Priority Definition Set Information
Creating a New Priority Definition Set
Viewing Performance Data
Priority Scheduler Data Collector
Report Type and Time
Priority Scheduler Groups
Data Items
Viewing Session Information
Viewing a Session Report
Scheduling a Priority Definition Set
Comparing Relative Weights of Allocation Groups or Resource Partitions
Comparing Relative CPU Use of an Allocation Group or Resource Partition
Changing the Operating System Type
Defining Advanced PD Set/Resource Partition Parameters
Configuring the Priority Scheduler Administrator Display
Priority Scheduler Administrator Command Line Parameters
Chapter 14 Using Alerts to Monitor Your System
Introduction to the Alerts Facility
Creating a New Alert Policy
Defining Actions to the Policy
Physical Actions
Logical Actions
Defining Actions - Sending a Page
Defining Actions - Sending E-mail
Message Content
E-mail Alert Example
Configuring the System to Send E-mail Alerts
Before You Begin
The Configuration Procedure
Defining Actions - Running a Program
Command Line Parameters
Defining Actions - Running a BTEQ Script
Logon Information
Defining Actions - Generating an SNMP Trap
Set Up the Windows SNMP Service
Defining Actions - Action Lists
Defining Events to the Policy
Defining Events - Database Space
Defining Events - System Level Performance
Defining Events - Node Level Performance
Node Alerts and Non-TPA Nodes
Defining Events - Vproc Level Performance
Defining Data Collection Rates for the Policy
Applying the Policy to the Database
Displaying the Performance Status of the Database
Alerting on Teradata Event Messages From Teradata on Windows 2000
Alerts Examples
Sending a Text Page
Using Alerts for Session Management
Excluding Users from Alerts Monitoring
Using the AlertRequest Table
Using the MonitorRequest Table
Chapter 15 System Administration
Administering Workloads with Priority Scheduler Administrator
Administering Using the Database Console (Remote Console)
Administering System Alarms Using Alerts (Alert Policy Editor)
Administering Using the BTEQ Window
Administering Using Database Statistics (Statistics Collection)
Chapter 16 Using the Scheduler
How Does the Scheduler Work?
Using the Interval Option
Using the Calendar Option
Frequently Asked Questions
Scheduling Tasks That Launch Applications
Chapter 17 Using the Performance Monitor Object
Introduction to the Performance Monitor Object
Before You Start
Object Modes
Object Scope
Sample Files
Application Distribution Requirements
Required Files
File Registration
The Object Model
Object Model Error Messages
Chapter 18 Teradata Manager Applications
Alert Policy Editor
Alert Viewer
How It Works
BTEQ Window
Configuration Check
Where It Runs
Error Log Analyzer
Locking Logger
Application
Enabling Locking Logger
LogOnOff Usage
Application
Database Setup
How It Works
Priority Scheduler Administrator
Remote Console
Application
Session Information
Reports
Connection Options
Changing connections
Statistics Collection
What It Does
How It Works
Teradata Performance Monitor
How It Works
General Notes
Prerequisites
Resusage Tables
Glossary
Index
Teradata Manager
User Guide
Release 7.0
B035-2428-104A
January 2005
The product described in this book is a licensed product of Teradata, a division of NCR Corporation.
NCR, Teradata and BYNET are registered trademarks of NCR Corporation.
Adaptec and SCSISelect are registered trademarks of Adaptec, Inc.
DEC, VAX, and VMS are registered trademarks of Digital Equipment Corporation.
EMC, PowerPath, SRDF, and Symmetrix are registered trademarks of EMC Corporation.
Engenio is a trademark of Engenio Information Technologies, Inc.
Ethernet is a trademark of Xerox Corporation.
GoldenGate is a trademark of GoldenGate Software, Inc.
Hewlett-Packard and HP are registered trademarks of Hewlett-Packard Company.
IBM, CICS, DB2, MVS, RACF, OS/390, Tivoli, and VM are registered trademarks of International Business Machines Corporation.
Intel, Pentium, and XEON are registered trademarks of Intel Corporation.
KBMS is a registered trademark of Trinzic Corporation.
Linux is a registered trademark of Linus Torvalds.
LSI, SYM, and SYMplicity are registered trademarks of LSI Logic Corporation.
Active Directory, Microsoft, Windows, Windows Server, and Windows NT are either registered trademarks or trademarks of Microsoft
Corporation in the United States and/or other countries.
QLogic and SANbox are registered trademarks of QLogic Corporation.
SAS and SAS/C are registered trademark of SAS Institute Inc.
Sun Microsystems, Sun Java, Solaris, SPARC, and Sun are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. or other
countries.
Unicode is a registered trademark of Unicode, Inc.
UNIX is a registered trademark of The Open Group in the US and other countries.
NetVault is a trademark and BakBone is a registered trademark of BakBone Software, Inc.
NetBackup and VERITAS are trademarks of VERITAS Software Corporation.
Other product and company names mentioned herein may be the trademarks of their respective owners.
THE INFORMATION CONTAINED IN THIS DOCUMENT IS PROVIDED ON AN “AS-IS” BASIS, WITHOUT WARRANTY OF ANY KIND, EITHER
EXPRESS OR IMPLIED, INCLUDING THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-
INFRINGEMENT. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES, SO THE ABOVE EXCLUSION MAY
NOT APPLY TO YOU. IN NO EVENT WILL NCR CORPORATION (NCR) BE LIABLE FOR ANY INDIRECT, DIRECT, SPECIAL, INCIDENTAL OR
CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS OR LOST SAVINGS, EVEN IF EXPRESSLY ADVISED OF THE POSSIBILITY OF SUCH
DAMAGES.
The information contained in this document may contain references or cross references to features, functions, products, or services that are
not announced or available in your country. Such references do not imply that NCR intends to announce such features, functions, products,
or services in your country. Please consult your local NCR representative for those features, functions, products, or services available in your
country.
Information contained in this document may contain technical inaccuracies or typographical errors. Information may be changed or updated
without notice. NCR may also make improvements or changes in the products or services described in this information at any time without
notice.
To maintain the quality of our products and services, we would like your comments on the accuracy, clarity, organization, and value of this
document. Please e-mail: teradata-books@lists.ncr.com
Any comments or materials (collectively referred to as “Feedback”) sent to NCR will be deemed non-confidential. NCR will have no obligation
of any kind with respect to Feedback and will be free to use, reproduce, disclose, exhibit, display, transform, create derivative works of and
distribute the Feedback and derivative works thereof without limitation on a royalty-free basis. Further, NCR will be free to use any ideas,
concepts, know-how or techniques contained in such Feedback for any purpose whatsoever, including developing, manufacturing, or marketing
products or services incorporating Feedback.
Copyright © 1994-2005, NCR Corporation
All Rights Reserved
Preface
Purpose
The purpose of this guide is help the Teradata® Manager user get started with this versatile
product. It is highly recommended that you first familiarize yourself with the capabilities and
structure of this product by reading Chapter 3: “Getting Started With Teradata Manager.”
Next, you should set up your Teradata Manager installation by following the configuration
procedures in Chapter 4: “Configuring Teradata Manager”. After Teradata Manager is
configured, feel free to either go straight through this guide, chapter by chapter, or to skip
around to the sections applicable to your work situation.
Audience
This book is intended for system users, programmers, application programmers, and other
technical personnel who will be using Teradata Manager.
Supported Releases
This book supports the following releases:
Teradata V2R6.0
Teradata Tools and Utilities 8.0
Teradata Manager 7.0
Prerequisites
You should be familiar with basic computer technology, the Teradata Database, and the
Microsoft® Windows® operating system. You should have access to an installed version of
Teradata Manager.
Changes to This Book
The following changes were made to this book to support the current release and are marked
with change bars:
Teradata Manager User Guide
iii
Preface
Changes to This Book
Date
Description
November 2004
New introduction/overview of Teradata Manager and its capabilites. See
“What Is Teradata Manager?” on page 5.
Changes made to Monitor Menu, including addition of Workload Delay
Queue Tabs to the Dashboard. Delay Queue Statistics and List items added
to menu. See “Monitor Menu” on page 13.
DBQL Trends added to Analyze menu. See “Analyze Menu” on page 15
“Administrate” Menu renamed to “Administer” Menu. “RDBMS Setup”
utility renamed to “Database Setup”. Workload applications added to this
menu as well. See “Administer Menu” on page 16.
Addition of dbcmngr.AmpCpuByNodeType view and
dbcmngr.dcInsNodeIdToGroupId macro modifications to coexistence
system setup. See “Setting Up Coexistence Systems” on page 25.
Addition of Security Mechanism to logon dialog. See “Step 3 - Starting
Teradata Manager” on page 28.
Define a priority to be assinged to the Alerts action. See
“Step 6 - Defining System Parameters” on page 31.
Updated perm space requirements for the new DBQL, Resource Usage,
and Teradata DWM tables. See “Perm Space Requirements for Historical
Trend Data Collection” on page 34.
New configuration options for data collection. See “Configuring DBQL
Data Collection Parameters” on page 36, “Configuring Dynamic Workload
Management Data Collection Parameters” on page 37, “Configuring
Heartbeat Query Data Collection Parameters” on page 37, “Configuring
Resource Usage Data Collection Parameters” on page 38.
Configure color display options. See “Configuring Your Color Display
Options” on page 41
Add Application Specific Entries to the registry. See “Adding Application
Specific Entries to the Registry” on page 43.
Monitor the workload delay queue (“Monitoring Delay Queue Statistics”
on page 74), workload object logon statistics (“Monitoring Object Logon
Statistics” on page 75), get details on objects in the delay queue
(“Monitoring Object Query Statistics” on page 76), and get a list of all
objects on the delay queue (“Monitoring the Object Delay Queue List” on
page 76) that allows you to release delayed requests or abort sessions.
Use the Teradata Dashboard to monitor the Workload Delay Queue and
take actions on delayed objects. See “Chapter 7 Monitoring the Delay
Queue” on page 79.
View Resource Usage Trend Analysis reports. See “Analyzing Resource
Usage Trends” on page 94.
View DBQL Usage Trend Analysis reports (“Analyzing DBQL Usage
Trends” on page 97), DBQL step usage trends (“Analyzing DBQL Step
Usage Trends” on page 102), and a DBQL summary histogram (“Viewing
the DBQL Summary Histogram” on page 103).
iv
Teradata Manager User Guide
Preface
Additional Information
Date
Description
November 2004
Continued...
Action available in Alerts. See (“Physical Actions” on
page 183.
New information on using Alerts with Teradata on Windows 2000. See
“Alerting on Teradata Event Messages From Teradata on Windows 2000”
on page 197.
Detailed information on using the Scheduler. See “Chapter 16 Using the
Scheduler” on page 209.
Changes to the Performance Monitor Object. See “Introduction to the
Performance Monitor Object” on page 215.
Additional Information
Additional information that supports this product and the Teradata Tools and Utilities is
available at the following Web sites.
In the following table, mmyx represents the publication date of a manual, where mm is the
month, y is the last digit of the year, and x is an internal publication code.
Type of Information
Description
Source
Overview of the
release
Information too late
for the manuals
Additional
information related
to this product
The Release Definition provides the
following information:
Overview of all the products in the
release
Information received too late to be
included in the manuals
Operating systems and Teradata
Database versions that are certified to
work with each product
Version numbers of each product and
the documentation for each product
Information about available training
and support center
Use the NCR Information Products
Publishing Library site to view or
download, the most recent versions of all
manuals.
Specific manuals that supply related or
additional information to this manual are
listed.
http://www.info.ncr.com/
Navigate to General Search >
Publication Product ID, and enter 2029 to bring up
the following Release Definition:
Teradata Tools and Utilities Release Definition
B035-2029-mmyx
http://www.info.ncr.com/
Click General Search, and do one of the following:
In the Product Line field, select Software -
Teradata Tools and Utilities (TTU) for a list of all
of the publications for this release,
In the Publication Product ID field, enter one of
the following book numbers:
Teradata Manager Installation Guide
B035-2402-mmyx
Teradata Manager User Guide
v
Preface
Additional Information
Type of Information
Description
Source
CD-ROM images
This site contains a link to a downloadable
CD-ROM image of all customer
documentation for this release. Customers
are authorized to create CD-ROMs for
their use from this image.
http://www.info.ncr.com/
Navigate to General Search > Title or Keyword, and
enter CD-ROM.
Ordering
information for
manuals
Use the NCR Information Products
Publishing Library site to order printed
versions of manuals.
http://www.info.ncr.com/
Click How to Order under Print & CD Publications.
General information
about Teradata
Teradata.com
The Teradata home page provides links to
numerous sources of information about
Teradata. Links include:
Executive reports, case studies of
customer experiences with Teradata,
and thought leadership
Technical information, solutions, and
expert advice
Press releases, mentions and media
resources
vi
Teradata Manager User Guide
Table of Contents
Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii
Purpose . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii
Audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii
Supported Releases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii
Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii
Changes to This Book. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii
Additional Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .v
Chapter 1: Before You Begin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
Where to Find Answers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
Getting an Overview of Teradata Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
Getting Help with Installation, or Viewing Program Fixes . . . . . . . . . . . . . . . . . . . . . . . . . .1
Getting Instructions for Specific Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
Getting Help From Teradata Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2
Chapter 2: Late-Breaking News, Online Support and Related
Documentation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
Getting Help With Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
Getting Information on Program Fixes and Change Requests . . . . . . . . . . . . . . . . . . . . . . . . . . .3
Finding Related Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
Chapter 3: Getting Started With Teradata Manager. . . . . . . . . . . . .5
What Is Teradata Manager? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
Monitoring in Real Time: The Teradata Manager Dashboard . . . . . . . . . . . . . . . . . . . . . . .5
Investigating System Logs and Alerts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7
Analyzing Trends in Resource Usage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9
Administering Various Aspects of the Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Finding Your Way Around the Teradata Manager Interface . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Teradata Manager User Guide
vii
Table of Contents
File Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12
Edit Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12
Options Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12
Monitor Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13
Investigate Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .14
Analyze Menu. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15
Administer Menu. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16
Window Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Help Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Teradata Manager File Locations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .18
Printing or Saving the Currently Displayed Report or Graph . . . . . . . . . . . . . . . . . . . . . . . . . .19
Creating a Batch Version of a Teradata Manager Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .20
Chapter 4: Configuring Teradata Manager . . . . . . . . . . . . . . . . . . . . . . .23
Step 1 - Creating the Teradata Manager Databases, Tables, and Macros . . . . . . . . . . . . . . . . .24
Setting Up Coexistence Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
Step 2 - Adding Teradata Manager Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .26
Alternative to Steps 1 and 2 - Using the Setup Script Instead of Database Setup . . . . . . . . . . .27
Step 3 - Starting Teradata Manager. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .28
Step 4 - Restricting User Access with Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .29
Step 5 - Authorizing User Access to Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .30
Step 6 - Defining System Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .31
Step 7 - Enabling Data Collection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .32
Perm Space Requirements for Historical Trend Data Collection . . . . . . . . . . . . . . . . . . . .34
Configuring AMP Usage Data Collection Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .36
Configuring DBQL Data Collection Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .36
Configuring Dynamic Workload Management Data Collection Parameters . . . . . . . . . . . . . .37
Configuring Heartbeat Query Data Collection Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . .37
Configuring Priority Scheduler Data Collection Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . .38
Configuring Resource Usage Data Collection Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38
Configuring Spool Space Data Collection Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .39
Configuring Table Space Data Collection Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .40
Configuring Your Color Display Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41
Checking the Status of the Teradata Manager Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41
Changing to a Different Teradata Manager Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .42
Choosing a Teradata Manager Profile. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43
Restoring the Default Preferences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43
viii
Teradata Manager User Guide
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
