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 .. 206 207 208 209 210 211 < 212 > 213 214 215 216 217 .. 218 >> Next


hashing algorithm with 2-22 PARTITION column 2-31 PARTITION column, referencing 2-31 Partitioned 2-30 Partitioning

changing RoundHalfwayMagUp 2-33 effects of expression errors 2-25, 2-26 flag bit indicator in row ID 2-30 operations on tables with, resolving insufficient

memory with PPICacheThrP field 12-12 solving errors 12-27 using in a primary index 2-25 Passwords

assigning a temporary 6-20 controlling security 6-20 creating 6-20 customizing controls 6-21 DBC.Users view and 6-21 default values 6-21 defining system-level attributes in

DBC.SecurityDefaults view 4-4 encryption 6-23 modifying 6-21 null 5-6

releasing password lock 6-20 securing access 6-20 securing access with 6-20 specifying control preferences in DBC.SecurityDefaults 6-22 PDE crashdumps after restarts 10-20 automatic 10-17 backing up 10-31 capturing a dump 10-5 checking for 10-7 checking the Dump directory 10-8 Copy Save Program 10-22 copying a dump 10-5 copying to tape 10-26, 10-31 crashloop control 10-19 deleting 10-34

deleting using Coroner utility 10-34

Index -12

Teradata RDBMS Database Administration Index

deleting using CSP utility 10-34

deleting using Windows Explorer 10-35

DIPCRASH script file 10-11

error logging 10-21

error messages location 10-23

events causing 10-17

forcing 10-18

getting information 10-6

save considerations 10-20

saving 10-5, 10-22

saving crashloop 10-21

saving manually 10-21

saving on UNIX 10-20

sending a dump to TSC 10-5

setting up the system to save dumps 10-20

stages 10-2

time considerations 10-20 versus system dumps 10-4 viewing information 10-7 viewing information using BTEQ 10-8 viewing messages 10-9 writing files into DBC.Crashdumps 10-23 PDE crashdumps, saving with DUL utilities 10-27 pdeconfig utility, slicing LUNs 7-26 Peak disk space

clearing values from DBC.DatabaseSpace 4-15 Peak values

archiving 4-15 resetting 3-13, 4-15 PEAKPERM 3-3 PeakPerm permanent space 3-3 PEAKSPOOL 3-8 PeakSpool spool space 3-8 PEAKTEMP 3-11 PeakTemp temporary space 3-11 Performance

advantages of indexes 2-21 analyzing 2-53

anomalies, tools for eliminating 13-1 testing, tools for 2-50 tools for monitoring D-1 Performance Monitor D-6

collecting node/vproc data D-6 collecting session-level data D-7 description of D-8 displaying ResUsage reports D-11 finding hardware faults 12-10 invoking D-8

reporting node/vproc data D-6 reporting session-level data D-7 troubleshooting hardware problems 12-10 Performance, application

tools for improving 13-1 Permanent journals 2-78 after image 2-78 allocating space 7-39 assigning 2-83 backing up using ARC 2-81 before image 2-78 changing 2-8 creating 2-8, 2-82 current 2-80 data integrity 7-38 data protection option 7-41 deleting 2-82, 7-40

deleting contents of restored journal areas 2-81

deleting contents of saved journal areas 2-81

dropping 2-8

dual image 2-78

location of 2-78, 2-82

options 7-38

prevented from rolling 2-83 protection 2-78, 7-38 recovering using ARC utility 2-81 replacing a data row by its after-change

image 2-81 replacing a data row by its before-change

image 2-81 restoring 2-80

roll back with before-image 2-79 roll forward with after-image 2-79 single image 2-78 subtables 2-80

using for recovery with the ARC utility 8-4 versus fallback 7-39 Permanent space 3-2 allocating 3-2 CurrentPerm 3-2 defining 3-2

increasing by giving ownership 3-20 MaxPerm 3-3 PeakPerm 3-3 transferring 3-20 PEs, adding 12-30 Phrases

COMPRESS 2-14 DEFAULT 2-12 NULL 2-12

PI

affects of altering on ARC functions 2-27 changing the table version number by altering 2-79 PM/API, SET SESSION ACCOUNT request 5-23 PPI

changing fields in DBS Control for insuffient parser

Teradata RDBMS Database Administration

Index -13 Index

memory 12-13 changing the table version number by

altering 2-79 checking for errors with CHECKTABLE LEVEL 3

command 2-29 checking for incorrect partitioning 2-33 checking row locations with CheckTable LEVEL 3

command 12-24 controlling memory when insufficient for

Optimizer 2-39 defining as Identity Column 2-24 defining, rules of 2-25 distribution of 2-30 imposing a UNIQUE contraint on 2-26 resolving insufficient memory for 12-12 resolving insufficient memory for

Optimizer 12-13 resolving transaction rollbacks 12-26 row IDs for tables with 2-30 solving errors 12-27 PPI operations

controlling memory for with PPICacheThrP 2-28, 2-33 PPICacheThrP

controlling memory for PPI operations 2-33 PPICacheThrP field 2-28

resolving insufficient memory for operations on partitioned tables 12-12 PRIMARY INDEX PARTION BY option 2-25 Primary indexes 2-22 prototyping 2-51 redefining 2-7 PRIMARY KEY option, with partioning 2-26 Priority Scheduler Administrator 15-11 Priority Scheduler Administrator. See PSA 12-19 Priority Scheduler utility, controlling resource

contention 15-9 Priority, account

Changing dynamically 5-23 Privileges 1-14 access by 6-37 access summary 6-4 automatic 1-15 CHECKPOINT 6-5
Previous << 1 .. 206 207 208 209 210 211 < 212 > 213 214 215 216 217 .. 218 >> Next