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


Software_Event_Log view 12-5

stream log 12-5, 12-10

stream log and hung jobs 12-24

stune file 12-5

Supervisor facility 12-5

syscheck and hung jobs 12-23

syscheck command, Resource Check Tools

utility 12-5 Table Rebuild utility 12-6 TableSize view 12-6 tdnstat utility 12-6, 12-8 TDPUTCE 12-8 Teradata Manager 12-6 Teradata Manager and hung jobs 12-24 Teradata MultiTool 12-6 Teradata Performance Monitor 12-4 Teradata RDBMS 12-2 Update DBC utility 12-6 Update DBC utility and hung jobs 12-24 Update Space utility 12-6 Update Space utility and hung jobs 12-24 using Showlocks utility to resolve HUT

locks 12-25 Vproc Manager utility 12-6

Teradata RDBMS Database Administration

Index -21 Index

Vproc Manager utility and hung jobs 12-24 xcpustate utility and hung jobs 12-24 xctl utility 12-7 xperfstate utility 12-7 TSET

evaluating query plans, by TSC personnel 13-3 Two-Phase Commit. See 2PC

U

UNIQUE option, with PPI 2-26 UNIX

forcing system dumps 11-6 saving system dumps 11-7 UNIX panic dumps

flag_timeout option 11-5 management options 11-5 time option 11-5 warning interval 11-6 Update DBC utility

troubleshooting hung jobs 12-24 troubleshooting Teradata RDBMS 12-6 UPDATE privilege 6-6 Update Space utility, troubleshooting hung jobs 12-24

upgrading with Teradata Visual Explain 13-4 User

default attribute, dropping 4-4 User environment

controlling password defaults 6-21 controlling session defaults A-21 encrypting passwords 6-23 User sessions

controlling A-21 defaults A-21 description of A-21 User slice 7-26 Users

administrative user 1-7 ALL 1-5

controlling lockout duration 4-4, 6-17

CRASHDUMPS 1-5

creating 2-2, 5-2

creating Sys_Calendar E-3

databases versus 1-9

DBC 1-2, 1-3

DEFAULT 1-5

dropping 2-3

granting CREATE privileges 5-8 objects associated with 1-9 other 1-5

PUBLIC 1-5 setting up 5-1 SysAdmin 1-4 SystemFE 1-4 TDPUSER 1-6 Utilities

ARC 8-3, B-5, B-10, B-15

ARC and AMP clusters 7-37

ARC and RELEASE LOCK statement 12-5, 12-25

ARC, affects of altering a PI 2-27

ARC, clustering and journals 7-37

ARC, revalidating primary indexes 2-33

BTEQ B-2, B-10, B-14, B-15

CheckTable 12-2

CheckTable, checking for incorrect

partitioning 2-33 CheckTable, checking for PPI errors with LEVEL 3

command 2-29 CheckTable, checking row locations of PPI

table 12-24 ctl 12-2

DBS Control 12-2, 12-11

DBS Control, changing for insufficient parser

memory 12-13 DBS Control, changing RoundHalfwayMagUp for

partitioning expressions 2-33 DBS Control, controlling PPICacheThrP for PPI

operations 2-33 DIP E-2

DIP and DBC.Crashdumps 10-12

DUL, saving PDE crashdumps to disk 10-27

DULTAPE, saving PDE crashdumps to

tape 10-27 dumplocklog 12-4 export B-2

FastExport B-4, B-10, B-15 FastExport, backing up data 8-9 FastLoad B-3, B-9, B-10, B-14, B-15 FastLoad, restoring data 8-9 Ferret 12-3

Ferret and PACKDISK command 3-19 Ferret and SHOWFSP command 3-19 Ferret and SHOWSPACE command 12-11 Gateway Control 12-4, 12-9, A-34 Gateway Global 12-4, A-34 import B-2

load, limiting with MaxLoadTasks 10-27

Lock Display 12-4

Locking Logger 12-4, 12-25

Locking Logger, creating log table for 12-16

Locking Logger, enabling 12-16

lokdisp 12-4

MLOAD B-4

Index -22

Teradata RDBMS Database Administration Index

MultiLoad B-9, B-10, B-14, B-15 NetVault, archiving with 8-4 NetVault, common configurations 8-6 Priority Scheduler 15-9 Query Session 12-4 Reconfiguration 12-31 Recovery Manager 12-4 Resource Check Tools 12-5, 12-21, D-4 Resource Check Tools utility and dbschk

command 12-2 Showlocks 12-5, 12-25 Table Rebuild 12-6

Table Rebuild, recovering down AMPs 7-4

tdnstat 12-6, 12-8

TeraBuilder B-6

Teradata Visual Explain 2-36

Teradata Visual Explain, benefits of 13-12

TPump B-5, B-9, B-10, B-14, B-15

TPump, limitations with ASE variables 5-28

Update DBC 12-6

Update Space 12-6

Vproc Manager 12-6

xcpustate and troubleshooting 12-24

xctl 12-7

xperfstate 12-7

V

Version number, table

affects on ARC abilities 2-79, 8-8 Vews

user-defined, benefits of 2-74 View

DBC.SecurityDefaults, updating 6-17 Views

creating Calendar E-3

creating ResUsage E-4

creating system views with DIPVIEW E-4

DBC.AccountInfo 5-35

DBC.All_RI_Children 7-14

DBC.All_RI_Parents 7-14

DBC.AllRights 6-9

DBC.AllSpace 3-15

DBC.AMPUsage 5-26, 5-36

DBC.AMPUsage, clearing DBC.Acctg table 4-15

DBC.AMPUsage, logging ASE variables 5-27

DBC.Association 8-44

DBC.CharTranslations A-9

DBC.DiskSpace 3-14, 12-3, 12-24

DBC.DiskSpace and system 12-3

DBC.Events 8-45

DBC.Events_Configuration 8-46 DBC.HostsInfo A-10 DBC.IndexConstraints 2-28 DBC.Indices 2-28 DBC.LogOnOff 6-34 DBC.LogonRules 6-34 DBC.RI_Child_Tables 7-14 DBC.RI_Distinct_Children 7-14 DBC.RI_Distinct_Parents 7-14 DBC.RI_Parent_Tables 7-14 DBC.SecurityDefaults, defining system-level
Previous << 1 .. 211 212 213 214 215 216 < 217 > 218 >> Next