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 .. 172 173 174 175 176 177 < 178 > 179 180 181 182 183 184 .. 218 >> Next


Note: Queries on X views cause verification of user privileges on the underlying objects and return only the relevant rows. Thus, X views may take longer to respond than standard views. However, queries on standard views usually return many more rows.

By default, the SELECT privilege is granted to PUBLIC on most views in both versions. PUBLIC allows all users to query the views. You can load one or both versions and then use GRANT and REVOKE statements to grant or revoke additional or all privileges on any view to particular users.

Note: Revoking a view from public access revokes the privilege from all users; you may not revoke PUBLIC selectively.

A - 2

Teradata RDBMS Database Administration Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

Using Data Dictionary Views and Macros

Ad-Hoc Installation of System Views

System views and macros are created with DIP script files. They are usually created as part of Teradata RDBMS installation, but you can start DIP at any time.

To determine which scripts have been run, log onto a BTEQ session and submit the following statement:

HELP DATABASE DBC;

This query returns the contents of system user DBC, the owner of all system objects.

If something you need is not listed, use the Database Initialization Program (DIP) to execute the appropriate script file. To review the DIP script files, the objects they create, and their purpose, see Appendix E: "Database Initialization". For instructions on running the DIP utility, see Teradata RDBMS Utilities.

Teradata RDBMS Database Administration

A - 3 Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

Viewing the Software Release and Version

I Viewing the Software Release and Version

From any console or any client session, you can view the currently running Teradata RDBMS version and release level with the following query:

SELECT * FROM DBC.DBCInfo;

Note: You must have the SELECT privilege on the DBC.DBCInfo view to use I this query. Typically, this view grants SELECT access to PUBLIC by default.

The query returns the version and release level in the following form:

*** Query completed. 2 rows found. 2 columns returned. *** Total elapsed time was n seconds.

InfoKey InfoData

RELEASE V2R.nn.nn.nn.nn

VERSION nn.nnx.nn.nn

Also, from the console of a UNIX system, you can run the xctl utility. The utility opens in the Version window, which displays the version number of the currently running:

DBS software

PDE software

Gateway software

In addition, the window provides input fields for automatic switching between the PDE and database system software.

For instructions on using the xctl utility, see Teradata RDBMS Utilities.

A - 4

Teradata RDBMS Database Administration Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

Viewing or Modifying the Teradata RDBMS Configuration

Reviewing or Changing Global Parameters

The values for system-wide defaults are distributed across the configuration via the following: If your system is set for Universal hash code, the: DBC.Hosts system table tdlocaledef.txt file Globally Distributed Object (GDO) parameters for: DBS control PDE control Gateway control
Object Name Description References
DBC.HostsInfo view For Universal sites, displays the name and assignments of the international character set you defined as the default in the underlying table. You can assign a particular character set as the default for the entire configuration, for a particular client (host), or for a host group. Teradata RDBMS International Character Set Support
tdlocaledef.txt file Contains definitions that control the output characters and define the format of locale-dependent data types such as DATE, DECIMAL, TIME, and TIMESTAMP. Note: You can override the global defaults at the user or table level by using the FORMAT phrase in a SELECT query or a CREATE TABLE/VIEW statement. Edit the tdlocaledef.txt file to redefine the global format defaults (for example, to change the default currency symbol and monetary format to the Euro dollar). The location of tdlocaledef.txt depends on your Teradata RDBMS server: UNIX MP-RAS: /ntos Windows 2000: [drroe:\\]ProgramFiles \NCR\TDAT\tdconfig "Cultural Format Defaults" on page A-12 "tdlocaledef Utility" in Teradata RDBMS Utilities "Output Format Phrases" in Teradata RDBMS SQL Reference, Volume 3
DBSCONTROLGDO Establishes throughout the vproc configuration well-known values that you can use for: Performance tuning Debugging and diagnostics Enabling/disabling optional features such as Read Ahead Defining global parameters such as cache sizes "DBS Control Utility" in Teradata RDBMS Utilities Teradata RDBMS Performance Optimization

Teradata RDBMS Database Administration

A - 13 Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections
Previous << 1 .. 172 173 174 175 176 177 < 178 > 179 180 181 182 183 184 .. 218 >> Next