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


DEMOGRAPHICS statement 13-8 INSERT privilege 6-6 INSERT SELECT statement B-15 INSERT statement, BTEQ utility B-9 Intermediate spool space 3-6 International character support client character sets A-9 language support mode A-8

J

Job scheduling, tools for setting up

automatically 12-19 Jobs

determining causes of hung 12-23 troubleshooting hung 12-23

Join indexes 2-37 adding 2-8

collecting statistics 2-46 dropping 2-8 prototyping 2-54 Joins

resolving insufficient memory for 12-12 JOURNAL option

using for recovery with ARC utility 8-4 with clustering 7-37 Journals

permanent, prevented from rolling 2-83 journals

permanent, using for recovery with ARC utility 8-4

K

KILL command, Gateway Control utility 12-9 Knowledge articles, NCR, accessing with NCR@YourService 10-26

L

Language support mode

determining A-8 LEVEL 3 command, CheckTable Utility 2-29 LIMIT SQLTEXT option 14-4 LIMIT SUMMARY option 14-4 LIMIT THRESHOLD option 14-4 Limits

perm space per AMP 3-3 setting data block size 3-4 setting Free Space Percent 3-5 LOAD utility, interpreting status B-8 Lock Display utility

system hang and 12-24 troubleshooting Teradata RDBMS 12-4 LockedUserExpire value, locking out users 6-17 Locking Logger utility

creating log table for 12-16 enabling 12-16

resolving lock contentions 12-25 troubleshooting hung jobs 12-24 troubleshooting Teradata RDBMS 12-4 Lockout user duration, controlling 4-4, 6-17 Log files

creating E-4 error formats C-5

Index -10

Teradata RDBMS Database Administration Index

summary C-2 Logical Units. See LUNs LOGOFF statement, ARC utility 8-14 Logon control, host 6-23 Logon Sequence Number. See LSN LOGON statement, ARC utility 8-14 lokdisp utility

troubleshooting Teradata RDBMS 12-4 LSN

calculation B-8 FastExport and B-25 FastLoad and B-16 MultiLoad and B-16 with ARC jobs B-20 LUNs

boot slice 7-26 characteristics of 7-24 RAID Manager and 7-24 user slices 7-26

M

Macro

DBC.LogonRule, controlling SSO 6-23 Macros 2-73

advantages of using 2-73 changing parameter values 2-73 controlling access with 6-43 creating 2-73

creating DBC.AccLogRule E-3 creating ResUsage E-4 creating System E-4 DBC.AccLogRule 6-46 defining 2-73 dropping 2-73 executing 2-73 removing 2-73 replacing 2-73 storing 2-73 system, types of 4-2 using 6-43

using to control access 6-43 MaxLoadTasks field, limiting load tasks 10-27 MaxLogonAttempts value, locking out users 6-17 MaxParseTreeSegs field

resolving insufficient memory for parser 12-13 MaxParseTreeSegs user-tunable field, controlling

memory for join indexes 2-39 MAXPERM 3-3 MaxPerm permanent space 3-3 MAXSPOOL 3-8

MaxSpool spool space 3-8 MAXTEMP 3-11 MaxTemp temporary space 3-11 Memory

adding 12-30

adjusting available free 12-11 controlling for join indexes and PPIs with

HTMemAlloc 12-12 controlling for join indexes and PPIs with

SkewAllowance field 12-12 controlling for parser with MaxParseTreeSegs field 12-13

controlling when insufficient for Optimizer 2-39 handling lack of with multiple JIs 2-39 resolving insufficient for Optimizer 12-13 resolving insufficient with PPIs and joins 12-12 TDP and A-26 Message logs, creating error E-4 MLOAD utility B-4 Mode

ANSI 7-15 Teradata 7-16 MODIFY USER statement 5-10 Modifying passwords 6-21 Modifying priority of an active account 5-22 MultiLoad utility B-9, B-10, B-14, B-15 data transfer phase B-18 loading tables B-9 monitoring B-16 phases B-18 resource usage B-17 sessions B-18 MultiLoad utility. See MLOAD utility

N

NCR@YourService account, accessing for NCR

knowledge articles 10-26 Nested views 6-41 NetVault

running ARC 8-4 NetVault utility

common configurations 8-6 using with ARC utility 8-4 Network environment A-31 functionality A-31 software components A-31 Nicing

asynchronous 5-25 self 5-25

No fallback, data protection option 7-41

Teradata RDBMS Database Administration

Index -11 Index

Nodes

adding 12-31

determining configuration for adding 12-31 error logs C-2

Performance Monitor and D-6 viewing error logs C-6 NOT NULL option 2-11 NULL phrase 2-12 NULLIF option 2-12

O

Objects

creator of 1-14 owner of 1-14 ON COMMIT option 2-8 Online help, creating with DIPOLH E-4 Option

LIMIT SQLTEXT 14-4 LIMIT SUMMARY 14-4 LIMIT THRESHOLD 14-4 Options ALL 6-15 AS 2-6

COALESCE 2-12 COMPRESS 2-14

JOURNAL, using for recovery with ARC

utility 8-4 JOURNAL, with clustering 7-37 LOG 2-8 NOT NULL 2-11 NULLIF 2-12 ON COMMIT 2-8

PRIMARY INDEX PARTITION BY 2-25 PRIMARY KEY, with partitioning 2-26 RELEASE PASSWORD LOCK 6-20 REVALIDATE PRIMARY INDEX 2-29 UNIQUE, with PPI 2-26 WITH ADMIN OPTION 5-13 WITH ALL 14-3 WITH DEFAULT 2-12 WITH OBJECTS 14-3 WITH SQL 14-3 WITH STEPINFO 14-4 OptMaxGlobalJI internal field, controlling memory

for join indexes 2-39, 12-13 Output spool space 3-6 Owner privileges 1-14 Owner, rules of 1-14 Ownership, transferring 3-20

P

PACKDISK command

Ferret utility 3-19, 12-3, 12-11 making space with 3-19 resolving lack of disk space 12-11 troubleshooting Teradata RDBMS 12-4 Parity, calculating 7-6 Parser fault isolation dumps 10-3 Parser, handling memory exceeded 12-13 Partioning
Previous << 1 .. 205 206 207 208 209 210 < 211 > 212 213 214 215 216 217 .. 218 >> Next