TPump Utility
TPump (Teradata Parallel Data Pump) is a utility that provides highvolume
batch maintenance of large Teradata Databases.
It enables
acquisition of data from the client with low processor utilization.
The Support Environment enhances TPump's functionality. In addition to
coordinating activities involved in TPump tasks, it provides facilities for
managing file acquisition, conditional processing, and certain DML (Data
Manipulation Language) and DDL (Data Definition Language) activities on
the Teradata Database.
The Support Environment enables an additional level of user control over TPump.
TPump uses row-hash locks, making concurrent updates on the same
table a possibility.
TPump has a built-in resource governing facility that allows the operator to
specify how many updates occur (the statement rate) minute by minute,
then change the statement rate while the job continues running. This
utility can be used to increase the statement rate during windows when
TPump is running by itself, then decrease the statement rate later on if
users log on for ad-hoc query access.
TPump can always be stopped and all work will be committed as run.
TPump does not utilize one of the loader slots used by FastLoad,
MultiLoad, and FastExport, so many TPump jobs can run concurrently.
The slide on the opposite page identifies the principal features of the
TPump utility.
No comments:
Post a Comment