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 .. 199 200 201 202 203 204 < 205 > 206 207 208 209 210 211 .. 218 >> Next

To monitor the transaction traffic, you first modify the TDP User Transaction Collection Exit (TDPUTCE) routine to store and analyze collected data.

When you enable TDPTMON, it provides the following information:

A pointer to the first 500 bytes of the request or response

Time stamps of when the request was:

Queued in the TDP

Transmitted by the TDP

Time stamps of when the response was:

Received by the TDP.

Exited the TDP.

Returned to the application's address space.

The type of request

I For details, see Teradata Director Program Reference.

D - 10

Teradata RDBMS Database Administration Appendix E:

Database Initialization

This appendix introduces the Database Initialization Program (DIP), identifies the executable script files, describes the objects the scripts create, and references relevant technical material.

Teradata RDBMS Database Administration

A - 1 Appendix E: Database Initialization

Database Initialization Program (DIP)

Database Initialization Program (DIP)

The Database Initialization Program (DIP) comprises a series of executable SQL script files. Each file creates one or more system users, databases, macros, tables, and views, for use by:

Teradata RDBMS to:

Implement a feature, such as security access logging, client character sets, calendar arithmetic, and so forth

Store system information, such as PDE crashdumps, resource usage, query text, error message text, and so forth

You and other users, for such activities as:

Viewing the contents of the Data Dictionary (system catalog) tables

Generating system reports, such as resource usage statistics

The DIP Utility

DIP allows you to execute one, several, or all script files, which create a variety of database objects. All the DIP scripts you need are executed during Teradata installation, but you can run the DIP utility at any time to add optional features.

You can invoke the Database Initialization Program (DIP) utility from:

The Supervisor screen of the DBW

On Windows 2000, the Tools menu of the Teradata MultiTool window

For instructions, see "Database Initialization Program (DIP) Utility" in Teradata RDBMS Utilities.

The DIP SQL Script Files

The following table provides a summary of the script files and their use.

E - 2

Teradata RDBMS Database Administration Appendix E: Database Initialization

Database Initialization Program (DIP)

SQL Script File Objects Created Purpose References
DIPACC DBC.AccLogRule macro. Execute this script only if you want to: Enable null passwords Implement and log access-checking activities Enables a user who has the EXECUTE privilege on this macro to submit: GRANT LOGON/REVOKE LOGON statements, used to grant the WITH NULL PASSWORD privilege - On Windows 2000, this privilege is required to implement SSO - On channel-connected mainframes, null passwords also require TDP exits BEGIN LOGGING/END LOGGING statements, used to enable access rights checking and logging. "CREATE USER and Logon Security" on page 5-6 Chapter 6: "Controlling Access" Appendix A: "Teradata RDBMS Configuration, Global Defaults, and Client Connections" "Security and Integrity" in Introduction to Teradata RDBMS
DIPACR Access rights. Initializes data access rights. Chapter 6: "Controlling Access" Teradata RDBMS Security Administration
DIPALL Runs all scripts listed in the DIP screen above its own entry. Runs the standard suite of scripts automatically. Teradata RDBMS Utilities
DIPCAL Sys_Calendar database CalDates table Calendar view Used for date arithmetic in OLAP and other functions. "OLAP Calendar" in Teradata RDBMS Data Dictionary "Date Time and Interval Data Types" in Teradata RDBMS SQL Reference, Volume 3
DIPCCS Client character sets. Creates pre-defined translation tables for non-English languages, including Kanji, Unicode, and various European languages. "Viewing and Changing International Character Set Settings and Defaults" on page A-7 Teradata RDBMS International Character Set support

E - 2 Teradata RDBMS Database Administration

Appendix E: Database Initialization

Database Initialization Program (DIP)

SQL Script File Objects Created Purpose References
DIPCRASH Crashdumps database and table in database DBC. Default location for storing PDE crashdumps on UNIX MP-RAS. (On Windows 2000, the default is flat files in D:\Program Files\NCR\TDAT\ tdConfig\pdedumps.) "About System User DBC.Crashdumps" on page 10-11. "Handling PDE Crashdumps on Windows 2000" on page 10-22.
DIPERR Error message logs Files for storing the text of messages generated by Teradata RDBMS components, software, and client connections. "Log File Summary" on page C-2.
DIPOLH Online help. Loads online help text.
DIPPATCH Stand alone patches
DIPRSS ResUsage tables Store sampled resource usage data. Appendix D: "Tools for Monitoring Performance".
DIPRUM ResUsage macros and views. Enable you to look at and generate reports from the data stored in the ResUsage system tables. Note: If your NCR WorldMark platform has co-existence nodes, during tpa installation or upgrade the identifiers for each node group should be defined in the CASE clauses of the appropriate view definitions in the diprum.bteq file. Teradata RDBMS ResUsage Macros and Tables
Previous << 1 .. 199 200 201 202 203 204 < 205 > 206 207 208 209 210 211 .. 218 >> Next