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

UPDATE UPDATE DELETE UPDATE of column types and indexes, see Chapter 8: "Archiving, Restoring and Recovering Data"
SQL DML support ... DELETE SELECT DELETE DELETE
... if tables have:
Identity columns All All None No Yes
Partitionin g columns All All (for better performance, do not update partitioning or PI columns) All All (except update of PI and/or partitioning columns) Yes
USIs All All None None Yes
NUSIs All All None All Yes
JIs and/or HIs All All None None Yes
Note: To prevent lock conflicts during DML operations by any supporting client sure values exist (are NOT NULL) in all PI and partitioning columns. utility, make

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)
Import data format (Formats other than data, report, and indicdata apply to network clients only.) Teradata RDBMS Data Format (data, report, and indicdata) Text (ASCII) Teradata RDBMS Data Format (data, indicdata) Binary Text Fastload Unformatted Teradata RDBMS Data Format (data, indicdata) Unformatted (specify record format in DEFINE statement) Teradata RDBMS Data Format (data, indicdata) Binary Text Unformatted (specify record format in IMPORT statement) N/A Archive/ Recovery proprietary format
Export data format (Formats other than data, indicdata and report apply to network clients only.) Teradata RDBMS Data Format (Data, indicdata, report, DIF) N/A N/A N/A Teradata RDBMS Data Format (Data, indicdata, report) Binary Text Un-formatted (record format specified in EXPORT statement) Archive/ Recovery proprietary format
Multiple Operations multiple supported DML and DDL operations in one pass DML and UPSERT operations in one pass on the input file N/As DML and UPSERT operations on five tables in one pass of the input file N/A Archive, restore, copy multiple databases, or table in a single pass of the input file Run multiple jobs in parallel
Client Failure: No Yes Yes Yes Yes Yes
Restartable Teradata RDBMS Failure: Yes
Inmod Support No Yes Yes Yes Yes N/A

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)
Outmod Support No N/A N/A N/A Yes N/A
Checkpoint Capability No Yes Yes Yes Yes Yes
Session Limit MVS: 200 VM: 200 UNIX: 20 System limit Cannot exceed the total number of AMPs Cannot exceed the total number of AMPs Cannot exceed the total number of AMPs 255 sessions per job
Data Transfer Method Import a row at a time Export a block at a time Import a row at a time Export a block at a time block at a time block at a time block at a time block at a time
User-defined TIME and TIMESTAMP data types Yes (using .EXPORT command) No Yes Yes Yes Yes

B - 10 Teradata RDBMS Database Administration

Appendix B: Import/Export Utilities

Choosing the Best Utility

Choosing the Best Utility

As you can see from the preceding utilities comparison table, several utilities have similar functions. In order to optimize performance on resource utilization, it is important to choose the best utility for your job.

Guidelines

To better understand the guidelines in this section, refer to the following definitions:

Term Meaning
Small table <1 million rows
Large table >100 million rows
Small number of rows <5% of total rows
Moderate number of rows 20 - 30%of total rows
Large number of rows 40 - 50% of total rows

The following table provides some guidelines you can use to make the best choice of utilities. Keep in mind that you may find a better way through experimenting:

Task First Choice Second Choice
Insert a small number of rows into an empty table FastLoad TPump/BTEQ
Insert a large number of rows into an empty table FastLoad TPump
Insert a small number of rows into a small populated table BTEQ, MultiLoad, or TPump when the transaction density is too low for satisfactory performance
Insert a small number of rows into a large populated table TPump or BTEQ
Insert a moderate number of rows into a large populated table MultiLoad TPump when the transaction density is too low for satisfactory performance

B - 14

Teradata RDBMS Database Administration Appendix B: Import/Export Utilities

Choosing the Best Utility

Task First Choice Second Choice
Insert a large number of rows into a large populated table MultiLoad 1 FastLoad rows into an empty table. 2 INSERT SELECT both tables without a new one.
Insert a large number of rows into multiple populated tables Multiload TPump
Insert a large number of rows into multiple empty tables Multiple FastLoads MultiLoad
Export a small number of rows from any table BTEQ FastExport
Export a moderate or large number of rows from a large table FastExport BTEQ
Update a small number of rows in any table TPump BTEQ
Previous << 1 .. 187 188 189 190 191 192 < 193 > 194 195 196 197 198 199 .. 218 >> Next