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


using 6-24 REVOKE statement 6-13

compared with DROP ROLE 4-4 Rights, creating access with DIPACR E-3 Role

controlling privileges at the group level 6-15

creator privileges 5-12 default user, affects of dropping 4-4 Roles

conferring administration abilities with WITH

ADMIN OPTION 5-13 examples of applying 5-13 implementing 5-12, 5-13 rules of use 5-13 Roll back with before-image journals 2-79 Roll forward with after-image journals 2-79 Rollback

with partioning expression error 2-25, 2-26 ROLLBACK function, ARC utility 2-81 ROLLBACK statement, ARC utility 8-39 ROLLFORWARD function, ARC utility 2-81 ROLLFORWARD statement, ARC utility 8-41 Row distribution with PPI 2-30 Row ID, flag bit for partioned tables 2-30 Rows, analyzing distribution of 2-51 Rules

PPI, defining 2-25 rules 14-21 rules of defining 1-14 Rules, validating DBQL 14-21

S

SCANDISK command, Ferret utility 12-3, 12-5 Scheduling priority 5-25 Scheduling, automatic 12-19 Scripts

archiving 8-12 checking syntax 8-13 creating 8-11 DIP utility E-2

managing ARC language statements 8-11 optional archive parameters 8-12 Secondary indexes 2-35 adding 2-8 dropping 2-8 Security

controlling password 6-20 logon 5-6

Security defaults, updating global preferences in

DBC.SysSecDefaults 6-22 SELECT privilege 4-8, 6-6 Server character sets

default for user DBC A-7 Session

statistics, by account 5-21, 5-26

Index -16

Teradata RDBMS Database Administration Index

Session control 8-14

Session pools A-25

Sessions, controlling elements 12-17

SET RESOURCE command, DBC. SW_Event_Log

table and Performance Monitor 6-36 SET SESSION ACCOUNT

PM/API request, using 5-23 SET SESSION command, DBC.SW_Event_Log table

and Performance Monitor 6-36 SHOWFSP command, Ferret utility 12-3, 12-5 Showlocks utility

HUT locks and B-24 resolving HUT locks 12-25 troubleshooting hung jobs 12-24 troubleshooting Teradata RDBMS 12-5 SHOWSPACE command, Ferret utility 12-3, 12-5, 12-11 Single Sign On

appending domain names to users 5-7, 5-8 Single Sign-On

diagnosing logon errors 12-14 implementing 6-25 SkewAllowance field

controlling memory for join indexes and PPIs 12-12 SkewAllowance field, setting to resolve error

7550 12-12 SMF, troubleshooting client connections 12-8 Snapshot dump facility 10-2 Snapshot dumps 10-2

parser fault isolation 10-3 spool table fault isolation 10-3 Software client A-1

viewing release levels A-4 Space

allocating to permanent journals 7-39 considerations 3-1 default crashdumps 10-13 increasing by giving ownership 3-20 monitoring usage 3-4, 3-12 PACKDISK command and 3-19 peak disk, clearing values from

DBC.DatabaseSpace 4-15 permanent 3-2 spool 3-6 temporary

defining limits 3-10 transferring permanent 3-20 updating with Update DBC utility 12-6 updating with Update Space utility 12-6 Space allocation, finding 3-12 Space usage, monitoring 3-4

Spool space 3-6 allocating 3-6 categories 3-6 CurrentSpool 3-8 defining 3-6 intermediate 3-6 limits 3-7 MaxSpool 3-8 minimum, reserving 3-9 output 3-6 PeakSpool 3-8 reserves, creating 3-9 volatile 3-6 Spool table fault isolation dumps 10-3 SQL EXPLAIN modifier, proving indexes 2-36 SQL script files, DIP E-2 SQL statements

ALTER TABLE 2-5, 2-29, 2-33 ALTER TABLE, capabilities 2-5 BEGIN QUERY LOGGING 14-1, 14-3 BEGIN QUERY LOGGING, options to 14-3 BEGIN TRANSACTION 7-16 COLLECT DEMOGRAPHICS 13-7 COLLECT STATISTICS (QCD Form) 13-7 CREATE 1-2 CREATE DATABASE 5-3 CREATE MACRO 2-73

CREATE TABLE, copying AS a global temporary table 2-6

CREATE TABLE, copying AS a volatile table 2-6 CREATE TABLE, copying table with AS option 2-6

CREATE TABLE, creating permanent tables 2-4

CREATE USER 1-7, 5-3, 5-6

DELETE DATABASE 1-19

DELETE USER 1-19

DML, REFERENCES clause in 7-7

DML, REFERENCES WITH CHECK OPTION

clause 7-7 DROP DATABASE 1-19 DROP MACRO 2-73 DROP STATISTICS (QCD form) 13-7 DROP TABLE 2-6 DROP TEMPORARY TABLE 2-6 DROP USER 1-19 DUMP EXPLAIN 13-8 END QUERY LOGGING 14-1, 14-3 END QUERY LOGGING, effect on active

sessions 14-19 END TRANSACTION 7-16 EXECUTE MACRO 2-73 GIVE 1-2, 1-17 GRANT 6-11

Teradata RDBMS Database Administration

Index -17 Index

GRANT LOGON 6-24

incompatible with permanent journals 2-83

INSERT EXPLAIN 13-7, 13-8

INSERT EXPLAIN WITH STATISTICS AND

DEMOGRAPHICS 13-8 INSERT SELECT B-15 MODIFY USER 5-10

REFERENCES WITH NO CHECK OPTION 7-7 RENAME TABLE, recreating a table 2-5 REPLACE MACRO 2-73 REVOKE 6-13

REVOKE compared with DROP ROLE 4-4 REVOKE LOGON 6-24 Statements

COLLECT STATISTICS (Optimizer form) as CREATE INDEX statement 2-47 re-collecting with 2-47 use of 2-45 Statistics

collecting for indexes 2-46 DBC.AMPUsage view, accumulating statistics

with 5-26 DBC.AMPUsage, using 5-21 session, by account 5-21, 5-26 STATS module, Teradata Manager 2-45 Stored procedures 2-75 controlling access 6-44 features 2-75 functionality 2-75 supporting client utilities and 2-76 using 2-75
Previous << 1 .. 208 209 210 211 212 213 < 214 > 215 216 217 .. 218 >> Next