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


controlling at the group level with roles 6-15

controlling inherited with ALL option 6-15

CREATE 6-5

CREATE DATABASE 1-2

CREATE USER 1-2

creator, with roles and profiles 5-12

DBC.AllRights view and 6-9

DBC.UserGrantedRights view and 6-9

DBC.UserRights view and 6-9 DELETE 6-5 DROP 6-5

DROP DATABASES 1-2 DROP USER 1-2 DUMP 6-5 EXECUTE 6-5

EXECUTE, needed on DBQLAccessMacro 14-21 explicit 1-15, 6-3 GRANT 6-5 GRANT statement 6-11 granting 6-37 granting CREATE 5-8 implicit 1-15, 6-3, 6-16 INDEX 6-6 INSERT 6-6 on system views 4-8 owner versus creator 1-14 ownership 6-7 REFERENCES 6-6 REPLACE 6-6 RESTORE 6-6 REVOKE statement 6-13 SELECT 6-6 summary of 6-4 transferring 6-16 types of 6-2 UPDATE 6-6 viewing 6-9 Profile

creator privileges 5-12 user default, effects of dropping 4-4 Profiles

implementing 5-12 Profiles, baseline benefits of 13-13 guidelines and tools 13-14 logging queries during testing for 13-14 metrics for 13-13

tools for testing workloads for 13-14 Profiles, basline 13-14 Protection

activating fallback 7-34 journaling 2-78 permanent journals 7-38 transaction data 7-15 PSA

scheduling priority of account access 12-19 puma command

troubleshooting hung jobs 12-24 troubleshooting Teradata RDBMS 12-4 puma -p command 12-24

Index -14

Teradata RDBMS Database Administration Index

Q

QCD database 13-4

creating 13-4 QCF

creating QCD database 13-4 inputting source to Database Query Analysis tools 13-4 QFC, implementing 13-4 QryLog view 14-6 QryLogObjects view 14-6 QryLogSQL view 14-6 QryLogSteps view 14-6 QryLogSummary view 14-6 Queries, manipulating scheduling priorities 5-25 Query analysis tools, testing a schema 2-49 Query Capture database. See QCD. 13-4 Query Capture Facility. See QCF Query Session utility 12-24 Query Session utility, troubleshooting Teradata

RDBMS 12-4 Query throughput, mproving 13-1

R

RAID

array configuration 7-23 availability comparison 7-27 disk array architecture 7-23 disk arrays and 7-5 disk configuration 7-23 failure handling comparison 7-27 level comparison 7-26 management tools comparison 7-28 operation comparison 7-27 overhead comparison 7-27 throughput comparison 7-27 RAID 1 7-5, 7-26 RAID 5 7-5, 7-26

calculating parity 7-6 disk throughput comparison 7-27 RAID disk configurations drive groups 7-24 LUNs 7-24 ranks 7-23 RAID Manager, drive groups 7-24 RAID S 7-26

RAID S, calculating parity 7-6 Reconfiguration utility

behavior during restarts 9-3

restart behavior and 9-3 using after expansion 12-31 Reconfiguration utility, activities A-15 Record formats B-7 Recovery 9-8

automatic, with fallback protection 7-4 data 7-6 overview 8-37 phase processing 8-7 transaction 9-9 using roll operations 8-37 Recovery control views 8-44 DBC.Association 8-44 DBC.Events 8-45 DBC.Events_Configuration 8-46 DBC.Events_Media 8-46 Recovery Manager utility, troubleshooting Teradata

RDBMS 12-4 REFERENCES clause 7-7 REFERENCES privilege 6-6 REFERENCES WITH CHECK OPTION clause 7-7 REFERENCES WITH NO CHECK OPTION

clause 7-7 Referential constraints adding 2-8 dropping 2-8 Referential integrity 7-7 Batch, constraints with 7-7 constraints 7-7 solving errors 12-27 turning off constraints with NO CHECK OPTION 7-7 Relational data structures, converting to 2-62 RELEASE LOCK statement, ARC utility 8-33, 12-5,

12-25, B-24 RELEASE PASSWORD LOCK option 6-20 RENAME TABLE statement, recreating a table 2-5 REPLACE MACRO statement 2-73 REPLACE privilege 6-6 Reports, ResUsage D-11 Request parcels A-21 Requests

unsuccessful 7-15 unsuccessful in Teradata mode 7-16 Resource Check Tools utility D-4 dbschk command 12-2 preventing hangs 12-21 Resource control 5-39 Resource priorities, scheduling 15-9 Resource Usage

creating macros with DIPRUM E-4 creating tables with DIPRSS E-4

Teradata RDBMS Database Administration

Index -15 Index

creating views with DIPRUM E-4 determining congested resources 12-25 reporting capabilities D-11 resolving slow or hang events 12-26 testing indexes for baseline profiles 13-14 troubleshooting hung jobs 12-25 Resource usage B-16

displaying ARC sessions with Teradata

Manager B-20 FastExport utility and B-25 FastLoad utility B-16 managing I/O with Cylinder Read 15-2 MultiLoad utility B-17 Resource utilization

tools for managing 13-1 Response parcels A-21 Restarts 9-8 automatic 9-3 cold 9-3 coldwait 9-3 event logs 9-11 forced 9-5

impact on hardware components 9-4 impact on vprocs 9-5 performing offline catch-up 9-10 performing online catch-up 9-10 recovering transactions 9-9 status logs 9-11 Teradata RDBMS 9-3 transaction recovery 9-9 UNIX 9-6

using recovery journals 9-10 Windows 2000 9-7 Restore

using FastLoad 8-9 RESTORE privilege 6-6 RESTORE statement, ARC utility 8-29 Restores

Data Dictionary tables 8-27 ResUsage

reports, testing a schema 2-49 REVALIDATE PRIMARY INDEX option 2-29, 2-33 REVALIDATE REFERENCES FOR statement, ARC

utility 8-32 REVOKE LOGON statement 6-24 REVOKE LOGON statement, conditions for
Previous << 1 .. 207 208 209 210 211 212 < 213 > 214 215 216 217 .. 218 >> Next