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


defining system-level password attributes 4-4 updating 6-17 DBC.SessionInfo view 6-30

DBC.SessionInfo view, finding session source 6-30 DBC .Software_Event_Log view 12-10, 12-11 finding hardware faults 12-10 troubleshooting hardware problems 12-10 DBC.SW_Event_Log table 6-36 DBC.SW_Event_Log, troubleshooting hung

jobs 12-24 DBC.SysSecDefaults table 6-21, 6-22 DBC.TableConstraints view 2-28 DBC.TableSize view 3-15

comparing results with DBC.DiskSpace view 3-18 DBC.TableSize view, troubleshooting Teradata

RDBMS 12-6 DBC.UserGrantedRights view 6-9 DBC.UserRights view 6-9 DBC.Users view 6-21 DBQL

applying logged data 14-15 controlling dynamically 14-19 controlling with SQL statements 14-3 defining the rules 14-15 logging for baseline profiling 13-14 logging query processing activity 14-1 logging volume by type 14-16 protection of committed rows 14-27 purpose of components 14-5 reducing overhead 14-16 results 14-17 reviewing rules 14-19 scheduling workloads for baseline profile

testing 13-14 testing a database 2-50 validating rules 14-21 DBQL log tables DBQLLogTbl 14-5

Index -6

Teradata RDBMS Database Administration Index

DBQLObjTbl 14-5 DBQLRuleCountTbl 14-5 DBQLRuleTbl 14-5 DBQLSQLTbl 14-5 DBQLStepTbl 14-5 DBQLSummaryTbl 14-5 default row fields 14-7 objects row fields 14-10 SQL row fields 14-11 step row fields 14-11 summary row fields 14-12 DBQL macro, DBQLAccessMacro 14-6 DBQL views

DBQLRules 14-6 QryLog 14-6 QryLogObjects 14-6 QryLogSQL 14-6 QryLogSteps 14-6 QryLogSummary 14-6 DBQLAccessMacro macro 14-6 DBQLLogTbl table 14-5 DBQLRuleCountTbl table 14-5 DBQLRules view 14-6 DBQLRuleTbl table 14-5 DBQLSQLTbl table 14-5 DBQLStepTbl table 14-5 DBQLSummaryTbl table 14-5 DBQM

implementing 15-13 overview 15-12 rules 15-12 DBS Control Utility

changing for insufficient parser memory 12-13 changing RoundHalfwayMagUp for partitioning

expressions 2-33 controlling PPICacheThrP for PPI operations 2-33 enabling TLE 13-3 DBS Control utility

changing FreeSpacePercent 12-11 controlling memory for PPI operations 2-28 troubleshooting Teradata RDBMS 12-2 dbschk command, troubleshooting Teradata

RDBMS 12-5 Deadlock, resolving 12-25 default 4-4

Default attribute, user, dropping 4-4

Default attributes, user, affects of dropping 4-4

DEFAULT phrase 2-12

DEFRAGMENT command, Ferret utility 12-3

DELETE DATABASE statement 1-19

DELETE function, ARC utility 2-81

DELETE JOURNAL statement, ARC utility 8-43

DELETE privilege 6-5

DELETE USER statement 1-19

Deleting PDE crashdumps using Windows

Explorer 10-35 Derived tables, versus volatile 2-19 determining number and ID of activities 12-24 DIP utility

creating access rights E-3 creating calendar view with E-3 creating character sets E-3 creating crashdumps database E-4 creating error message logs E-4 creating online help E-4 creating ResUsage tables E-4 creating Sys_Calendar with E-3 creating system objects 10-12 creating system views E-4 creating system views and macros A-3 creating SystemFE macros E-4 data protection 7-42, 10-11 DBC crashdumps space 10-13 DIPCRASH script and 10-12 enabling null passwords E-3 logging access-checking E-3 purpose E-2

ResUsage macros and views E-4 SQL script files E-2 starting E-2 DIPACC SQL script file E-3 DIPACR SQL script file E-3 DIPALL SQL script file E-3 DIPCCS SQL script file E-3 DIPCRASH SQL script file E-4 DIPERR SQL script file E-4 DIPOLH SQL script file E-4 DIPPATCH SQL script file E-4 DIPRSS SQL script file E-4 DIPRUM SQL script file E-4 DIPSYSFE SQL script file E-4 DIPVIEW SQL script file E-4

creating administrative views 4-7 Disk arrays adding 12-29 LUNs 7-24 overview 7-5 RAID and 7-5 ranks 7-23 Disk space

monitoring 3-4 resolving 12-11 Disks, adding 12-29

DISPLAY GTW command, Gateway Control

Teradata RDBMS Database Administration

Index -7 Index

utility 12-9

DISPLAY NETWORK command, Gateway Control utility 12-9

DISPLAY SESSION command, Gateway Control utility 12-9

Down AMP Recovery Journal, automatic protection of

fallback data 7-4 Down-AMP recovery journal 7-34 Drive groups 7-24 DROP DATABASE statement 1-19 DROP DATABASES privilege 1-2 DROP MACRO statement 2-73 DROP privilege 6-5

DROP ROLE compared with REVOKE 4-4 DROP ROLE statement

compared with REVOKE 4-4 DROP STATISTICS (QCD form) statement 13-7 DROP TABLE statement 2-6 DROP TEMPORARY TABLE statement 2-6 DROP USER privilege 1-2 DROP USER statement 1-19 DUL utility 10-27

DUL utility, saving PDE crashdumps to disk 10-27 DUL utility, using 10-30 DULTAPE utility 10-27

saving PDE crashdumps to tape 10-27 DULTAPE utility, using 10-27 Dump area management

clearing the dump area 11-5 dump warning interval 11-6 FLAG_ TIMEOUT option 11-5 options 11-5 TIME option 11-5 DUMP EXPLAIN statement 13-8 DUMP privilege 6-5 Dump Unload/Load Tape utility. See

DULTAPE 10-27 Dump Unload/Load utility. See DUL 10-27 Dump warning interval 11-6 Dump/Unload utility. See DUL utility DumpLock log
Previous << 1 .. 203 204 205 206 207 208 < 209 > 210 211 212 213 214 215 .. 218 >> Next