Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

Teradata RDBMS Database Administration

Author: NCR
Publishers: NCR
Year of publication: 2004
Number of pages: 616
Read: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218
Download: teradatadatabaseadmin2004.pdf

Teradata

a division of NCR

Teradata® RDBMS

Database Administration

V2R5.0

B035-1093-122A February 2004 The product described in this book is a licensed product of NCR Corporation.



BYNET is an NCR trademark registered in the U.S. Patent and Trademark Office.

CICS, CICS/400, CICS/600, CICS/ESA, CICS/MVS, CICSPLEX, CICSVIEW, CICS/VSE, DB2, DFSMS/MVS, DFSMS/ VM, IBM, NQS/MVS, OPERATING SYSTEM/2, OS/2, PS/2, MVS, QMS, RACF, SQL/400, VM/ESA, and VTAM are trademarks or registered trademarks of International Business Machines Corporation in the U. S. and other countries. DEC, DECNET, MICROVAX, VAX and VMS are registered trademarks of Digital Equipment Corporation. HEWLETT-PACKARD, HP, HP BRIO, HP BRIO PC, and HP-UX are registered trademarks of Hewlett-Packard Co. KBMS is a trademark of Trinzic Corporation.

INTERTEST is a registered trademark of Computer Associates International, Inc.

MICROSOFT, MS-DOS, MSN, The Microsoft Network, MULTIPLAN, SQLWINDOWS, WIN32, WINDOWS, WINDOWS 2000, and WINDOWS NT are trademarks or registered trademarks of Microsoft Corporation. NetVault is a trademark of BakBone Software, Inc.

SAS, SAS/C, SAS/CALC, SAS/CONNECT, and SAS/CPE are registered trademarks of SAS Institute Inc.

SOLARIS, SPARC, SUN and SUN OS are trademarks of Sun Microsystems, Inc.

TCP/IP protocol is a United States Department of Defense Standard ARPANET protocol.

TERADATA and DBC/1012 are registered trademarks of NCR International, Inc.

UNICODE is a trademark of Unicode, Inc.

UNIX is a registered trademark of The Open Group.

X and X/OPEN are registered trademarks of X/Open Company Limited.

YNET is a trademark of NCR Corporation.



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



or write:



Information Engineering

NCR Corporation

100 North Sepulveda Boulevard

El Segundo, CA 90245-4361

U.S.A.



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 © 1996-2003, NCR Corporation All Rights Reserved Preface

Supported Software Release

This book supports Teradata RDBMS V2R5.0.

Changes to This Book

This book includes the following changes to support the current release:

Date Description
February 2004 Fixed example on how to use roles in Chapter 5: "Setting Up Users, Profiles, Accounts, and Accounting."
May 2003 Removed all references to ROWID values being 2 bytes longer for PPI tables. Added a footnote explaining that you can only specify ROWID in the outermost SELECT of a CREATE JOIN INDEX statement.
December 2002 New work on this book for V2R5.0 includes new features and enhancements to existing features: • Developed new chapter, Chapter 13: "Database Analysis Tools", to group and document administrative use of the new and enhanced tools, including TLE, TSET, QCF, and new SQL statements and client tools to collect demographic and statistical data and analyze index use, including: - COLLECT DEMOGRAPHICS and the new QCD form of COLLECT STATISTICS, which can derive probable statistics from a specified percentage of sampled index columns. - Enhancements to the Optimizer form of COLLECT STATISTICS to collect on sampled columns and non-index columns. - INSERT/DUMP EXPLAIN for demographic and statistical data capture into QCD. - VALIDATE INDEX and associated statements. - Teradata Index Wizard to analyze and optimize secondary indexes - Teradata Statistics Wizard to determine statistics candidates - Teradata Visual Explain Utility, now a stand-alone client facility • Developed new chapter, Chapter 14: "Tracking Processing Behavior with the Database Query Log (DBQL)" to describe the new DBQL feature, which can record in a suite of logs query performance results by specified time interval or threshold, targeted objects by query, and some or all of the query SQL text.
< 1 > 2 3 4 5 6 7 .. 218 >> Next