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


Reserving Cylinders for Permanent Space Allocation............................................3-3

Setting Data Block Size Limits....................................................................................3-4

Setting Free Space Percent Limits..............................................................................3-5

Specifying Spool Space Limits.......................................................................................3-6

Spool Space and Capacity Planning..........................................................................3-6

Spool Space Categories................................................................................................3-6

Spool Space Allocation................................................................................................3-7

Spool Space Availability..............................................................................................3-8

Reserving Minimum Spool Space..............................................................................3-9

Creating a Spool Reserve Database............................................................................3-9

Defining Temporary Space Limits..............................................................................3-10

Monitoring Disk Space Activity..................................................................................3-12

Resetting Peak Values in DBC.DataBaseSpace......................................................3-13

Example........................................................................................................................3-13

Using the System Views to Determine Current Space..........................................3-14

DiskSpace View..........................................................................................................3-14

TableSize View............................................................................................................3-15

AllSpace View.............................................................................................................3-15

Finding CurrentPerm.................................................................................................3-17

Example of MAX(CurrentPerm) and SUM(CurrentPerm) Queries....................3-17

Comparing DBC.DiskSpace and DBC.TableSize Results.....................................3-18

Gaining Space with PACKDISK..................................................................................3-19

Packing and Free Space Percent...............................................................................3-19

Using SHOWFSP........................................................................................................3-19

Increasing Space by Giving Ownership.....................................................................3-20

Transferring Ownership............................................................................................3-20

Transferring Permanent Space.................................................................................3-20

xxviii

Teradata RDBMS Database Administration Contents

Chapter 4:

Using Data Dictionary Tables and Views

Data Dictionary Overview.............................................................................................4-2

Protected Data Dictionary Tables.................................................................................4-3

Fallback Protected Data Dictionary Tables...............................................................4-3

Non-Hashed Data Dictionary Tables........................................................................4-3

Updating Data Dictionary Tables.................................................................................4-4

Dropping User Defaults..............................................................................................4-4

Dictionary Views and Tables for the Administrator..................................................4-7

User-Restricted Views..................................................................................................4-7

Explicitly Granted Privileges .....................................................................................4-8

Administration Views and Tables.............................................................................4-8

Data Dictionary Timestamp.........................................................................................4-13

Timestamp Fields.......................................................................................................4-13

Timestamps in Dictionary Views.............................................................................4-13

Maintaining Your Data Dictionary Logs and Tables...............................................4-15

Archiving and Resetting Accumulators and Peak Values...................................4-15
Previous << 1 .. 2 3 4 5 6 7 < 8 > 9 10 11 12 13 14 .. 218 >> Next