Teradata Manager. User Guide

(1)

Teradata Manager

User Guide

Release 12.0 B035-2428-067A July 2007

(2)

Teradata, BYNET, DBC/1012, DecisionCast, DecisionFlow, DecisionPoint, Eye logo design, InfoWise, Meta Warehouse, MyCommerce, SeeChain, SeeCommerce, SeeRisk, Teradata Decision Experts, Teradata Source Experts, WebAnalyst, and You’ve Never Seen Your Business Like This Before are trademarks or registered trademarks of Teradata Corporation or its affiliates.

Adaptec and SCSISelect are trademarks or registered trademarks of Adaptec, Inc. AMD Opteron and Opteron are trademarks of Advanced Micro Devices, Inc.

BakBone and NetVault are trademarks or registered trademarks of BakBone Software, Inc. EMC, PowerPath, SRDF, and Symmetrix are registered trademarks of EMC Corporation. GoldenGate is a trademark of GoldenGate Software, Inc.

Hewlett-Packard and HP are registered trademarks of Hewlett-Packard Company. Intel, Pentium, and XEON are registered trademarks of Intel Corporation.

IBM, CICS, DB2, MVS, RACF, Tivoli, and VM are registered trademarks of International Business Machines Corporation. Linux is a registered trademark of Linus Torvalds.

LSI and Engenio are registered trademarks of LSI Corporation.

Microsoft, Active Directory, Windows, Windows NT, and Windows Server are registered trademarks of Microsoft Corporation in the United States and other countries.

Novell and SUSE are registered trademarks of Novell, Inc., in the United States and other countries. QLogic and SANbox trademarks or registered trademarks of QLogic Corporation.

SAS and SAS/C are trademarks or registered trademarks of SAS Institute Inc. SPARC is a registered trademarks of SPARC International, Inc.

Sun Microsystems, Solaris, Sun, and Sun Java are trademarks or registered trademarks of Sun Microsystems, Inc., in the United States and other countries.

Symantec, NetBackup, and VERITAS are trademarks or registered trademarks of Symantec Corporation or its affiliates in the United States and other countries.

Unicode is a collective membership mark and a service mark of Unicode, Inc.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Other product and company names mentioned herein may be the trademarks of their respective owners.

THEINFORMATIONCONTAINEDINTHISDOCUMENTISPROVIDEDONAN “AS-IS” BASIS, WITHOUTWARRANTYOFANYKIND, EITHER EXPRESSORIMPLIED, INCLUDINGTHEIMPLIEDWARRANTIESOFMERCHANTABILITY, FITNESSFORAPARTICULARPURPOSE, OR NON-INFRINGEMENT. SOMEJURISDICTIONSDONOTALLOWTHEEXCLUSIONOFIMPLIEDWARRANTIES, SOTHEABOVEEXCLUSION MAYNOTAPPLYTOYOU. INNOEVENTWILL TERADATA CORPORATIONBELIABLEFORANYINDIRECT, DIRECT, SPECIAL, INCIDENTAL, ORCONSEQUENTIALDAMAGES, INCLUDINGLOSTPROFITSORLOSTSAVINGS, EVENIFEXPRESSLYADVISEDOFTHEPOSSIBILITYOF SUCHDAMAGES.

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 Teradata Corporation intends to announce such features, functions, products, or services in your country. Please consult your local Teradata Corporation 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. Teradata Corporation 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: [email protected]

Any comments or materials (collectively referred to as “Feedback”) sent to Teradata Corporation will be deemed non-confidential. Teradata Corporation 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, Teradata Corporation 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.

(3)

Preface

Purpose

This book provides information about Teradata Manager, which is a Teradata Tools and Utilities product. Teradata Tools and Utilities is a group of products designed to work with Teradata Database.

This book helps the Teradata Manager user get started with this versatile product. First get familiar with the capabilities and structure of this product by reading Chapter 3: “Getting Started With Teradata Manager.” Next, set up Teradata Manager by following the

configuration procedures in Chapter 4: “Configuring Teradata Manager.” After Teradata Manager is configured, either go straight through this guide chapter by chapter or skip around to the sections applicable to your work situation.

Audience

This book is intended for use by: • System users

• Programmers

• Application programmers

• Technical personnel using Teradata Manager

Supported Releases

This book supports the following releases: • Teradata Database 12.00.00

• Teradata Tools and Utilities 12.00.00 • Teradata Manager 12.0

Note: See the About Teradata Manager command in Table 10 on page 43 to verify the Teradata Manager version number.

To locate detailed supported-release information:

1 Go to www.info.teradata.com.

2 Navigate to General Search>Publication Product ID.

(4)

Prerequisites

4 Open the version of the Teradata Tools and Utilities ##.##.## Supported Versions spreadsheet associated with this release.

The spreadsheet includes supported Teradata Database versions, platforms, and product release numbers.

Prerequisites

The following prerequisite knowledge is required for this product: • Computer technology and terminology

• Teradata SQL • Teradata Database

• Connectivity software, such as ODBC or CLIv2 • Microsoft® Windows® operating system

Changes to This Book

The following changes were made to this book in support of the current release. Changes are marked with change bars. For a complete list of changes to the product, see the Release

Definition associated with this release.

Date and Release Description

August 2008 12.0

Fixed context-sensitive help.

July 2007 12.0

Added a new report that shows a ranked list of queries on each workload delay queue, allowing queries to be released or aborted based on their position in the delay queue. See “Monitoring the Workload Delay Queue List” on page 113.

Specify an external DBQL for trend reporting.

See “Specifying an External DBQL for Data Collection and Trend Reporting” on page 66.

Added new columns to the Workload Definition Usage Report for reporting summary statistics. See “Workload Definition Usage Report” on page 149. Support for Unicode 4.0 as follows:

• See “Setting the Security Mechanism and Character Set” on page 83.

• See “To run Database Setup twice if upgrading the Teradata Database” on page 51.

• See “To run the script twice if upgrading the Teradata Database” on page 53.

• See “Unicode Migration on Teradata Database 12” on page 53.

(5)

Changes to This Book

July 2007 12.0

Added new session level methods. See Table 95 on page 270 and Table 105 on page 279.

Added a new report that monitors the status of an event. See “Monitoring Event Status” on page 117.

Added the ARC utility to the Object Utility Statistics Report. See Table 29 on page 117.

Added five new columns to the Teradata DWM Workload Definition Summary Report. See Table 34 on page 129. Added one new column to the Workload Definition Detail Report. See Table 35 on page 130.

Added Delayed, QTDelayed, and SesDelayed columns to the Session Information Summary Report. See the Session Information online help. Updated PMON online help for session character sets when logging on. Added documentation for security mechanism to the Logon dialog box introduced in a previous release.

