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


creating table for 12-16 dumplocklog utility, troubleshooting Teradata

RDBMS 12-4 Dumps

access protection with FALLBACK 10-11

capturing system 11-3

changing Windows 2000 paging file size in

system 11-11 handling UNIX system 11-4 location of system 11-2 saving UNIX system 11-7

sending tapes to Teradata Support Center 11-14 setting save options on UNIX system 11-4 setting up Windows 2000 Application Log

system 11-9 UNIX system 11-6 viewing UNIX system 11-8 viewing Windows 2000 system 11-9 Windows 2000 system 11-9 with down AMP and no FALLBACK 10-11

E

Encryption, passwords 6-23

END QUERY LOGGING statement 14-1, 14-3

effect on active sessions 14-19 Ending hung tasks 12-24 Error 3710, resolving 12-13 Error 3711

resolving 12-13 Error 7550, resolving 12-12 Error logs C-1 AWS C-4 displaying C-5 node C-2 summary C-2 viewing C-5 viewing node C-6 viewing the console log C-5 Error message logs, creating with DIPERR E-4 errpt utility, displaying error logs C-5 Event logs C-1

Events_Configuration view 8-46 EXECUTE MACRO statement 2-73 EXECUTE privilege 6-5

needed on DBQLAccessMacro 14-21 Exits, TDP

controlling password security 6-20 Expansion, determining needs for Teradata

RDBMS 12-28 Expansion, tools for estimating need 12-19 Explicit privileges 1-15, 6-3

F

Fallback

accessing dumps with down AMP 10-11 activating 7-34 adding protection 2-8 AMP clusters 7-32

Index -8

Teradata RDBMS Database Administration Index

automatic data protection 7-3 clustering with 7-32 crashdumps and 7-42 data protection option 7-41 down-AMP recovery journal 7-34 failure handling 7-33 journaling of 7-39 protected Data Dictionary tables 4-3 removing protection 2-8 versus permanent journals 7-39 FastExport utility B-4, B-10, B-15 backing up data 8-9 monitoring a job B-25 partitions used B-26 FastLoad utility B-3, B-9, B-10, B-14, B-15 data transfer phase B-18 loading tables B-9 monitoring B-16 phases B-17 recovery versus ARC 8-9 resource usage B-16 restoring data 8-9 sessions B-17 Ferret utility

DEFRAGMENT command 12-3 finding tables for packing using SHOWFSP 3-19 making space with PACKDISK 3-19 PACKDISK command 3-19, 12-3, 12-4, 12-11 SCANDISK command 12-3 SHOWFSP command 3-19, 12-3 SHOWSPACE command 12-3, 12-5 troubleshooting Teradata RDBMS 12-3 FLAG_ TIMEOUT option, dump area management on

UNIX 11-5 Free Space Percent changing 2-8, 12-11 packing and 3-19 setting limits 3-5 FSUDRIVER command, viewing Cylinder Slot information 15-6

Gateway Global utility A-34

Gateway Global utility, troubleshooting Teradata

RDBMS 12-4 GIVE statement 1-2, 1-17 GIVE statement, transferring ownership 1-17 Global tables, versus volatile 2-19 Global temporary tables 2-17 changing LOG options 2-8 changing ON COMMIT options

LOG option 2-8 materializing 2-18 GRANT LOGON statement 6-24 GRANT LOGON statement, conditions for

using 6-24 GRANT privilege 6-5 GRANT statement 6-11 GROUP BY clause 2-13

Group level, controlling privileges with roles 6-15 Group read lock option, ARCHIVE statement 8-20

H

Hardware, finding faults 12-10 HASH functions, testing a schema 2-49 Hash indexes 2-37 adding 2-8

collecting statistics 2-46 dropping 2-8 HASHAMP function 2-49 HASHBUCKET function 2-49 HASHROW function 2-49 Host logon control 6-23 Host Utility (HUT) locks, releasing 12-5, 12-25 HSI timestamp tool, troubleshooting client

connections 12-8 HUT locks

see Host Utility (HUT) locks 12-25 HUT locks, monitoring B-24

G

Gateway A-34 Gateway Control utility A-34 DISPLAY GTW command 12-9 DISPLAY NETWORK command 12-9 DISPLAY SESSION command 12-9 KILL command 12-9 troubleshooting network connections 12-9 troubleshooting Teradata RDBMS 12-4

I

Identity Column as PPI 2-24 Immediate owner, rules of 1-14 Implicit privileges 1-15, 6-3 INDEX privilege 6-6 Index Wizard

see Teradata Index Wizard utility 13-7 Index Wizard utility 13-7 Indexes 2-21

Teradata RDBMS Database Administration

Index -9 Index

analyzing efficiency of 13-4 changing a PPI with ALTER TABLE 2-7 changing the version number by altering 2-79 checking for incorrect partitioning 2-33 collecting hash index statistics 2-46 collecting join index statistics 2-46 collecting statistics for 2-46 controlling memory for join/hash 2-39 controlling memory when insufficent for

Optimizer 2-39 costing and verifying 2-44 creating 2-40 defining a PPI 2-25 defining, considerations when 2-21 dropping 2-43 hash 2-37 join 2-37

join, resolving insufficient memory for 12-12

performance advantages 2-21

primary 2-22

prototyping 2-50

prototyping join 2-54

prototyping primary 2-51

proving secondary with EXPLAIN 2-36

proving secondary with Teradata Visual

Explain 2-36 proving secondary with TLE 2-36, 13-3, 13-10 resolving insufficient memory for

Optimizer 12-13 revalidating primary 2-33 secondary 2-35 Indexes option, ARCHIVE statement 8-19 Inherited privileges 6-15 INSERT EXPLAIN statement 13-7, 13-8 INSERT EXPLAIN WITH STATISTICS AND
Previous << 1 .. 204 205 206 207 208 209 < 210 > 211 212 213 214 215 216 .. 218 >> Next