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 .. 3 4 5 6 7 8 < 9 > 10 11 12 13 14 15 .. 218 >> Next


Clearing DBC.Acctg Table with DBC.AMPUsage View......................................4-15

Purging the System Logs...........................................................................................4-16

Purging Expired Recovery Control (RC) Catalogs................................................4-17

Reducing the Size of DBC.AccessRights and DBC.Accounts..............................4-17

Correcting DBC.DataBasesSpace and DBC.DBase Values...................................4-17

Chapter 5:

Setting Up Users, Profiles, Accounts and Accounting

Creating Users and Databases.......................................................................................5-2

Users versus Databases...............................................................................................5-2

CREATE DATABASE Statement...............................................................................5-3

CREATE USER Statement........................................................................................... 5-3

CREATE USER Default Values .................................................................................. 5-4

CREATE USER and Logon Security..........................................................................5-6

Using the WITH NULL PASSWORD Phrase...........................................................5-6

Granting CREATE and Access Privileges to a New User......................................5-8

MODIFY USER Statement.........................................................................................5-10

Implementing Roles and Profiles................................................................................5-12

Implementing Roles......................................................................................................5-13

Rules of Use.................................................................................................................5-13

Example of Using Roles.............................................................................................5-14

Administrative Procedures.......................................................................................5-15

Implementing Profiles..................................................................................................5-17

xxviii Teradata RDBMS Database Administration Contents

Procedure to Create and Assign a Profile...............................................................5-18

Profiles and User Defaults.........................................................................................5-18

Defining Accounts.........................................................................................................5-20

Finding the Default Account.....................................................................................5-21

Accounts and Performance Group Names.............................................................5-22

Changing the Performance Group of a Running Job............................................5-23

Viewing Account Strings and Session Statistics....................................................5-26

Using Account String Expansion (ASE)..................................................................5-27

ASE Functionality....................................................................................................... 5-27

ASE Considerations and Restrictions......................................................................5-28

Enabling ASE...............................................................................................................5-28

Coding ASE Variables................................................................................................5-29

Usage Rules for ASE Variables.................................................................................5-31

ASE Interactions With Utilities.................................................................................5-31

Using the Data Dictionary Views................................................................................5-32

System Accounting Views............................................................................................5-35

DBC.AccountInfo........................................................................................................5-35

DBC.AMPUsage.........................................................................................................5-36

Example 1: Totalling CPU Time and I/O by User.................................................5-37

Example 2: Resetting DBC.Acctg Counters with DBC.AMPUsage....................5-38

System Accounting Functions.....................................................................................5-39

Charge-back Billing....................................................................................................5-39

Capacity Planning......................................................................................................5-39
Previous << 1 .. 3 4 5 6 7 8 < 9 > 10 11 12 13 14 15 .. 218 >> Next