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

T

Table

altering capabilities 2-5

base, collecting statistics on columns of 2-46

changed version number, affects on ARC roll

operations 8-8 changing the definition 2-7 changing the version number by altering the

structure 2-79 copying AS a global temporary 2-6 copying AS a volatile 2-6 creating a permanent 2-4 creating a temporary 2-5 creating and maintaining 2-4 DBC.Acctg, clearing with DBC.AMPUsage view 4-15

DBC.DataBasesSpace, correcting inconsistencies in 4-17

DBC.DBase, correcting inconsistencies in 4-17 DBC.SysSecDefaults, updating DBC.SysSecDefaults table updating 6-17 dropping a 2-6

regenerating headers with REVALIDATE PRIMARY INDEX option of ALTER TABLE 2-29 renaming during re-creation 2-5 Table Rebuild utility

recovering down AMPs 7-4 Table Rebuild utility, troubleshooting Teradata

RDBMS 12-6 Table-level constraints adding 2-8 changing 2-8 dropping 2-8 Tables

CalDates table E-3 changing column titles 2-7 partitioned, row distribution of 2-30 recreating 2-7 system, contents of 4-2 system, in Data Dictionary 4-2 system, maintaining 4-15 system, updating 4-4 using DIPRSS to create ResUsage E-4 with PPI, row ID of 2-30 Target Level Emulation. See TLE 13-3 Tasks, scheduling priority 5-25 tdnstat utility

troubleshooting network connections 12-8 troubleshooting Teradata RDBMS 12-6 TDP

authorizing command privileges A-28 exits A-26

exits, controlling password security 6-20 functionality A-26 HSI timestamp 12-8 memory management A-26 monitoring tools 12-8 operator commands A-28 using commands A-27 TDP User Transaction Collection Exit. See TDPTUCE TDPTMON D-14

TDPTUCE, troubleshooting client connections 12-8 TDQM

scheduling basis types 12-19 Temporary space CurrentTemp 3-11 defining limits 3-10 MaxTemp 3-11 PeakTemp 3-11 tracking 3-11 TeraBuilder utility B-6

Teradata Director Program Transaction Monitor. See

TDPTMON Teradata Director Program. See TDP Teradata Index Wizard 2-36, 13-10 Teradata Index Wizard utility 13-7 Teradata Manager ARC and B-22 ARC utility and B-22 interpreting results B-8 Priority Scheduler Administrator 15-11 resource usage B-16 troubleshooting hung jobs 12-24 troubleshooting Teradata RDBMS 12-6 viewing statistics with STATS module 2-45 Teradata mode 7-16

Teradata MultiTool, troubleshooting Teradata

RDBMS 12-6 Teradata Parallel Pump. See TPump utility Teradata Performance Monitor, troubleshooting

Teradata RDBMS 12-4 Teradata RDBMS

after installation 1-3 building 2-1

communicating with A-21 initial 1-3

resource components of D-2 restarting 9-3 starting 9-3 stopping 9-2

viewing configuration A-16 viewing software release levels A-4

Index -20

Teradata RDBMS Database Administration Index

Teradata System Emulation Tool. See TSET 13-3 Teradata Visual Explain Utility benefits of 13-12 proving a SI 2-36 TIME option, dump area management on UNIX 11-5 Timestamp

Data Dictionary 4-13 fields in system tables and views 4-13 TLE

proving a SI 2-36, 13-3, 13-10 reducing performance events 13-3 testing workloads for baseline profiling 13-14 TMemAlloc field, setting to resolve error 7550 12-12 tools for testing indexes for 13-14 TPump utility B-5, B-9, B-10, B-14, B-15

limitations with ASE variables 5-28 Transaction data protection 7-15 Transaction rollbacks

resolving for PPI tables 12-26 Transactions

data protection 7-15 nesting in Teradata mode 7-16 Transient journals benefits of 7-30 data protection 7-2, 7-30 space allocation 7-30 Triggers 2-71

controlling functions with 2-71 firing 2-71 functionality 2-71 restrictions on using 2-72 types of 2-71 using 2-71 Troubleshooting 12-1, 15-1

diagnosing Single Sign-On logon errors 12-14 hardware 12-10 partitioned tables 12-27 referential integrity tables 12-27 resolving problems 12-25 slow or hung jobs 12-23 Troubleshooting tools

AWS console 12-2, 12-10

AWS console and hung jobs 12-23

BTEQ and hung jobs 12-23

channel connections 12-8

CheckTable utility 12-2

client connections 12-8

ctl utility 12-2

Database Window 12-2

DBC.DiskSpace view and hung jobs 12-24

DBC.Software_Event_Log view 12-10

DBC.SW_Event_Log and hung jobs 12-24

DBS Control utility 12-2

dbschk command, Resource Check Tools

utility 12-2, 12-5 DEFRAGMENT command, Ferret utility 12-3 DiskSpace view 12-3 Ferret utility 12-3 Gateway Control utility 12-4, 12-9 Gateway Global utility 12-4 HSI timestamp 12-8 Lock Display utility 12-4 Locking Logger and resolving lock

contentions 12-25 Locking Logger utility 12-4 Locking Logger utility and hung jobs 12-24 lokdisp utility 12-4 network connections 12-8 PACKDISK command, Ferret utility 12-3, 12-4 Performance Monitor 12-10 puma command 12-4 puma command and hung jobs 12-24 Query Session utility 12-4 Recovery Manager utility 12-4 ResUsage and hung jobs 12-25 SCANDISK command, Ferret utility 12-3, 12-5 SHOWFSP command, Ferret utility 12-3, 12-5 Showlocks utility 12-5 Showlocks utility and hung jobs 12-24 SHOWSPACE command, Ferret utility 12-3, 12-5 SMF 12-8
Previous << 1 .. 210 211 212 213 214 215 < 216 > 217 .. 218 >> Next