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

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 201 202 203 204 205 206 < 207 > 208 209 210 211 212 213 .. 218 >> Next


work charges B-20 Archive types 8-21

all AMP database 8-21 all AMP tables 8-22 Data Dictionary 8-22 specific AMP 8-22 specific cluster 8-22 Archive/Recovery utility. See ARC utility Archives daily 8-26

Data Dictionary (DBC database) 8-23 Data Dictionary tables 8-27 phase processing 8-7 routines 8-26 types of 8-21 using FastExport 8-9 weekly 8-26 Arrays, spanning clusters across 7-37 Articles, NCR knowledge, accessing with

NCR@YourService 10-26 AS option 2-6 ASE

enabling 5-28 functionality of 5-27 interactions with utilities 5-31 system substitution variables 5-29 using effectively 5-28 using system variables 5-31 Automatic privileges 1-15 Automatic restarts 9-3 AWS console

finding hardware faults 12-10 troubleshooting hardware problems 12-10 troubleshooting hung jobs 12-23 troubleshooting Teradata RDBMS 12-2

Index -2

Teradata RDBMS Database Administration Index

B

Baseline profiles benefits of 13-13 guidelines and tools 13-14 logging queries during testing for 13-14 metrics for 13-13 performance metrics 13-13 tools for testing indexes for 13-14 tools for testing workloads for 13-14 Basic Teradata Query. See BTEQ utility BEGIN QUERY LOGGING statement 14-1, 14-3

options to 14-3 BEGIN TRANSACTION statement 7-16 Boot slice 7-26

Bottlenecks, solving chronic 12-28 BQLObjTbl table 14-5 BTEQ utility B-2, B-10, B-14, B-15 INSERT statement B-9 troubleshooting hung jobs 12-23 BUILD statement, ARC utility 8-32 BYNET, verifying C-7

C

CalDates table 1-6 Calendar view 1-6 Calendar view, creating a E-3 Capacity planning 5-39

tools for 13-1 Channel connections, adding 12-30 Channel environment overview A-23 session pools A-25 sessions A-25 Channel sessions A-25 session pools A-25 Channel-attached clients

software components A-23 Channel-connected clients

monitoring session parcels of 12-8 Character sets

cleint,viewing the status of A-9 client A-9

server, defaults for users A-7 Character sets, creating client E-3 Charge-back billing 5-39 Check constraints adding 2-8 dropping 2-8

CHECKPOINT privilege 6-5 CHECKPOINT statement, ARC utility 8-38 CheckTable Utility

checking for PPI errors with LEVEL 3 command 2-29 CheckTable utility

checking for incorrect partioning 2-33 checking row locations of PPI table 12-24 CheckTable utility, troubleshooting Teradata

RDBMS 12-2 Client character sets A-9

viewing the status of A-9 Client character sets, creating with DIPCCS E-3 Client configuration A-19 Client software, configuration and A-1 Client utilities, stored procedures and 2-76 Cliques 7-28

data integrity 7-28 description 7-28 shared access 7-28 spanning across clusters 7-36 Clusters

archiving by 7-37 changing assignments 7-35 determining size 7-35 spanning across arrays 7-37 spanning across cliques 7-36 COALESCE option 2-12 COLLECT DEMOGRAPHICS statement 13-7 COLLECT STATISTICS (Optimizer form) statement as CREATE INDEX statement 2-47 re-collecting with 2-47 use of 2-45

COLLECT STATISTICS (QCD Form) statement 13-7 Column

COMPRESS, state of presence bits 2-15 Identity, as PPI 2-24 PARTITION 2-31 PARTITION, referencing 2-31 Column-level constraints adding 2-8 changing 2-8 dropping 2-8 Columns adding 2-7

changing COMPRESS specification 2-7

changing default formats 2-7

changing title attributes 2-7

renaming 2-8

state of presence bits 2-15

using in a join that contains constants 2-13, 2-14

using in a join that contains NULLS 2-13, 2-14

Teradata RDBMS Database Administration

Index -3 Index

COMPRESS column, state of presence bits 2-15 COMPRESS option 2-14 COMPRESS phrase 2-14 Configuration

modifying Teradata RDBMS A-13 Teradata RDBMS and client software A-1 Configuration maps, Configuration utility A-13 Configuration utility activities A-14 adding AMPs A-17, A-18 AMPs A-13 maps A-13 Constraints

adding check 2-8 adding column-level 2-8 adding referential constraints 2-8 adding table-level 2-8 changing column-level 2-8 changing table-level 2-8 dropping check 2-8 dropping column-level 2-8 dropping referential 2-8 dropping table-level 2-8 Conversion, existing data management system to

Teradata RDBMS tables 2-64 COPY statement, ARC utility 8-31 Crashdumps E-4

calculating space 10-13 database protection 7-42 database protection considerations 10-12 database size considerations 10-13 fallback and 7-42 modifying space 10-13 PDE 10-2 space 10-13 types of 10-2 CREATE DATABASE privilege 1-2 CREATE DATABASE statement 5-3 CREATE DATABASE statement, logon security

and 5-6 CREATE MACRO statement 2-73 CREATE privilege 6-5 CREATE privilege, granting to users 5-8 CREATE statement 1-2 CREATE TABLE statement 2-4

copying AS a global temporary table 2-6 copying AS a volatile table 2-6 copying table with AS option 2-6 CREATE USER privilege 1-2 CREATE USER statement 1-7, 5-3 Creating

passwords 6-20

Creator privileges 1-14 Creator, rules of 1-14

CSP utility, deleting PDE crashdumps 10-34 csppeek command 10-9

ctl utility, troubleshooting Teradata RDBMS 12-2 CURRENTPERM 3-2 CurrentPerm permanent space 3-2 CurrentPerm, finding 3-17 CURRENTSPOOL 3-8 CurrentSpool spool space 3-8 CURRENTTEMP 3-11 CurrentTemp temporary space 3-11 Cylinder capacity, finding 3-12 Cylinder Read
Previous << 1 .. 201 202 203 204 205 206 < 207 > 208 209 210 211 212 213 .. 218 >> Next