Download (direct link):
• Chapter 2: "Building the Teradata RDBMS" describes the special objects that make up the Teradata RDBMS system and data dictionary, and how to use indexing and partitioning to gain better performance through even row distribution, partition elimination, efficient joining, and other methods.
• Chapter 3: "Space Considerations" shows you how to allocate disk space for your Teradata RDBMS, monitor available disk space, and use various tools and utilities to improve performance or conserve or free up space.
• Chapter 4: "Using Data Dictionary Tables and Views" describes the Data Dictionary (DD), a complete catalog of your Teradata RDBMS composed of system tables, views, and macros that reside in user DBC. Also discussed are maintenance procedures you should perform on some system tables.
• Chapter 5: "Setting Up Users, Profiles, Accounts and Accounting" discusses how to set up and administer users, accounts, roles, and profiles on your Teradata RDBMS.
• Chapter 6: "Controlling Access" provides information on controlling access to your Teradata RDBMS. It contains information on user privileges, controlling user access to data and to the Teradata RDBMS, and how to track access attempts.
vi Teradata RDBMS Database AdministrationPreface
About This Book
• Chapter 7: "Protecting Data" discusses how to take advantage of the variety of automatic and optional data protection features provided by disk arrays and the Teradata RDBMS.
• Chapter 8: "Archiving, Restoring and Recovering Data" discusses how to backup, restore and recover data on your Teradata RDBMS.
• Chapter 9: "Stopping and Restarting the System" provides information and procedures on stopping and restarting the Teradata RDBMS.
• Chapter 10: "Handling Teradata Crashdumps" discusses PDE crashdumps, snapshot dumps, fault isolation dumps, and freeze dump elimination, how to modify the DBC.Crashdumps database, and provides crashdump management procedures and procedures for using DUL and DULTAPE. |
• Chapter 11: "Handling System Dumps" provides information on system dumps management for NCR UNIX MP-RAS and Windows 2000 system dumps, and where to mail dump tapes.
• Chapter 12: "Troubleshooting"describes the tools available for finding, preventing, and resolving issues with hung or slow jobs, network sessions, channel sessions, and hardware, and tools for determining the need for and implementing a configuration expansion.
• Chapter 13: "Database Analysis" discusses how to set up a query analysis database, gather demographic and statistical data with the suite of new SQL statements, and apply the automatic analysis tools, including Target Level Emulation (TLE), Teradata System Emulation Tool (TSET), Query Capture Feature (QCF) and the Query Capture Database (QCD), the Teradata Index Wizard, and the Teradata Visual Explain Utility. This chapter also explains how you can use the output provided by these tools to build baseline transaction profiles.
• Chapter 14: "Tracking Processing Behavior with the Database Query Log (DBQL)" describes how the log tables are created, protected, and populated, and explains how to enable and disable logging activity, determine what options to use, and define the logging rules.
• Chapter 15: "Tools for Managing Resources" discusses tips and tools that are useful in administering your Teradata in such a way as to minimize the occurrence of impeded performance, maximize throughput, and manage the consumption of resources. Tools discussed include Cylinder Read, the Priority Scheduler, the Priority Scheduler Administrator (PSA), and the Teradata Dynamic Query Manager (TDQM).
• Appendix A: "Teradata RDBMS Configuration, Global Defaults, and Client Connections" provides an overview of your Teradata RDBMS configuration and interface and utilities software for network and channel-connect
clients, and introduces you to the major global default settings and how to I review or change them. |
• Appendix B: "Import/Export Utilities" provides information to help you decide which import/export utility to use for a particular operation. It also discusses how to monitor import/export jobs.
• Appendix C: "Error Logs" describes the various types of event logs and error logs you can review to identify problems on the system.
vi Teradata RDBMS Database Administration
About This Book
• Appendix D: "Tools for Monitoring Performance" describes various tools you can use to monitor the operation of your Teradata RDBMS system, including Teradata Performance Monitor, Performance Monitor Applications Interface (PM/API), and Resource Usage.
• Appendix E: "Database Initialization" introduces you to the Database Initialization Program (DIP) utility and the uses of the special system objects created by the executable SQL script files.
You should have some knowledge of:
• Relational database concepts
• Teradata Structured Query Language (Teradata SQL)
• The Teradata RDBMS configuration