Updated Alert Policy Editor online help for session character sets when logging on. Added documentation for security mechanism to the Logon dialog box introduced in a previous release.

Define a Policy Refresh Failed alert. See “Alerting on Policy Refresh Time” on page 250.

Enhanced the documentation for Teradata Manager Alert Policies. See

Chapter 15: “Using Alerts to Monitor Your System.”

Clarified reset peak spool space and clean up of data collection tasks. See “Step 8 - Enabling Data Collection” on page 61.

Changed the name of the Teradata DWM Dump utility that runs using Remote Console. See Table 116 on page 293.

Added a caution when configuring table space data collection parameters. See

“Configuring Table Space Data Collection Parameters” on page 76.

Using Teradata Manager alerts, monitor the Teradata software event log on Windows databases for Teradata Database 12.00.00 or later. See “Step 6 - Defining System Parameters” on page 57 and “Alerting on Teradata Event Messages From Teradata Database V2R6.x on Windows 2000” on page 248. Updated version numbers.

Added clarification on workload classifications and Priority Scheduler. See

“Introduction” on page 208.

Support for WinCLI is discontinued.

Migrate the tdwm database. See “Step 1 - Creating the Teradata Manager Databases, Tables, and Macros” on page 48 and “TDWM Setup on Teradata Database 12” on page 54.

Miscellaneous updates to match documentation to the current Teradata Manager application.

(6)

Additional Information

Additional information that supports this product and Teradata Tools and Utilities is available at the web sites listed in the table that follows. In the 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. Match the mmy of a related publication to the date on the cover of this book. This ensures that the publication selected supports the same release.

July 2007 12.0

Removed information related to the Computer Associates (CA) Unicenter TNG Framework.

Added a caution when generating the Query List report. See “Analyzing Workload Definition Query Trends” on page 150.

Added support for the Query Banding feature as follows:

• Configure query band pairs data collection parameters. See “Configuring Query Band Pairs Data Collection Parameters” on page 74.

• Added support for query bands to the Session Detail Report. See “Getting Session Details” on page 103.

• View query band names and values. See “Viewing Query Band Pairs” on page 111.

• Added support for query bands in the Object Model. See Table 95 on page 270 and Table 105 on page 279.

• Updated the PMON online help to support query bands.

Date and Release Description

Type of Information Description Access to Information

Release overview Late information

Use the Release Definition for the following information:

• Overview of all of 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 the support center

1 Go to http://www.info.teradata.com/.

2 Select the General Search check box.

3 In the Publication Product ID box, type 2029.

4 Click Search.

5 Select the appropriate Release Definition from the search results.

(7)

Additional product information

Use the Teradata Information Products Publishing Library site to view or download specific manuals that supply related or additional information to this manual.

2 Select the Teradata Data Warehousing check box.

3 Do one of the following:

• For a list of Teradata Tools and Utilities documents, click Teradata Tools and Utilities and then select a release or a specific title.

• Select a link to any of the data warehousing publications categories listed.

Specific books related to Teradata Manager are as follows:

• Database Administration

B035-1093-mmyx

• Workload Management API: PM/API and Open API

B035-1090-mmyx

• Teradata Administrator User Guide

B035-2502-mmyx

• Teradata AWS User Guide

B035-5220-mmyx

• Teradata Dynamic Workload Manager User Guide

B035-2513-mmyx

• Teradata Manager Installation Guide

B035-2402-mmyx

• Teradata SQL Assistant for Microsoft Windows User Guide

B035-2430-mmyx

• Teradata Query Scheduler Administrator Guide

B035-2511-mmyx

• Teradata Query Scheduler User Guide

B035-2512-mmyx

• Teradata Tools and Utilities Installation Guide for Microsoft Windows

B035-2407-mmyx

• Utilities

B035-1102-mmyx CD-ROM images Access 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.

2 Select the General Search check box.

3 In the Title or Keyword box, type CD-ROM.

4 Click Search. Ordering

information for manuals

Use the Teradata Information Products Publishing Library site to order printed versions of manuals.

2 Select the How to Order check box under Print &

CD Publications.

3 Follow the ordering instructions.

(8)

General information about Teradata

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

1 Go to Teradata.com.

2 Select a link.

(9)

Preface

. . . .3 Purpose . . . .3 Audience . . . .3 Supported Releases . . . .3 Prerequisites . . . .4

Changes to This Book . . . .4

Additional Information . . . .6

Chapter 1:

Introduction

. . . 25

Where to Find Answers . . . 25

Getting an Overview of Teradata Manager . . . 25

Getting Help with Installation or Viewing Program Fixes . . . 25

Getting Instructions for Specific Tasks . . . 25

Getting Help for Teradata Manager . . . 26

Chapter 2:

Late-Breaking News, Installation, and Related

Documentation

. . . 27

Installation Information. . . 27

Program Fixes and Changes. . . 27

Chapter 3:

Getting Started With Teradata Manager

. . . 29

What Is Teradata Manager? . . . 29

Finding Your Way Around the Teradata Manager Interface . . . 35

File Menu . . . 36

(10)

Options Menu . . . .37 Monitor Menu . . . .37 Investigate Menu . . . .38 Analyze Menu. . . .39 Administer Menu. . . .41 Graph Menu . . . .42 Window Menu . . . .43 Help Menu . . . .43

Teradata Manager File Locations . . . .43

Printing or Saving the Currently Displayed Report or Graph . . . .45

Creating a Batch Version of a Teradata Manager Report . . . .46

Chapter 4:

Configuring Teradata Manager

. . . .47

Step 1 - Creating the Teradata Manager Databases, Tables, and Macros . . . .48

Step 2 - Adding Teradata Manager Users . . . .50

Alternative to Steps 1 and 2 - Using the Setup Script Instead of Database Setup . . . .52

Step 3 - Starting Teradata Manager. . . .55

Step 4 - Restricting User Access with Profiles . . . .56

Step 5 - Authorizing User Access to Profiles . . . .57

Step 6 - Defining System Parameters . . . .57

Step 7 - Setting RSS Collection Rates . . . .60

Step 8 - Enabling Data Collection . . . .61

Specifying an External DBQL for Data Collection and Trend Reporting . . . .66

Configuring AMP Usage Data Collection Parameters . . . .70

Configuring DBQL Data Collection Parameters . . . .71

Configuring Teradata Dynamic Workload Management Data Collection Parameters . . . .72

Configuring Heartbeat Query Data Collection Parameters . . . .72

Configuring Priority Scheduler Data Collection Parameters . . . .73

Configuring Query Band Pairs Data Collection Parameters. . . .74

Configuring Resource Usage Data Collection Parameters . . . .74

Configuring Spool Space Data Collection Parameters . . . .75

Configuring Table Space Data Collection Parameters . . . .76

