Teradata Data Warehouse Appliance 2580 Implementation Guide

388 Pages·2010·2.36 MB·English

by  Teradata Information Engineering

Teradata Data Warehouse Appliance 2580
Implementation Guide
Release 13.0
B035-1193-129K
July 2010
The product or products described in this book are licensed products of Teradata Corporation or its affiliates.
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, RACF, Tivoli, and z/OS 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 are trademarks or registered trademarks of QLogic Corporation.
SAS and SAS/C are trademarks or registered trademarks of SAS Institute Inc.
SPARC is a registered trademark 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.
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 TERADATA CORPORATION 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 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.
Copyright © 2010 by Teradata Corporation. All Rights Reserved.
Preface
Purpose
This guide describes the tasks required to implement database operations on the Teradata
Data Warehouse Appliance 2580, including:
(cid:127) Configuring the system and its connected clients
(cid:127) Monitoring system hardware health and addressing common problems
(cid:127) Converting existing database table definitions and queries to Teradata SQL
(cid:127) Moving data from an existing database into Teradata Database
(cid:127) Creating Teradata Database users, databases, tables, and other objects
(cid:127) Granting database access privileges, logging access attempts, and performing audits of
security logs
(cid:127) Monitoring database activity, performing periodic maintenance, and using performance
tuning features
Note: Perform the tasks and procedures in the order they are presented, except where
otherwise directed in the text.
The procedures and recommendations presented are the minimum required to implement
database operations on a Teradata Data Warehouse Appliance 2580. Teradata offers numerous
additional capabilities and options. Reference information tables appear at the end of many
procedures that provide links to related information.
Audience
This guide is intended for first time users of Teradata Database:
(cid:127) Planners
(cid:127) Administrators
(cid:127) System programmers
Supported Software Release
This book supports Teradata® Database 13.0.
Teradata Data Warehouse Appliance 2580 Implementation Guide 3
Preface
Changes to This Guide
Changes to This Guide
This guide includes the following changes to support the current release:
Release Description
Teradata Database 13.0 Added an introductory chapter and three appendixes.
July 2010
Teradata Database 13.0 Initial release
March 2010
Additional Information
URL Description
www.info.teradata.com/ Use the Teradata Information Products Publishing Library
site to:
(cid:127) View or download a manual:
1 Under Online Publications, select General Search.
2 Enter your search criteria and click Search.
(cid:127) Download a documentation CD-ROM:
1 Under Online Publications, select General Search.
2 In the Title or Keyword field, enter CD-ROM, and
click Search.
(cid:127) Order printed manuals:
Under Print & CD Publications, select How to Order.
www.teradata.com The Teradata home page provides links to numerous
sources of information about Teradata. Links include:
(cid:127) Executive reports, case studies of customer experiences
with Teradata, and thought leadership
(cid:127) Technical information, solutions, and expert advice
(cid:127) Press releases, mentions and media resources
www.teradata.com/t/TEN/ Teradata Customer Education designs, develops and
delivers education that builds skills and capabilities for
our customers, enabling them to maximize their Teradata
investment.
www.teradataatyourservice.com Use Teradata @ Your Service to access Orange Books,
technical alerts, and knowledge repositories, view and join
forums, and download software patches.
4 Teradata Data Warehouse Appliance 2580 Implementation Guide
Preface
References to Linux and Windows
URL Description
developer.teradata.com/ Teradata Developer Exchange provides articles on using
Teradata products, technical discussion forums, and code
downloads.
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-
[email protected].
References to Linux and Windows
This guide makes various references to “Linux” and “Windows.”
(cid:127) The Teradata Data Warehouse Appliance 2580 runs on SUSE Linux Enterprise Server 10,
which is referred to in the text as “Linux.”
(cid:127) All references to Teradata clients assume that these clients run a supported version of
Microsoft Windows. The general term “Windows” is used except in cases where a reference
is dependent on a specific version of Microsoft Windows.
Teradata Data Warehouse Appliance 2580 Implementation Guide 5
Preface
References to Linux and Windows
6 Teradata Data Warehouse Appliance 2580 Implementation Guide
Table of Contents
Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
Purpose . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
Audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
Supported Software Release. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
Changes to This Guide. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4
Additional Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4
References to Linux and Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
Chapter 1: Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Assumptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Organization of This Book. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
System and Environment Setup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Implementation of Databases, Tables, and Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Ongoing Maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Chapter 2: System Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Hardware Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Example Cabinet Configurations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Cabinet Component Descriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Customer Network and Mainframe Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Hardware Data Protection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
System Scalability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
Teradata Database Software Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
Parallel Database Extensions (PDE). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
Teradata Database Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
Teradata Data Warehouse Appliance 2580 Implementation Guide 7
Table of Contents
Chapter 3: Setting Up and Using SMWeb and SMClient . . . . . . .43
Required Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43
Assumptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43
SMWeb Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44
Task 1: Set Up a Workstation for Use with SMWeb . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .45
Procedure 1a: Set Up an Internet Explorer Browser on a Windows Workstation. . . . . . .46
Procedure 1b: Set Up a Firefox Browser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47
Procedure 2: Set Up Software on a Workstation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47
Task 2: Access the SMWeb Home Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47
Procedure 1a: Navigate to the SMWeb Home Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47
Procedure 1b: Navigate to the SMWeb Home Page from a Non-SOV CMIC. . . . . . . . . .48
Task 3: Set Up User Access to SMWeb Applications and Web Pages . . . . . . . . . . . . . . . . . . . .48
Procedure: Add a User, Enhanced User, or Service User. . . . . . . . . . . . . . . . . . . . . . . . . . .49
Task 4: Set Up Server Management Command Line Interface Utilities . . . . . . . . . . . . . . . . . .50
Procedure 1a: Set Up SMWeb CLI Utilities on a Windows Workstation. . . . . . . . . . . . . .50
Procedure 1b: Set Up SMWeb CLI Utilities on a Linux Workstation. . . . . . . . . . . . . . . . .51
Task 5: Set Up an Alert Subscription . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .51
Configuring SNMP Traps. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .52
Procedure 1: Creating an Alert Subscription for SNMP Traps . . . . . . . . . . . . . . . . . . . . . .52
Procedure 2: Retrieving the SNMP Trap Definition (MIB File) . . . . . . . . . . . . . . . . . . . . .53
SNMP Trap Definitions in the SMAlertingMIB.txt File. . . . . . . . . . . . . . . . . . . . . . . . . . . .53
Task 6: Set Up SMClient Default Views Used to Monitor the System. . . . . . . . . . . . . . . . . . . .56
Procedure: Set Up SMClient Default Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .56
SMClient Default Views Used to Monitor the System. . . . . . . . . . . . . . . . . . . . . . . . . . . . .58
Task 7: Monitor System Health Using SMClient. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .64
Procedure 1: Monitoring the Alert Viewer for System Alerts . . . . . . . . . . . . . . . . . . . . . . .64
Procedure 2: Determining When to Take Action to Fix a Problem . . . . . . . . . . . . . . . . . .66
Task 8: Take Action to Fix a Problem with a Customer-Replaceable Hardware
Component . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .66
Procedure 1: Taking Action to Fix the Problem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .66
Procedure 2: Opening a Maintenance Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .67
Procedure 3: Closing a Maintenance Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .67
Procedure 4: Determining Whether Your Action Solved the Problem. . . . . . . . . . . . . . . .68
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .68
Task 9: Open an Incident Using Teradata@YourService . . . . . . . . . . . . . . . . . . . . . . . . . . . . .69
When to Open an Incident. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .69
Procedure 1: Gathering Needed Supporting Information for an Incident. . . . . . . . . . . . .69
Procedure 2: Opening Incidents Through Teradata@YourService . . . . . . . . . . . . . . . . .69
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70
8 Teradata Data Warehouse Appliance 2580 Implementation Guide
Table of Contents
Chapter 4: Setting Up Teradata Clients . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Required Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Client Software Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Supported Platforms. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Task 1: Review Software and Installation Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74
Administrative and Non-Administrative Installations. . . . . . . . . . . . . . . . . . . . . . . . . . . . 74
Task 2: Install the Teradata Manager Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
Task 3: Install Microsoft .NET Framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
Task 4: Install Teradata Tools and Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
Task 5: Download and Install Latest Updates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79
Procedure 1: Download the Latest Updates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80
Procedure 2: Install the Latest Updates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
Task 6: Download the Windows Help Program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
Task 7: Configure Network Name Resolution. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
Task 8: Create Environment Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83
Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84
Task 9: Create ODBC Data Sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84
Procedure 1: Set up a Teradata Data Source . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84
Procedure 2: [Optional] Set up an External ODBC Data Source . . . . . . . . . . . . . . . . . . . 86
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87
Task 10: Initialize Teradata Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87
Procedure 1: Create the Teradata Manager Database Infrastructure . . . . . . . . . . . . . . . . 87
Procedure 2: Create Teradata Manager User DBCMANAGER. . . . . . . . . . . . . . . . . . . . . 88
Procedure 3: Start Teradata Manager on the Teradata Manager Server. . . . . . . . . . . . . . 89
Procedure 4: Start the Teradata Manager Windows Service . . . . . . . . . . . . . . . . . . . . . . . 90
Procedure 5: Connect Teradata Manager to the Service . . . . . . . . . . . . . . . . . . . . . . . . . . 91
Task 11: Restart the Client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92
Chapter 5: Allocating Space and Creating an
Administrative User . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97
Required Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97
Teradata Data Warehouse Appliance 2580 Implementation Guide 9
Table of Contents
Task 1: Preparing for Administration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .97
Procedure 1: Set up Teradata Administrator GUI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .97
Procedure 2: Set the Data Directory. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .98
Setting Global Default Values. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .98
Procedure 3: Change Locking Logger Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .98
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .99
Procedure 4: Change the PasswordExpire Parameter and Restart the Database. . . . . . . .99
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .100
Task 2: Assigning Space for System-Level Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .100
Database Space. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .100
System-Generated Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .101
Procedure: Assign Perm Space to Crashdumps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .101
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .103
Procedure: Create a Spool Space Reserve . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .103
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .105
Task 3: Setting Up the Database Administrator User . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .105
Procedure 1: Create the DBADM Profile. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .105
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .107
Procedure 2: Create User DBADMIN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .107
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .109
Procedure 3: Grant Database Privileges to User DBADMIN. . . . . . . . . . . . . . . . . . . . . . .110
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .115
Task 4: Setting Up Administrators to Monitor Teradata Database Activity. . . . . . . . . . . . . .115
Procedure 1: Add Administrative Users to Teradata Manager . . . . . . . . . . . . . . . . . . . . .115
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .117
Procedure 2: Reset the Profile for a Teradata Manager User. . . . . . . . . . . . . . . . . . . . . . .117
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .118
Chapter 6: Creating Databases, Tables, and Views . . . . . . . . . . .121
Task 1: Creating Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .121
Procedure 1: Creating the Tables Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .122
Procedure 2: Creating the Views Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .124
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .126
Task 2: Creating Tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .126
Procedure 1: Converting Existing Tables to Teradata Tables . . . . . . . . . . . . . . . . . . . . . .127
Procedure 2: Starting the Basic Teradata Query Utility. . . . . . . . . . . . . . . . . . . . . . . . . . .129
Procedure 3: Creating Tables in Teradata . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .130
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .135
Procedure 4: Choosing a Primary Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .136
Reference Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .139
10 Teradata Data Warehouse Appliance 2580 Implementation Guide