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 .. 62 63 64 65 66 67 < 68 > 69 70 71 72 73 74 .. 218 >> Next

Triggers view the definition of every event-driven, specialized procedure attached to a table.
TVFields table all views, tables, join indexes, unnamed column-level constraints, and stored procedure parameters. SPParameterType returns stored procedure parameters such as IN, INOUT, or OUT. (For stored procedure object code information, use the TVM table.) IdColType returns information about an IDENTITY column.

4 - 10 Teradata RDBMS Database Administration

Chapter 4: Using Data Dictionary Tables and Views

Dictionary Views and Tables for the Administrator

This DD object . Provides information about .
TVM table every table, view, trigger, stored procedure, join index, and macro in the system. The value in the SPObjectCodeRows field indicates stored procedure creation-time attributes, including: Session mode Server platform Print option SP text storage option Teradata Stored Procedure (TDSP) version number
Users view users that the requesting user owns or has MODIFY and/ or DROP privileges on. Because this makes it a user-restricted view, there is no X version. (However, if you select this view when logged on as user DBC, all current users are returned because user DBC owns everything.) The information returned includes: Date and time a user is denied access due to excessive erroneous passwords The number of failed attempts since the last successful logon Creator name and timestamp Last altering user name and time stamp

4 - 10

Teradata RDBMS Database Administration Chapter 4: Using Data Dictionary Tables and Views

Protected Data Dictionary Tables

Data Dictionary Timestamp

The Teradata RDBMS data dictionary features a timestamp.

The timestamp feature should facilitate and enhance your administrative tasks by providing a means to identify obsolete objects for cleanup and space release. You can also use timestamps during maintenance and problem investigation to determine when a change to an object occurred and who made the change.

Timestamp Fields

Timestamp fields used in dictionary tables and dictionary views include:

Timestamp Name and Format Description
CreateTimeStamp TIMESTAMP(0) The time the object was created, in ANSI TimeStamp Format.
CreateUID BYTE(4) User ID of the user who created the object.
LastAlterTimeStamp TIMESTAMP(0) The time the object was last updated in ANSI TimeStamp format.
LastAlterUID BYTE(4) User ID of the user who last updated the object.
LastAccessTimeStamp TIMESTAMP(0) The time the object was last accessed in ANSI TimeStamp format.
AccessCount INTEGER --,---,---,-- 9 The number of times the object was accessed.

Timestamps in Dictionary Views

Timestamp fields are used in the following system views:

These Timestamp fields ... Appear in these dictionary views .
CreateTimeStamp Table_LevelContraints
ShowTBLChecks
ShowColChecks
RI_Parent_Tables
All_RI_Parents
RI_Distinct_Parents
RI_Child_Tables
All_RI_Children
RI_Distinct_Children

Teradata RDBMS Database Administration

4 - 13 Chapter 4: Using Data Dictionary Tables and Views

Protected Data Dictionary Tables

These Timestamp fields ... Appear in these dictionary views .
CreateTimeStamp Databases[X]
LastAlterTimeStamp Users[X]
Tables[X]
Columns[X]
Indices[X]
Triggers[X]

4 - 14

Teradata RDBMS Database Administration 4 - 13 Chapter 4: Using Data Dictionary Tables and Views

Maintaining Your Data Dictionary Logs and Tables

Maintaining Your Data Dictionary Logs and Tables

Before deleting system log information, you should archive the predefined set of system tables using the Archive/Recovery (ARC) utility. To archive system tables, take an all-AMPs dump of database DBC. (For the system tables that are pre-defined for archiving, see "Archiving the Data Dictionary" on page 8-23.

For more information on the tables, views, macros, and utilities discussed in this section, see the following:

Teradata RDBMS Data Dictionary

Teradata RDBMS Resource Usage Macros and Tables

Teradata RDBMS Security Administration

Teradata RDBMS Utilities

Archiving and Resetting Accumulators and Peak Values

You should archive (as desired) and reset accumulators and peak values periodically.

IF you want to reset . THEN use . For instructions and examples, see .
peak space values in DBC.DatabaseSpace DBC.ClearPeakDisk macro "Resetting Peak Values in DBC.DataBaseSpace" on page 3-13
accumulators in DBC.Acctg DBC.AMPUsage "Clearing DBC.Acctg Table with DBC.AMPUsage View" on page 4-15

Clearing DBC.Acctg Table with DBC.AMPUsage View

The DBC.AMPUsage view uses the DBC.Acctg table to provide aggregated information by username, accountID, and AMP.

Updates to the table are made periodically during each AMP step on each processor affected by the step. (If there are long-running steps, AMPUsage numbers show large increases periodically, instead of continuous incremental additions.) Data is collected and added to what is already in the table until you reset the counters to zero.
Previous << 1 .. 62 63 64 65 66 67 < 68 > 69 70 71 72 73 74 .. 218 >> Next