Configuring Your Color Display Options . . . .77

Checking the Status of the Teradata Manager Server . . . .78

Changing Logon Settings . . . .78

(11)

Adding Application Specific Entries to the Registry . . . 80

Adding Additional Applications to the Teradata Manager Menu Bar. . . 81

Setting the Port Number for TCP/IP . . . 82

Setting the Security Mechanism and Character Set . . . 83

Chapter 5:

Configuring the SNMP Agent

. . . 85

Teradata Manager Alerts SNMP MIB . . . 85

SNMP Troubleshooting Tips . . . 87

Chapter 6:

Monitoring Real-Time System Activity

. . . 89

Monitoring Overall System Activity Using the Dashboard. . . 90

Getting History Data Details . . . 92

Monitoring Virtual Utilization . . . 94

Getting Virtual Utilization Details . . . 95

Monitoring Physical Utilization . . . 97

Getting Physical Utilization Details. . . 99

Monitoring Session Status . . . 101

Getting Session Details . . . 103

Modifying Session Priority. . . 107

Aborting Sessions . . . 108

Viewing What the Selected Session is Blocking . . . 109

Viewing What the Selected Session is Blocked By . . . 110

Viewing Query Band Pairs . . . 111

Monitoring Delay Queue Statistics . . . 112

Monitoring the Workload Delay Queue List . . . 113

Monitoring Object Logon Statistics . . . 114

Monitoring Object Query Statistics. . . 115

Monitoring the Object Delay Queue List . . . 115

Monitoring Object Utility Statistics . . . 116

Monitoring Event Status . . . 117

Using Performance Monitor (PMON) . . . 120

(12)

Chapter 7:

Monitoring the Delay Queue

. . . .123

Viewing a Snapshot of the Workload Delay Queue. . . .123

Getting Workload Delay Queue Statistics . . . .124

Viewing Workload Delay Queue History . . . .125

Viewing and Releasing Requests in the Workload Delay Queue . . . .125

Chapter 8:

Monitoring Workload Activity

. . . .127

Checking Workload Status. . . .127

Getting Workload Summary Statistics . . . .128

Getting Workload Detail Statistics . . . .130

Getting Workload History Statistics . . . .131

Specifying the Display for Workload Snapshot Graphs . . . .132

Chapter 9:

Analyzing Workload Trends

. . . .135

Analyzing CPU Utilization. . . .135

CPU Utilization Report . . . .137

Analyzing Disk I/O Utilization . . . .138

Analyzing Table Growth. . . .140

Analyzing Spool and Temp Space Usage . . . .142

Analyzing Heartbeat Query Response Time. . . .144

Analyzing User Count . . . .146

Analyzing Workload Definition Usage Trends . . . .147

Analyzing Workload Definition Query Trends . . . .150

Analyzing Resource Usage Trends. . . .155

Analyzing DBQL Usage Trends . . . .158

Analyzing DBQL Step Usage Trends. . . .163

(13)

Chapter 10:

Analyzing Historical Resource Utilization

. . . 167

Analyzing Node CPU Utilization . . . 167

Analyzing AMP CPU Utilization. . . 169

Analyzing PE CPU Utilization . . . 171

Analyzing Node Utilization . . . 172

Analyzing Disk Utilization . . . 174

Analyzing Network (Bynet) Utilization . . . 176

Analyzing Memory Utilization . . . 177

Analyzing Host Utilization. . . 179

Non-Grouped Reports . . . 181

History Query Filter . . . 181

Chapter 11:

Investigating Disk Space Utilization

. . . 183

Reallocating Disk Space . . . 183

Changing Options for Space Usage Reports. . . 185

Transferring Database Ownership. . . 185

Viewing Database Space Usage . . . 186

Viewing Space Usage By Table. . . 187

Viewing Table Space Usage by Vproc . . . 188

Viewing the CREATE TABLE Statement . . . 189

Viewing All Objects In a Database. . . 189

Viewing Hierarchical Space Usage . . . 190

Viewing Overall Space Usage by Vproc . . . 191

Viewing Cylinder Space By Vproc. . . 192

Chapter 12:

Investigating System Behavior

. . . 195

Investigating the Error Log . . . 195

Investigating Logon Activity . . . 196

Investigating Lock Contentions . . . 196

(14)

Chapter 13:

Investigating the Audit Log

. . . .199

Before Creating Audit Reports. . . .199

Setting the Audit Log Filter to Narrow Your Results. . . .200

Auditing Database and User Activity . . . .200

Auditing Table, View and Macro Activity . . . .201

Auditing Grant and Revoke Activity . . . .202

Auditing Index Activity . . . .202

Auditing Checkpoint, Dump and Restore Activity . . . .203

Auditing Denials . . . .204

Creating an Audit Summary Report . . . .204

Creating a Custom Audit Report. . . .205

Chapter 14:

Using Teradata Priority Scheduler Administrator

. . . .207

Introduction . . . .208

Step 1 - Starting Teradata PSA. . . .209

Step 2 - Defining PD Set and Resource Partition Parameters. . . .209

Step 3 - Defining Performance Group Parameters . . . .212

Step 4 - Defining Allocation Group Parameters . . . .214

Adding or Deleting an Allocation Group . . . .215

Viewing a Priority Definition Set Description . . . .216

Viewing the Schmon Commands Used to Create a Priority Definition Set . . . .216

Saving and Deleting Priority Definition Set Information . . . .217

Creating a New Priority Definition Set . . . .219

Viewing Performance Data . . . .219

Viewing Session Information. . . .223

Viewing a Session Report . . . .224

Scheduling a Priority Definition Set . . . .224

Comparing Relative Weights of Allocation Groups or Resource Partitions . . . .225

Comparing Relative CPU Use of an Allocation Group or Resource Partition . . . .226

Changing the Operating System Type. . . .226

Defining Advanced PD Set and Resource Partition Parameters. . . .227

Configuring the Priority Scheduler Administrator Display . . . .228

(15)

Chapter 15:

Using Alerts to Monitor Your System

. . . 229

Introduction to the Alerts Facility . . . 230

Creating a New Alert Policy . . . 230

Defining Actions to the Policy . . . 231

Defining Actions - Sending a Page . . . 233

Defining Actions - Sending E-mail . . . 234

Configuring the System to Send E-mail Alerts. . . 236

Defining Actions - Running a Program . . . 238

Defining Actions - Running a BTEQ Script . . . 239

Defining Actions - Generating an SNMP Trap . . . 240

Defining Actions - Action Lists . . . 241

Defining Events to the Policy. . . 241

Defining Events - Database Space . . . 242

Defining Events - System Level Performance. . . 242

Defining Events - Node Level Performance . . . 243

Defining Events - Vproc Level Performance . . . 244

