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

Gateway Global Utility gtwglobal Use to: Monitor network sessions and traffic Disable logons Force off a rogue session Investigate gateway problems

A - 34

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

The Network Gateway

Displaying Network and Session Information

Command Description
DISPLAY NETWORK Displays your network configuration.
DISPLAY GTW Displays all sessions connected to the gateway.
DISPLAY SESSION Displays information about a specific session on the gateway.

Controlling Network Sessions

Command Description
DISABLE LOGONS Disable logons to the RDBMS through the gateway.
DISABLE EXLOGONS Disables the EXLOGON option and reverses logons back to the normal path.
ENABLE LOGONS Enable logons to the RDBMS via the gateway.
ENABLE EXLOGONS Enables and allows the gateway to choose the fast path when logging users onto the RDBMS. This command improves logon response time tremendously.
DISCONNECT USER Disconnects all sessions owned by a user.
DISCONNECT SESSION Disconnects a specific session. Must provide the session number in the command syntax.
KILL USER Terminates all sessions of a specific user.
KILL SESSION Terminates a specific session. Must know session number.

Controlling Trace Logs

Use the following commands to turn tracing on or off or to flush the trace buffers to the Event log:

Command Description
ENABLE TRACE Records internal gateway events.
DISABLE TRACE Turns off the writing of event log entries.
FLUSH TRACE Directs the gateway to write the contents of its internal
trace buffers to the event log file.

A - 34 Teradata RDBMS Database Administration

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

The Network Gateway

Documentation References

IF you want information on . THEN see .
Gateway Control Utility Teradata RDBMS Utilities
Gateway Global Utility
how to configure your Teradata Gateway The Web-based Teradata RDBMS Installation/ Migration/Upgrade (I/U/M) publication for the appropriate platform. For Teradata on UNIX, the NCR UNIX MP-RAS suite of documents.

A - 34

Teradata RDBMS Database Administration Appendix B:

Import/Export Utilities

This appendix provides information to help you decide which import/export utility to use for a particular operation. This appendix also discusses how to monitor import/export jobs.

Since system configuration, table and row sizes vary, the suggestions in this appendix are generalizations. It is always best to run tests on an adequate amount (approximately 10%) of real data before settling on a utility choice.

This appendix contains the following:

Available import and export utilities

Methods of importing data

Considerations when loading tables with a PPI

Restart and abort considerations when using BTEQ or TPump to load tables with an identity column

Feature comparison of import and export utilities

Choosing the best utility for the job

Monitoring load jobs

Monitoring an archive or restore job

Monitoring a FastExport job

Teradata RDBMS Database Administration

A - 1 Appendix B: Import/Export Utilities

Import/Export Utilities

Import/Export Utilities

Host-based Utilities

The Teradata software includes two different types of utilities: host-based utilities and AMP-based utilities. Host-based utilities are installed on a client system. The term "host" may refer to a channel-attached client or a network-attached client. Host-based utilities run under the client operating system.

You initialize AMP-based utilities using the Teradata Database Window. On a channel-attached mainframe, a console interface called Host Utility Console (HUTCNS) provides access to a number of AMP-based utilities. You may also use Teradata Manager Remote Console or cnstem.

The Import/Export Utilities discussed in this appendix are typically client-based utilities. These are:

Basic Teradata Query (BTEQ)

FastLoad (FDL)

FastExport

MultiLoad (MLOAD)

Archive and Recovery (ARC)

Teradata Parallel Data Pump (TPump)

Teradata Warehouse Builder (TeraBuilder)

Basic Teradata Query (BTEQ)

BTEQ exports and imports data between a client and the Teradata RDBMS. In addition, BTEQ provides report writing capabilities. (For detailed information,

see Basic Teradata Query Reference.)

Use the capabilities of BTEQ to improve performance, as follows:

IF you are performing . . . THEN . . .
full table scans (all-Access Module Process (AMP) operation) use a single session.
operations that require less than all-AMPs use multiple sessions.
Primary Index (PI) operation determine empirically the optimum number of sessions. More sessions do not necessarily improve performance.

B - 2

Teradata RDBMS Database Administration Appendix B: Import/Export Utilities

Import/Export Utilities

IF you are performing . . . THEN . . .
Previous << 1 .. 183 184 185 186 187 188 < 189 > 190 191 192 193 194 195 .. 218 >> Next