Multiload Limitations | Teradata Business Continuity Manager - Multiload Limitations - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide

Product
Teradata Business Continuity Manager
Release Number
1.0
Published
January 2022
Language
English (United States)
Last Update
2022-01-27
dita:mapPath
otc1639627713801.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem

When Multiload (non-delete) is run straight to Teradata DBMS, locks on base multiload tables are acquired only during the APPLY phase, which starts around CHECKPOINT END. This allows you to continue accessing the base load tables until the APPLY phase starts.

Multiload (non-delete) has limitations with Business Continuity Manager. Business Continuity Manager acquires a READ lock on the base load tables at the start of a load. This supports Business Continuity Manager recovery of systems and tables. Client programs can continue to access base tables with read and access locks, until the load runs the CHECKPOINT END command. Queries that request or require the WRITE or EXCLUSIVE lock must wait until the load job terminates or completes.