Defining Events - Session Level Performance . . . 245

Defining Data Collection Rates for the Policy . . . 246

Applying the Policy to the Database . . . 246

Displaying the Performance Status of the Database . . . 247

Alerting on Teradata Event Messages From Teradata Database V2R6.x on Windows 2000 248 Alerting on Policy Refresh Time . . . 250

Alerts Examples . . . 251

Chapter 16:

System Administration

. . . 257

Administering Workloads with Priority Scheduler Administrator . . . 257

Administering Using the Database Console (Remote Console). . . 257

Administering System Alarms Using Alerts (Alert Policy Editor) . . . 258

Administering Using the BTEQ Window . . . 258

(16)

Chapter 17:

Using the Scheduler

. . . .261

Introduction to the Scheduler . . . .261

Scheduling Tasks That Launch Applications . . . .263

Example 1: Scheduling a Task To Run Once a Day . . . .264

Example 2: Specifying the Days and Times . . . .265

Example 3: Specifying Multiple Daily Runs . . . .265

Chapter 18:

Using the Performance Monitor Object

. . . .267

Prerequisite Knowledge . . . .267

Application Distribution Requirements . . . .268

The Object Model . . . .270

Object Model Error Messages . . . .285

Chapter 19:

Teradata Manager Applications

. . . .287

Alert Policy Editor. . . .288

Alert Viewer. . . .288

BTEQ Window . . . .289

Configuration Check . . . .290

Error Log Analyzer . . . .290

Locking Logger . . . .291

LogOnOff Usage . . . .292

Database Setup . . . .292

Priority Scheduler Administrator . . . .293

Remote Console . . . .293

Session Information . . . .295

Statistics Collection. . . .296

(17)

Glossary

. . . 299

(18)

(19)

List of Figures

Figure 1: Teradata Manager Dashboard . . . 30

Figure 2: Teradata Performance Monitor. . . 31

Figure 3: Teradata Manager Database Space Report . . . 32

Figure 4: Teradata Manager Alert Viewer. . . 33

Figure 5: Teradata Manager Resource Usage Trend Report . . . 34

Figure 6: Teradata Manager Administration Tabs. . . 35

Figure 7: Example of an Event Status Report . . . 120

Figure 8: Scheduling a task to run once a day . . . 264

Figure 9: Scheduling a task to run once a day specifying the days and time . . . 265

(20)

(21)

List of Tables

Table 1: File Menu Commands . . . 36

Table 2: Edit Menu Commands. . . 36

Table 3: Options Menu Commands . . . 37

Table 4: Monitor Menu Commands . . . 37

Table 5: Investigate Menu Commands . . . 38

Table 6: Analyze Menu Commands . . . 39

Table 7: Administer Menu Commands . . . 41

Table 8: Graph Menu Commands. . . 42

Table 9: Window Menu Commands . . . 43

Table 10: Help Menu Commands . . . 43

Table 11: Teradata Manager File Locations . . . 44

Table 12: Perm Space Requirements for Data Collection . . . 64

Table 13: Summary Graph Data Points . . . 93

Table 14: Vproc Utilization Report . . . 94

Table 15: Vproc Utilization Detail Report . . . 96

Table 16: Node Utilization Report . . . 98

Table 17: Node Utilization Detail Report . . . 99

Table 18: Session Status Report . . . 102

Table 19: Session Detail Report . . . 104

Table 20: Abort Session Report . . . 109

Table 21: Blocking Sessions Report . . . 110

Table 22: Blocked By Report . . . 111

Table 23: Query Bands Report . . . 112

Table 24: Delay Queue Statistics Report . . . 113

Table 25: Workload Delay Queue List Report . . . 113

Table 26: Object Logon Statistics Report . . . 114

Table 27: Object Query Statistics Report . . . 115

Table 28: Object Delay Queue List Report . . . 116

Table 29: Object Utility Statistics Report . . . 117

Table 30: Event Status Report . . . 118

(22)

Table 33: Workload Delay Queue Session List. . . .126 Table 34: Teradata DWM Workload Definition Summary Report . . . .129 Table 35: Workload Definition Detail Report . . . .130 Table 36: Workload Definition Summary History Report . . . .132 Table 37: Criteria Used to Determine the Top Workloads . . . .133 Table 38: CPU Utilization Report . . . .137 Table 39: Disk I/O Utilization Report . . . .139 Table 40: Table Growth Report . . . .141 Table 41: Spool/Temp Space Usage Report . . . .143 Table 42: Response Time Report . . . .145 Table 43: User Count Report . . . .147 Table 44: Workload Definition Usage Report . . . .149 Table 45: Rejected Query List Report . . . .151 Table 46: Delayed Query List Report . . . .151 Table 47: Exception Query List Report . . . .152 Table 48: Exceeded SLG Query List Report . . . .153 Table 49: Completed Query List Report . . . .154 Table 50: Resource Usage Report: CPU Usage. . . .156 Table 51: Resource Usage Report: Disk Usage . . . .157 Table 52: Resource Usage Report: Memory Usage . . . .157 Table 53: Resource Usage Report: Bynet Usage . . . .157 Table 54: Resource Usage Report: System Utilization . . . .158 Table 55: DBQL Usage Report: Condition Indicator Count . . . .160 Table 56: DBQL Usage Report: Response Time. . . .161 Table 57: DBQL Usage Report: Resource Usage . . . .162 Table 58: DBQL Usage Report: Parallelism . . . .162 Table 59: DBQL Step Usage Report . . . .164 Table 60: DBQL Summary Histogram . . . .166 Table 61: Node CPU Utilization Report . . . .168 Table 62: AMP CPU Utilization Report . . . .170 Table 63: PE CPU Utilization Report . . . .172 Table 64: Node Utilization Report . . . .173 Table 65: Disk Utilization Report . . . .176 Table 66: Network Utilization Report. . . .177 Table 67: Memory Utilization Report . . . .178 Table 68: Host Utilization Report . . . .180

(23)

