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


Viewing or Modifying the Teradata RDBMS Configuration

Object Name Description References
PDECONTROLGDO Displays the version numbers of the running software and provides fields for switching between multiple installed versions of PDE and RDBMS software. Also, sets the defaults for and allows you to: Enable/disable and override default parameters for functions such as: - Resource Usage data collection and, optionally, logging - Cylinder Read and, optionally, number of memory slots per cylinder Control hardware defaults such as: - Whether to write data to buddy AMPs or direct to disk (on a UNIX MP-RAS MPP platform) - How to report and recover node or clique failures - What percent of available memory to allocate to the file segment cache. The following chapters in Teradata RDBMS Utilities: "xctl Utility" (UNIX only) "ctl Utility" (Windows 2000 only)
Gateway Control GDO Controls the parameters of the current GDO and allows you to control the environment of network connections to a node, including (but not limited to): Enable/disable network logons On Windows 2000, enable/disable Single Sign On Define host groups Set reconnect time Toggle system logs, trace flags, the debugger, and other debugging tools "Gateway Control Utility" in Teradata RDBMS Utilities

A - 6

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

Viewing and Changing International Character Set Settings and Defaults

Viewing and Changing International Character Set Settings and Defaults

Teradata RDBMS allows each application to choose the internal (server) character set best suited to each column of character data and supports many external (client) character sets.

Also, during Teradata RDBMS installation you can choose a language support mode that determines what character set to use to store the names of database objects in the Teradata RDBMS dictionary tables.

For information on how to implement and apply international character sets, see Teradata RDBMS International Character Set Support.

Default Server Character Sets for User DBC

The default server character set is used to store:

Dictionary information comprising object names, such as names of users, databases, roles, tables, columns, macros, views, triggers, and so forth

Dictionary information other than object names, such as session identifiers, Teradata SQL keywords (for instance, privileges), client platform (host) identifiers, text and syntax captured from queries, and so forth.

Default Server Character Set for Other Users

The default server character set for other users is used to store:

User data (character strings stored in the columns of user-defined data tables), if a specific server character set has not been defined at the user or column level.

Character valued parameters in macros defined by the user.

International Language Support Modes

The language support mode determines the server character set to be used:

To store Teradata RDBMS dictionary data

As the default for storing user data

Teradata RDBMS provides the following language support modes:

A - 10 Teradata RDBMS Database Administration

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

Viewing and Changing International Character Set Settings and Defaults

This language Stores dictionary information in this server AND sets the default server

support mode . character set . character set for user data to .

Standard Object names = LATIN LATIN

Other = UNICODE

Japanese Object names = KANJI1 UNICODE

Other = UNICODE

Note: KANJI1 is compatible with all Teradata-supplied Japanese client character sets; however, object names may not always be shareable among clients with differing character sets.

If Japanese Language Support is not enabled, Standard Language Support is in effect. Japanese language support mode is enabled via System Initialization (sysinit) during Teradata RDBMS installation.

Warning: sysinit wipes all data from the disks. Once enabled, language support mode cannot be changed without unloading and reloading all data plus the Data Dictionary (the contents of the default database for system user DBC).

Determining the Language Support Mode

You can find which language support mode is in effect on your Teradata RDBMS by using SHOW TABLE on the DBC.Hosts dictionary table, as follows:

show table dbc.hosts;

This query returns a table definition similar to the following:

*** Text of DDL statement returned. *** Total elapsed time was 1 second.

CREATE SET TABLE DBC.hosts ,FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL (

LogicalHostId SMALLINT FORMAT 'ZZZ9' NOT NULL ,

HostName CHAR(30) CHARACTER SET KANJI1 NOT CASESPECIFIC NOT NULL , DefaultCharSet CHAR(3 0) CHARACTER SET KANJI1 NOT CASESPECIFIC NOT NULL) UNIQUE PRIMARY INDEX ( LogicalHostId ) UNIQUE INDEX ( HostName );
Previous << 1 .. 173 174 175 176 177 178 < 179 > 180 181 182 183 184 185 .. 218 >> Next