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 .. 181 182 183 184 185 186 < 187 > 188 189 190 191 192 193 .. 218 >> Next


You can customize the TDP to perform a user-defined exit routine. Customizing the TDP can assist you in collecting information for:

Performance analysis

Functional analysis

The TDP User Transaction Collection Exit is a routine that allows you to collect statistics about all of the requests and responses that traverse the TDP.

TDPUTCE is an exit taken from the Transaction Monitor. TDPUTCE collects statistics about requests and responses that pass through the TDP.

Memory Management

To provide for memory acquisition during system operation without incurring the high overhead associated with the operating system memory services, the TDP acquires units of main memory, or cells, from its own more efficient memory management.

During startup, the memory manager pre-allocates a number of cells in sizes that are convenient for use by the TDP.

The sizes of the cells are internal constants. The initial number of cells is an internal default.

A - 26

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

TDP Functionality

If a TDP subtask requests a cell from the memory manager, but other TDP subtasks are using all available cells, the memory manager takes one of the following actions:

Obtains a new cell from the operating system

Places the requesting subtask into a wait for memory state.

If the requester is placed into a wait state, the wait ends when another TDP subtask releases a cell. The decision to obtain a new cell or wait for an existing cell is based on TDP considerations.

The TDP typically uses a virtual region of about 4 to 5 MB. To avoid overhead calls to the operating system, the TDP divides its work areas in cells. A warning message (TDP0021) displays when 80% of the cells of a certain size are in use.

Using TDP Commands

Commands you enter from the console are not executed until you execute the RUN command.

The TDP accepts operator commands from:

The MVS console

MVS/TSO users

The VM console

VM/ CMS virtual machines

CLIv2 applications

Messages that result from executing operator commands entered from a console are returned to the console.

For detailed information, see Teradata Director Program Reference. |

Entering Commands on VM

From the VM console, enter a TDP operator command by preceding it with the identifier of the TDP you want to perform the command; for example:

Tdpid TDPcommandtext

In this example, Tdpid is a four-character identifier associated with the TDP (for example TDP1, TDP2, and so forth) to which the command is directed, and TDPcommandtext is the TDP command string.

Entering Commands on MVS

From an MVS host console, use the MVS MODIFY command to issue TDP operator commands to a TDP already running the MVS environment.

An example of an MVS Modify command is as follows:

A - 26 Teradata RDBMS Database Administration

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

TDP Functionality

F Tdpid, TDPcommandtext where:

Value Description
F The abbreviation for the MVS MODIFY command.
Tdpid The identifier of the TDP subsystem (for example TDP0, TDP1, and so on) which is to perform the command in TDPcommandtext.

Authorizing Command Privileges

Users may be authorized to issue certain types of TDP commands; for example:

TDP Command Description
UserID Specifies the VM name or TSO UserID.
Display Allows the AUthorized user to Display TDP.
Any Allows the AUthorized user to issue any TDP command.
AUthoriz Allows the user to issue any TDP command, including the Authoriz command.
Resolve Indicates 2PC coordinators are authorized to perform automatic in-doubt resolution.

Operator Commands

Enter TDP operator commands from the MVS or VM console before you execute the RUN command and during normal TDP operation.

The following table lists available operator commands. The uppercase letters in the command name indicate the minimum keyword letters you must enter to identify the command.

IF the item is ... THEN the available commands are .
TDP Display Module
Display TDP
RUN
SHUTDOWN
CANCEL
QUIck
Orderly
SET UserId
SET Charset
SET Comchar

A - 26

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

TDP Functionality

IF the item is ... THEN the available commands are .
IFP ATTach DETach Display STArt STOp
POOL ENAble DISAble Display LOGOFF MODIFY STArt STOp
2PC COMMIT ENAble IRF DISAble IRF DISPLAY INDoubt ROLLBACK
SMF ENAble DISAble Display
QUEUES Display
CELLS Display ADD CELLS ADD XMSCELLS
LOGONS DISAble ENAble
SESsion / JOB Display LOGOFF SET MAXSESS DISABLE SESSION RESERVE ENABLE SESSION RESERVE DISABLE SESSION DETAIL ENABLE SESSION DETAIL DISABLE SESSION STATUS ENABLE SESSION STATUS
TEST ENAble DISAble
EXITS ENAble DISAble
TIME ENAble DISAble
Previous << 1 .. 181 182 183 184 185 186 < 187 > 188 189 190 191 192 193 .. 218 >> Next