Table 69: Non-Grouped Report. . . 181 Table 70: Move Space Fields and Controls . . . 184 Table 71: Space By Database Report . . . 186 Table 72: Table Space Report . . . 188 Table 73: Table Space By Vproc Report . . . 189 Table 74: Help Database Report . . . 190 Table 75: Hierarchy Report . . . 191 Table 76: Space By Vproc Report . . . 191 Table 77: Cylinder Space By Vproc Report. . . 192 Table 78: Logon Activity Reports . . . 196 Table 79: Audit Database and Users Activity Report. . . 200 Table 80: Audit Table, View, Macro Activity Report. . . 201 Table 81: Audit Grant and Revoke Activity Report . . . 202 Table 82: Audit Index Activity Report . . . 202 Table 83: Audit Checkpoint, Dump and Restore Activity Report . . . 203 Table 84: Audit Denials Report . . . 204 Table 85: Audit Summary Report . . . 205 Table 86: Physical Actions . . . 232 Table 87: Built-in Actions. . . 232 Table 88: E-mail Alert Message . . . 235 Table 89: Event Data Items . . . 239 Table 90: Event Message Files . . . 250 Table 91: Alert Request Table Column Descriptions. . . 253 Table 92: Monitor Request Table Column Definitions . . . 254 Table 93: Required Teradata Manager Support Files . . . 269 Table 94: Required Third Party Support Files . . . 269 Table 95: Monitor (Object) Descriptions . . . 270 Table 96: VprocSummary Descriptions . . . 272 Table 97: Node Summary Descriptions . . . 273 Table 98: AMPs Descriptions. . . 274 Table 99: AMP (Object) Descriptions. . . 275 Table 100: PEs Descriptions . . . 276 Table 101: PE Object Descriptions . . . 276 Table 102: Nodes Descriptions . . . 277 Table 103: Node (Object) Descriptions . . . 277

(24)

Table 105: Session (Object) Descriptions . . . .279 Table 106: Blocks Descriptions . . . .283 Table 107: Block (Object) Descriptions . . . .283 Table 108: Steps Descriptions . . . .283 Table 109: Step (Object) Descriptions . . . .283 Table 110: Workloads Descriptions . . . .284 Table 111: Workload (Object) Descriptions . . . .284 Table 112: Query Bands Descriptions . . . .284 Table 113: Query Band (Object) Descriptions . . . .285 Table 114: Object Model Error Messages . . . .285 Table 115: LogOnOff Usage Report Descriptions . . . .292 Table 116: Remote Console Utility Descriptions . . . .293 Table 117: Session Information Report Descriptions . . . .295

(25)

CHAPTER 1

Introduction

The following topics provide information on where to find answers and how to get help for Teradata Manager.

Where to Find Answers

To learn about the product, Teradata Manager comes with a number of instructional components. including:

Getting an Overview of Teradata Manager

For an overview of the capabilities of Teradata Manager, as well as an introduction to the Teradata Manager menu bar in the interface, see Chapter 3: “Getting Started With Teradata Manager.”

Getting Help with Installation or Viewing Program Fixes

For help with Teradata Manager installation, the installation of related products, or documentation of program fixes, see Chapter 2: “Late-Breaking News, Installation, and Related Documentation.”

Getting Instructions for Specific Tasks

To get familiar with the Teradata Manager interface, look at the following:

Task Location

Set up a new installation of Teradata Manager, or change program configuration settings

Chapter 4: “Configuring Teradata Manager”

Set up an SNMP agent that allows third party management applications such as HP OpenView to monitor Teradata system performance and to be notified of exceptions using SNMP traps

Chapter 5: “Configuring the SNMP Agent”

Monitor overall system utilization in real time Chapter 6: “Monitoring Real-Time System Activity”

Monitor jobs that are in the delay queue Chapter 7: “Monitoring the Delay Queue”

(26)

Where to Find Answers

Getting Help for Teradata Manager

Teradata Manager is linked to the HTML version of this user guide. Use the Help menu on the Teradata Manager menu bar to launch the help system. To see context-sensitive help for the active dialog box, press F1.

Analyze workload usage through time Chapter 9: “Analyzing Workload Trends”

Get a historical view of how your system is being utilized

Chapter 10: “Analyzing Historical Resource Utilization”

Monitor space usage and move space from place to place

Chapter 11: “Investigating Disk Space Utilization”

Analyze the maximum and average usage for Logical Devices (LDVs), AMP vprocs, nodes, and PE vprocs on your system

Chapter 12: “Investigating System Behavior”

Check the results of privilege checks Chapter 13: “Investigating the Audit Log”

Schedule system priorities Chapter 14: “Using Teradata Priority Scheduler Administrator”

Set up alert actions to generate notifications of, and actively respond to, Teradata Database events

Chapter 15: “Using Alerts to Monitor Your System”

Investigate the various system administration options available with your Teradata Manager software

Chapter 16: “System Administration”

Schedule activities on your system Chapter 17: “Using the Scheduler”

Set up an ActiveX (COM) object that exposes methods to allow retrieval of PMPC data

Chapter 18: “Using the Performance Monitor Object.”

Use the various Teradata Manager applications Chapter 19: “Teradata Manager Applications.”

(27)

CHAPTER 2

Late-Breaking News, Installation, and

Installation Information

For information on installing Teradata Manager, as well as the rest of the Teradata Tools and Utilities, see the following:

• Teradata Manager Installation Guide

• Teradata Tools and Utilities Installation Guide for Microsoft Windows

Program Fixes and Changes

For the latest documentation on program fixes and changes included in this release, see

(28)

(29)

CHAPTER 3

Getting Started With Teradata Manager

The following topics provide basic information to get started using Teradata Manager: • What Is Teradata Manager?

• Finding Your Way Around the Teradata Manager Interface • Teradata Manager File Locations

• Printing or Saving the Currently Displayed Report or Graph • Creating a Batch Version of a Teradata Manager Report

What Is Teradata Manager?

As the command center for the Teradata Database, Teradata Manager supplies an extensive suite of indispensable DBA tools for managing your Teradata Database.

Teradata Manager collects, analyzes, and displays database performance and utilization information in either report or graphic format, displaying it all on a Windows PC.

The client-server feature in Teradata Manager replicates performance data on the server for access by any number of clients. Because data is collected once, workload on the database remains constant while the number of client applications varies.

The following sections highlight some of the main Teradata Manager features. For a complete list of features and capabilities, see “Finding Your Way Around the Teradata Manager

Interface” on page 35.

Monitoring in Real Time: The Teradata Manager Dashboard

The heart of Teradata Manager is the Teradata Manager Dashboard (Figure 1) and is available from the Monitor menu.

(30)

What Is Teradata Manager?

Figure 1: Teradata Manager Dashboard

The Teradata Manager Dashboard provides a single tabbed page view of current performance and workload information, as well as recent trends. This is accomplished by showing real-time gauges and graphs displaying:

• Virtual and physical CPU utilization • Requests-per-minute

• I/O-per-request • Response time

• Sessions (idle, active, blocked, responding, Parsing, aborting, details, and prolonged idles) • Recent history graphs showing trends and providing analytic data

• Workload snapshots and history

All this enables rapid problem resolution to drill down quickly to the most useful detailed information.

(31)

Teradata Performance Monitor (PMON)

Teradata Performance Monitor provides the system status at a glance with seven functional areas for monitoring system activity. See Figure 2. These include Configuration Summary, Performance Summary and Resource Usage (both physical and virtual), Session and Lock information, Session History, Control functions and graphic displays of Resource and Session data.

