in black and white
Main menu
Share a book About us Home
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 61 62 63 64 65 66 < 67 > 68 69 70 71 72 73 .. 218 >> Next

AllRoleRights view all rights granted to each role, including the name and authority of the granting user. AllRoleRights is similar to the AllRights view except it does not return the AllnessFlag or CreatorName. Note: The output of this view extends beyond 80 characters. To capture all the columns and their contents, you can either cast the name columns to shorter lengths or use the BTEQ .SET FOLDLINE command. For details on creating roles and granting role rights, see "Implementing Roles and Profiles" on page 5-12.
AllTempTables view all global temporary tables currently materialized in the system. For details, see "Global Temporary and Volatile Tables" on page 2-17.

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 .
AMPUsage view aggregated CPU and I/O information based on data accumulated in the DBC.Acctg table. Aggregate summaries can be reported by username, accountID, and AMP. Updates to the table are made periodically during each AMP step on each processor affected by the step. For long-running steps, AMPUsage numbers show large increases periodically, instead of continuous incremental additions.
Children view hierarchical relationships. The Children view lists the names of databases and users and their owners in the hierarchy.
Columns view information about table access rights, owners, and: Names, types, attributes, and constraints of all columns in all tables Column names in views and join indexes Parameters of macros and stored procedures You may find this view useful for enforcing domain constraints. Note: For information on the types and attributes of columns in views, use the HELP COLUMN statement. For the parameters of identity columns, see IdCol table.
Databases view databases, users, and their immediate owners, the name of the creator of a user or database, and the date and time the user created it. Note: Only the immediate owner is identified in this view. Use the parent column of the Children view to select all owners.
DBCInfo view the attributes of the current Teradata RDBMS software: Version Release level
DBQLRules view provides a view into the contents of DBQLRuleTbl and returns the query logging rules in effect for a user and/or account. (For details, see "Introducing DBQL" on page 14-2.) Note: This view is restricted to a user with DBC or SystemFE privileges (which should include your DBAdmin user).
IdCol table parameters defined on identity columns. The next sequential number for new rows of the owning table is the value in the AvailValue field.
IndexConstraints view any implied index constraints derived from a partitioning expression, including the collation to be used in evaluating the constraint. In the IndexNumber field, a primary index has an index number of 1. (Also see ShowTblChecks.)
Indices view everything that describes a column defined for an index, including the position of that column in the table. Use this view to find the creators of tables with NUPIs that cause skewed, or spiked, row distribution and tables with PPIs that might be causing memory contention.
MultiColumnStats displays the statistics collected on columns that are not part of an index.

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 .
ProfileInfo view all profiles and their parameter settings.
RoleInfo view the names of roles and their creators, plus comments.
RoleMembers view each role name and all of its members.
SessionInfo view all users who are logged on. Note: Information about session pools, which are a collection of sessions logged on under the same logonid, are not included. Use the DISPLAY POOL command to find out about session pools (see Teradata Director Program Reference). Use this view to find the session source (including host connection, logon name, and application), the current partition, collation, role, and password status, and the type of transaction (such as 2PC). For details on how to extract information from this view, see "DBC.SessionInfo View" on page 6-30.
ShowTblChecks each table-level constraint check in the system. For implicit table-level constraints, the value of Name is either the name of the associated index or, if the index does not have a name, NULL. Note: Named column-level constraint checks are treated as table-level constraint checks and are reported by this view. Unnamed column-level constraint checks are maintained in the TVFields table.
Tables view tables, views, macros, join indexes, triggers, stored procedures, and journals owned by the requesting user or on which he or she has privileges. The following columns simplify searching: TableKind lets you to limit your response rows to the kind of object you are investigating (for example, to see macros only: WHERE TableKind = 'M'). PrimaryKeyIndexID identifies the columns used as the primary index, an indicator of whether a table's NUPI values provide enough uniqueness for even row distribution. ProtectionType indicates whether the table uses fallback. This is useful if you need to find the fallback condition of every table. For example, to find all NO FALLBACK tables you can use WHERE ProtectionType='N'.
Previous << 1 .. 61 62 63 64 65 66 < 67 > 68 69 70 71 72 73 .. 218 >> Next