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 .. 186 187 188 189 190 191 < 192 > 193 194 195 196 197 198 .. 218 >> Next

DIF Personal Computer (PC) spreadsheet format.
Archive Recovery Particular data format that cannot be used by any other utility.

B - 2 Teradata RDBMS Database Administration

Appendix B: Import/Export Utilities

Import/Export Utilities

The internal data format for Teradata is:

Record Length Indicators Data End of Record
(2 bytes) (n bytes) (n bytes) (1 byte)

For more information, see "Operating Modes" in Basic Teradata Query Reference.

Interpreting Teradata Manager LOAD Utility Status

When you use Teradata Manager to observe the progress of load, archive, export, and other jobs, remember the following:

The system uses Logon Sequence Number (LSN) to calculate the total impact of all sessions.

All work the system performs during a session is charged to that session. Teradata Manager displays system resource usage on a session basis.

Because not all partition sessions are used during an operation, some sessions with the same LSN and user name may not report any activity.

The QRYSESSN utility in XDBW will provide detailed status of each session involved in the load task.

B - 2

Teradata RDBMS Database Administration Appendix B: Import/Export Utilities

Teradata RDBMS Import Methods

Teradata RDBMS Import Methods

You can load your production database using one of the following tools:

Method Comments
FastLoad or MultiLoad utility These utilities populate empty tables using data from a client file or sequential data set. MultiLoad can operate on up to five tables simultaneously and can manipulate data in existing tables. However, MultiLoad cannot load tables with USIs, and FastLoad cannot load tables with be any SIs.
TPump utility TPump uses standard SQL DML operations, not block transfers. TPump maintains up to 60 tables at a time. You can specify the percentage of system resources to use for an operation. This allows background maintenance to best suit the processing resources any time in the day.
INSERT statements Submit the INSERT statements using one of the following methods: An application program A macro One or more BTEQ sessions (with or without repetition) BTEQ can insert either specified values or, with variables you define in a USING clause, data from a disk file or sequential data set.

Considerations When Loading PPI Tables

Client utilities support PPI tables with these restrictions and recommendations (also see "Client Utilities Feature Comparison" on page B-10).

IF you plant to use . THEN be aware that the utility .
MultiLoad IMPORT Does not operate on tables with USIs (and many NUPPI tables are defined with USIs) Does not support updates of PI columns or partitioning columns Requires values in all PI fields and partitioning fields
FastLoad does not support SIs of any kind (and many NUPPI tables are defined with USIs).
TPump can handle everything but performs better if you: Provide values for all the partitioning columns (to avoid lock contentions) Do not update the PI or the partitioning columns

Teradata RDBMS Database Administration

B - 9 Appendix B: Import/Export Utilities

Client Utilities Feature Comparison

Client Utilities Feature Comparison

This section summarizes the major features of Teradata RDBMS client utilities:

Feature BTEQ TPump FastLoad MultiLoad FastExport Archive/Recovery (ARC/NetVault)
Client type Channel & Network Channel & Network Channel & Network Channel & Network Channel & Network Channel & Network
MVS MVS MVS MVS MVS MVS
VM VM VM VM VM VM
UNIX UNIX UNIX UNIX UNIX UNIX
Client operating system Sun Sparc/ Solaris Windows NT Windows 95 Windows 2000 Sun Sparc/ Solaris Windows NT Windows 2000 Windows NT Windows 2000 Windows NT Windows 2000 Windows NT Windows 2000 (NetVault) Windows NT Windows 2000
Teradata RDBMS Server NCR UNIX MP-RAS NCR UNIX MP-RAS NCR UNIX MP-RAS NCR UNIX MP-RAS NCR UNIX MP-RAS NCR UNIX MP-RAS
Operating System Windows 2000 Windows 2000 Windows 2000 Windows 2000 Windows 2000 Windows 2000
Operating mode Batch or Interactive Batch Batch Batch Batch Batch
Import data. Update data. Delete data. Export data. Write reports. Import data. Update data. Delete data. Atomic UPSERT. Import data into empty tables with no SIs, JIs, HIs, identity columns, or triggers. Import data into tables with no USIs, identity columns, JIs, HIs, or triggers. Export large volumes of formatted data. Archive data. Restore data. Copy data to a different Teradata RDBMS.

Functions

Delete data.

Update data except PI or partitioning fields.

Delete data.

Atomic UPSERT.

Recover data (rollforward / rollbackward)

using

permanent journals.

B - 10

Teradata RDBMS Database Administration Appendix B: Import/Export Utilities

Client Utilities Feature Comparison

Feature BTEQ TPump FastLoad MultiLoad FastExport Archive/Recovery (ARC/NetVault)
SQL DDL support All All CREATE TABLE DROP TABLE DATABASE All All N/A
INSERT INSERT INSERT INSERT SELECT For handling
Previous << 1 .. 186 187 188 189 190 191 < 192 > 193 194 195 196 197 198 .. 218 >> Next