Figure 2: Teradata Performance Monitor

PMON uses charting facilities to present the data to identify abnormalities. Color is used to indicate warning conditions. Configure the Alert thresholds, color settings, and automatic data refresh rate values by using the PMON Options tabs.

Detailed session and user information is useful for analyzing system activity and blocked sessions. Lock information helps determine which sessions are blocking other sessions and why. After analyzing running queries, drill down from a blocked session to the query and the step level of the explain for the query.

Session Information

Session Information dynamically monitors the status of sessions on logical host processors attached to the Teradata Database. The status can be updated as frequently as every six seconds depending on the size of the database and the workload. Information is reported on the current status of a session including Idle, Active, Blocked, Responding, Parsing, Aborting,

(32)

Details, and Prolonged Idles. With Session Information, quickly identify abnormal conditions in the Teradata Database, and abort any unnecessary jobs.

Investigating System Logs and Alerts

The Investigate menu provides access to system logs and to the Alerts facility, providing reports that show:

• Privilege checks for various types of Database activity • The Error log

• Space usage statistics • Logon statistics • Lock contentions

The Teradata Manager Database Space Report (Figure 3) is available from the Investigate menu, and shows space usage by database.

(33)

The Alert Viewer

The Alert Viewer (Figure 4) is a component of the Alerts Facility where it is easy to view system status for one or more Teradata Databases.

The Alerts Facility facilitates the monitoring of performance characteristics and faults on the Teradata Database. The Alerts Facility can automatically activate actions, such as sending a page, sending e-mail, or sending a message to an SNMP system. Other applications and utility programs can also make use of the Alert function by using a built-in request interface. The Alert Policy Editor is used to define actions. Specify when the actions are taken by setting thresholds for Teradata Database performance parameters, database space utilization, and messages in the database Event Log.

(34)

Analyzing Trends in Resource Usage

The Analyze menu provides views of various historical trends in resource usage. For example, see the Teradata Manager Resource Usage Trend Report (Figure 5). In most cases, these trends can be viewed in either graph or table format, and can be filtered in many ways to customize your historical system view.

Figure 5: Teradata Manager Resource Usage Trend Report

Administering Various Aspects of the Database

The Teradata Manager Administration tabs (Figure 6) assist in managing users and tables, allowing:

• Creation of users, databases, tables, and modification of access rights • Collection of database statistics

• Moving free disk space between databases • Setting of job performance parameters

(35)

Finding Your Way Around the Teradata Manager Interface

Figure 6: Teradata Manager Administration Tabs

Priority Scheduler Administrator

Teradata Priority Scheduler Administrator helps to prevent bottlenecks and speeds responses to queries by automatically balancing the data warehouse workload. Teradata Priority Scheduler Administrator ensures that queries requiring immediate handling are fast-tracked by letting the jobs cut in line ahead of lower priority work.

Finding Your Way Around the Teradata

Manager Interface

There are a wide array of reporting and administrative options that can all be easily accessed from the Teradata Manager menu bar. After becoming comfortable with the menus displayed on the menu bar, using Teradata Manager becomes quite intuitive.

(36)

The Teradata Manager menu bar is structured as follows.

File Menu

Edit Menu

Table 1: File Menu Commands

Command Description Additional Information

Open Load a Teradata Manager report or graph that has been saved in XML format using the

Save As command

“Creating a Batch Version of a Teradata Manager Report” on page 46

Close Close a report Not applicable

Save As Save a report or graph in XML

format so it can be loaded back into Teradata Manager for viewing, or in other formats so it can be transferred to external applications

“Printing or Saving the Currently Displayed Report or Graph” on page 45

Append Command to Batch File Create a batch version of a Teradata Manager report

“Creating a Batch Version of a Teradata Manager Report” on page 46

Print Preview Preview the report image to be

printed

“Printing or Saving the Currently Displayed Report or Graph” on page 45

Print Print a report “Printing or Saving the

Currently Displayed Report or Graph” on page 45

Exit Close the Teradata Manager application

Not applicable

Table 2: Edit Menu Commands

Cut Move the selected text to the clipboard

Not applicable

Copy Copy the selected text to the clipboard

Not applicable

Paste Paste the text on the clipboard

at the insertion point

(37)

Options Menu

Monitor Menu

Table 3: Options Menu Commands

Change Font Change the report display fonts Not applicable

Restore Default Preferences Clear user preferences “Restoring the Default Preferences for Tables and Graphs” on page 79 Refresh Workload List Refresh the list of workloads in

the cache

Not applicable

Change Logon Settings Change to a different Teradata Manager server, database or profile

“Changing Logon Settings” on page 78

Table 4: Monitor Menu Commands

Dashboard View a summary of the current

state of the system on a single tabbed dialog.

Note: For Teradata Manager to

display the workload or delay queue data, Teradata Dynamic Workload Manager (DWM) must be enabled. See the instructions in the Teradata

Dynamic Workload Manager User Guide.

“Monitoring Overall System Activity Using the Dashboard” on page 90 and “Viewing a Snapshot of the Workload Delay Queue” on page 123

Sessions>(options) Get information on individual sessions

“Monitoring Session Status” on page 101

Nodes Get information on Node

usage

“Monitoring Physical Utilization” on page 97

Vprocs Get information on vproc

usage

“Monitoring Virtual Utilization” on page 94 Teradata DWM>Delay Queue

Stats Get statistics on objects in the Delay Queue

“Monitoring Delay Queue Statistics” on page 112 Teradata DWM>WD Summary Get summary information on

workloads

“Getting Workload Summary Statistics” on page 128 Teradata DWM>WD Delay

Queue List View a list of workloads in the delay queue

“Monitoring the Workload Delay Queue List” on page 113

(38)

Investigate Menu

Teradata DWM>Object Logon

Stats Get statistics on object logons “Monitoring Object Logon Statistics” on page 114 Teradata DWM>Object Query

Stats Get statistics on object queries “Monitoring Object Query Statistics” on page 115 Teradata DWM>Object Delay

Queue List View a list of objects in the delay queue

“Monitoring the Object Delay Queue List” on page 115 Teradata DWM>Object Utilities

Stats Get statistics on system utilities “Monitoring Object Utility Statistics” on page 116 Performance Monitor Analyze the performance of a

Teradata machine and perform related control functions on that machine

“Using Performance Monitor (PMON)” on page 120

Session Information Get information on session status, modify session priority, view blocking or blocked sessions, and change session priority

“Using Session Information” on page 120

Table 4: Monitor Menu Commands (continued)

Table 5: Investigate Menu Commands

Command Description Additional Information.

Audit Log>Filter Set the Audit Log report filter to narrow your results

“Setting the Audit Log Filter to Narrow Your Results” on page 200

