Client Utility Locks | Transaction Processing | Teradata Vantage - Client Utility Locks - Analytics Database - Teradata Vantage

SQL Request and Transaction Processing
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
zfm1628111633230.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
evd1472255317510
lifecycle
latest
Product Category
Teradata Vantage™

The Teradata Tools and Utilities programs that perform tasks such as bulk data loads (FastLoad, MultiLoad, BTEQ), bulk data exports (FastExport, BTEQ), stream data loads (Teradata Parallel Data Pump), both data loads and data exports (Teradata Parallel Transporter) place locks at different levels and severities on database resources. See About Locking Levels and About Locking Severity for details of locking levels and severities.

Locks Placed on Database Resources by Teradata Tools and Utilities

The client utilities place the following basic types of locks on database resources:
  • Standard database locks

    All of the client data loading and exporting utilities use standard database transaction locks (see Database Locks, Two-Phase Locking, and Serializability).

    For details about when the database locks that client utilities place and release on resources in the database, see the following Teradata Tools and Utilities manuals:
    • Basic Teradata® Query Reference, B035-2414
    • Teradata® FastExport Reference, B035-2410

      Teradata Parallel Transporter uses the FastExport protocol for its EXPORT operator (see Teradata® Parallel Transporter Reference, B035-2436 for details).

    • Teradata® FastLoad Reference, B035-2411

      Teradata Parallel Transporter uses the FastLoad protocol for its LOAD operator (see Teradata® Parallel Transporter Reference, B035-2436 for details).

    • Teradata® MultiLoad Reference, B035-2409

      Teradata Parallel Transporter uses the MultiLoad protocol for its UPDATE operator (see Teradata® Parallel Transporter Reference, B035-2436 for details).

    • Teradata® Parallel Data Pump Reference, B035-3021

      Teradata Parallel Transporter uses the Teradata Parallel Transporter protocol for its STREAM operator (see Teradata® Parallel Transporter Reference, B035-2436 for details).

    • Teradata® Parallel Transporter Reference, B035-2436