Bulk Load | Teradata Business Continuity Manager - Bulk Load - 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 a bulk load client submits data for loading, Business Continuity Manager controls the data load operation on each target Teradata system. Bulk load operations are run independently across multiple Teradata systems, and automatic recovery and restarts occur if data loading is interrupted. Business Continuity Manager always runs the load checkpoint and load completions on the active system first. If successful, Business Continuity Manager then runs it on the standby system. If a checkpoint or load apply fails on the active system, Business Continuity Manager rolls back the load on all systems.

Business Continuity Manager supports different sized Teradata systems that load at different rates and minimizes impact on the bulk load client when a system is offline. Business Continuity Manager manages an internal disk array to accommodate the disk space requirements for landing data before loading the data to Teradata systems. Data is landed to disk for any of the following reasons:
  • Data cannot be loaded to one or more target systems due to target, error, or restart tables in the interrupted state or an unavailable target system.
  • A data checkpoint did not occur on all systems, and there is insufficient memory to store the data in memory.
  • A data checkpoint succeeds on the active system, but fails on the standby system.

Business Continuity Manager deletes landed data stored on the disk array after the data successfully loads to the Teradata systems, or the begin loading record of the bulk load job is overwritten in the recovery log. Management of the disk space by Business Continuity Manager reduces the total amount of disk space required for the load files.