Audit Log>Database/User Audit privilege checks for database and user activity

“Auditing Database and User Activity” on page 200 Audit Log>Table/View/Macro Audit privilege checks for table,

view, or macro activity

“Auditing Table, View and Macro Activity” on page 201 Audit Log>Grants Audit privilege checks for

Grant activity

“Auditing Grant and Revoke Activity” on page 202 Audit Log>Indexes Audit privilege checks for

Index activity

“Auditing Index Activity” on page 202

Audit Log>Maintenance Audit privilege checks for Maintenance activity

“Auditing Checkpoint, Dump and Restore Activity” on page 203

Audit Log>Denials Audit privilege check denials “Auditing Denials” on page 204 Audit Log>Summary Create a summary report of

privilege checks

“Creating an Audit Summary Report” on page 204

(39)

Analyze Menu

Audit Log>Custom Create a custom report of privilege checks

“Creating a Custom Audit Report” on page 205

Error Log Investigate the Error Log “Investigating the Error Log”

on page 195 Space Usage>Space by

Database Display space usage for each Teradata Database

“Viewing Database Space Usage” on page 186 Space Usage>Hierarchy Display a database hierarchy

report

“Viewing Hierarchical Space Usage” on page 190

Space Usage>Space by Vproc Display space usage by vproc “Viewing Overall Space Usage by Vproc” on page 191 Space Usage>Cylinders by

Vproc Display cylinder usage by vproc

“Viewing Cylinder Space By Vproc” on page 192

Logon/Logoff History Present daily, weekly, and monthly logon statistics based on information in the DBC LOGONOFF view on the Teradata Database

“Investigating Logon Activity” on page 196

Locking Logger Determine whether system

performance has been degraded by an inappropriate mix of SQL statements using a table of information extracted from the transaction logs

“Investigating Lock Contentions” on page 196

Alert Viewer Provide a single view point on

the overall system performance of your Teradata Database systems

“Investigating System Performance Parameters” on page 197

Table 5: Investigate Menu Commands (continued)

Command Description Additional Information.

Table 6: Analyze Menu Commands

Trends>CPU Utilization View historical trends in CPU utilization

“Analyzing CPU Utilization” on page 135

Trends>Disk I/O Utilization View historical trends in Disk I/O utilization

“Analyzing Disk I/O Utilization” on page 138 Trends>Table Growth View historical trends in table

growth

“Analyzing Table Growth” on page 140

Trends>Spool/Temp Space

Usage View historical trends in space usage

“Analyzing Spool and Temp Space Usage” on page 142

(40)

Trends>Response Time View historical trends in response time

“Analyzing Heartbeat Query Response Time” on page 144 Trends>User Count View historical trends in user

count

“Analyzing User Count” on page 146

Trends>Workload Definition

Usage View workload definition usage trends

“Analyzing Workload Definition Usage Trends” on page 147

Trends>Workload Definition

Query List View the workload definition list of queries

“Analyzing Workload Definition Query Trends” on page 150

Trends>Resource Usage View historical trends in resource usage

“Analyzing Resource Usage Trends” on page 155 Trends>DBQL Usage View historical trends in DBQL

usage

“Analyzing DBQL Usage Trends” on page 158 Trends>DBQL Step Usage View historical trends in DBQL

step usage

“Analyzing DBQL Step Usage Trends” on page 163

Trends>DBQL Summary

Histogram View DBQL summary statistics “DBQL Summary Histogram” on page 166 Resource History>Node CPU View the maximum and

average CPU utilization

“Analyzing Node CPU Utilization” on page 167 Resource History>AMP CPU View the maximum and

average AMP CPU utilization

“Analyzing AMP CPU Utilization” on page 169 Resource History>PE CPU View the maximum and

average PE CPU utilization

“Analyzing PE CPU Utilization” on page 171 Resource History>Node

Utilization View the maximum and average Node utilization

“Analyzing Node Utilization” on page 172

Resource History>Disk

Utilization View the maximum and average Disk utilization

“Analyzing Disk Utilization” on page 174

Resource History>ByNet

Utilization View the maximum and average ByNet utilization

“Analyzing Network (Bynet) Utilization” on page 176 Resource History>Memory

Utilization View the maximum and average Memory utilization

“Analyzing Memory Utilization” on page 177 Resource History>Host

Utilization View the maximum and average Host utilization

“Analyzing Host Utilization” on page 179

Table 6: Analyze Menu Commands (continued)

(41)

Administer Menu

Table 7: Administer Menu Commands

Teradata Manager Configure Teradata Manager,

change the database password, set up Alerts and data

collection

Chapter 4: “Configuring Teradata Manager”

Teradata Database Perform administration

functions on the Teradata Database

Note: This option is available

only if this product is installed on your Teradata Manager PC.

The Teradata Administrator

User Guide

Database Console Run many of the Teradata

Database console utilities from your Teradata Manager PC

“Administering Using the Database Console (Remote Console)” on page 257 Alert Policies Define the actions that can take

place when specific events occur on your Teradata Database machines

“Administering System Alarms Using Alerts (Alert Policy Editor)” on page 258

SQL Assistant Send queries to the Teradata

Database

only if this product is installed on your Teradata Manager PC

The Teradata SQL Assistant for

Microsoft Windows User Guide. Note: If an error appears when

starting SQL Assistant indicating, “Data source not found and no default driver specified,” ensure the ODBC DSN name is the same as the system name (COP name) used when logging on to Teradata Manager.

BTEQ Window Load and extract data from the

Teradata Database using a version of BTEQ with a windows interface

“Administering Using the BTEQ Window” on page 258

Teradata Database Setup Set up the Database to run Teradata Manager

“Step 1 - Creating the Teradata Manager Databases, Tables, and Macros” on page 48 Statistics Collection Create, drop and update

statistics for the Teradata Database

“Administering Using Database Statistics (Statistics

Collection)” on page 259

Move Space Reallocate available disk space

from one Teradata Database to another

“Reallocating Disk Space” on page 183

(42)

Graph Menu

Opening a graph, adds the Graph menu to the Teradata Manager menu bar.

Move Database Transfer the ownership of a

database to another user

“Transferring Database Ownership” on page 185 Workload Management> Priority

Scheduler Control the allocation and consumption of computer resources available to the Teradata Database

“Chapter 14 Using Teradata Priority Scheduler

Administrator” on page 207 Workload Management>

Dynamic Workload Manager (Teradata DWM)

Set Workload Management rules. These rules must be in place for Teradata Manager to monitor the workload or delay queue data.

The Teradata Dynamic

Workload Manager User Guide.

Workload Management> Query

Scheduler Schedule queries on the Teradata Database

The Teradata Query Scheduler

User Guide and the Teradata Query Scheduler Administrator Guide

Table 7: Administer Menu Commands (continued)

Table 8: Graph Menu Commands

Graph>Type Change the type of graph from

bar to line.

Not applicable

Graph>Style Change the style of the graph

from stacked to lines or symbols.

Not applicable

Graph>Legend Enable or disable the legend for graph views.

“The Graph Legend” on page 121

(43)

Teradata Manager File Locations

Window Menu

Help Menu

Teradata Manager File Locations

Teradata Manager files are stored in the various locations described in the following tables. In all cases:

• x - The drive selected during the installation procedure

• userid - The name of the logged on user

• DatabaseName - The name of the Teradata Database being monitored by Teradata

Manager.

Table 9: Window Menu Commands

Cascade Arrange the open windows in a

cascading pattern

Not applicable

Tile Arrange the open windows in a tile pattern

Not applicable

Table 10: Help Menu Commands

Help Topics Open the Teradata Manager

help file

Not applicable

About Teradata Manager Get information about Teradata Manager, including the product version number and the date created, the current logon database, connection type, the client character set, name of the user, and profile name.

(44)

Teradata Manager File Locations

Table 11: Teradata Manager File Locations

These types of files... Are stored in...

Program files and other read-only files

The program files directory. The default is:

x:\Program Files\NCR\Teradata Manager 12.0

The Teradata Manager 12.0 directory contains the following sub-directories:

• BIN - Program executable files, resource files and some help files • Data - Template files and data files

• Help - HTML Help files

• Samples - Sample code to get started with the Teradata Manager

Performance Object Model

• Secure - All user applications and BTEQ scripts that are called by

alert actions. It is recommended that write permission to this directory are only granted to users responsible for setting up the Teradata Alerts system.

• SQL - SQL scripts used to set up the Teradata Manager tables, and

for various applications to retrieve data

Data files, reports and logs The user’s My Documents directory. The default is:

x:\Documents and Settings\<userid>\My

Documents\NCR\Teradata Manager

This directory contains the following sub-directories:

Data - Saved run-time data

Profiles - Logs and other output files associated with databases being

monitored by Teradata Manager Teradata Manager Service

log files (tmgr.log)

The system application data directory. The default is:

x:\Documents and Settings\All Users\Application

Data\NCR\Teradata Manager

User’s personal Teradata Manager log files (tmgr.log)

The user’s My Documents directory. The default is:

Documents\NCR\Teradata Manager\Profiles\ <DatabaseName>\LOGS

Alert Action log file (alerts.log)

The system application data directory. The default is:

x:\Documents and Settings\All Users\Application

Data\NCR\Teradata Manager\Databases\<DatabaseName>\

Alert Policy Editor log file (ape.log)

The user’s My Documents directory. The default is:

(45)

Printing or Saving the Currently Displayed Report or Graph

Printing or Saving the Currently Displayed

Report or Graph

After creating a report or graph using the Teradata Manager reporting features described throughout this user guide, there are several options for printing or saving the data in various formats, including tab-delimited and XML.

To print a displayed report or graph

1 From the Teradata Manager menu bar, click File>Print. The Print dialog box appears.

2 Choose your print options, and click OK.

To preview a displayed report or graph before printing

1 From the Teradata Manager menu bar, click File>Print Preview. The report or graph appears in the Preview window.

2 Use the buttons on the top of the window, to do the following:

• To move forward or back in a multiple page report, click Next Page or Prev Page. • To view two pages of a multiple page report at once, click Two Page.

• To change the magnification of the report or graph, click Zoom In or Zoom Out. • To print the report or graph, click Print to display the Print dialog box. Choose your

print options, and click OK.

• To close the Preview window without printing the report or graph, click Close.

To save a displayed report or graph

1 From the Teradata Manager menu bar, click File>Save As. The Save As dialog box appears.

2 In the Save in list, navigate to the folder to save the report or graph.

3 Enter a file name for the report in the File name box.

4 Select the format by using the Save as type list.

Use the .xml format to load the report back into Teradata Manager where it can be viewed and analyzed by clicking File>Open. Use the other formats to open the data using external applications.

Save a report using the following formats: • Comma Separated Values (*.csv) • Text with Tab Delimiters (*.txt)

(46)

Creating a Batch Version of a Teradata Manager Report

Save a graph using the bitmap image (*.bmp) format.

5 Click Save to save the file to the selected location.

Creating a Batch Version of a Teradata

Manager Report

Teradata Manager allows collection of all of the information about the currently displayed report where it can be saved to a batch file as a command. After this batch file is created, it can be scheduled to run at a specific time. When it is executed, the batch file creates an output file that can be opened in Teradata Manager.

For example, click Monitor>Sessions>Blocked to schedule a report to run every hour and record any blocked sessions.

Note: The command created when using this option contains your Teradata Database username and password. However, when the command is saved in a batch file, the password and authentication mechanism are encoded for security purposes.

To create a batch version of a Teradata Manager report

1 Display the applicable report in Teradata Manager. For example, click Monitor>Sessions> Blocked.

2 With the report window active, click File>Append Command to Batch File. The Append Command to Batch File dialog box appears.

The last argument of the displayed command is the name of the output file that the batch file creates. For example, Session.xml.

3 Click OK

The Open dialog box appears.

4 Navigate to the Teradata Manager BIN directory.

For example, C:\Program Files\NCR\Teradata Manager 12.0\BIN. Do one of the following:

• To create a new batch file that executes this command, enter a name for the batch file in the File Name field, using a file extension of .bat, and click Open to save the file to the BIN directory.

• To append this command to an existing batch file, select the applicable batch file so its name appears in the File Name field, then click Open.

5 Run the .bat file by scheduling it or executing it manually at any time. The executed file creates a report.

(47)

CHAPTER 4

Configuring Teradata Manager

Before using Teradata Manager, it must be configured. An overview of the process follows:

1 Set up the Teradata Database with the appropriate tables and macros

2 Add users, giving them access to the database contents

3 Define various system parameters

4 Enable data collection

The following topics explain how to perform these procedures in detail.

If configuring a new installation of Teradata Manager, complete steps one through eight. If upgrading Teradata Manager, perform steps one and two.

• Step 1 - Creating the Teradata Manager Databases, Tables, and Macros • 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 - Setting RSS Collection Rates • Step 8 - Enabling Data Collection

The following topics explain how to configure parameters and change options and settings: • Specifying an External DBQL for Data Collection and Trend Reporting

• Configuring AMP Usage Data Collection Parameters • Configuring DBQL Data Collection Parameters

• Configuring Teradata Dynamic Workload Management Data Collection Parameters • Configuring Heartbeat Query Data Collection Parameters

• Configuring Priority Scheduler Data Collection Parameters • Configuring Query Band Pairs 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

Teradata Manager. User Guide