16.20 - Load Isolation Enhancements - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

You can now perform load operations on load isolated (LDI) tables in a single load transaction or multiple transactions within one or more sessions. When data is loaded into load isolated tables over multiple sessions, one master session controls the start and end of a load operation.

You can use the new BEGIN ISOLATED LOADING statement to start an explicit load operation. Tables continue to be in a load state until you perform an END ISOLATED LOADING statement. Multiple sessions can load tables after you start the explicit load. Any session performing a load on the tables is considered a load session. The tables remain in a pending commit state until the load is committed. A session can be a load session for an explicit load operation on one table and an implicit load transaction on another table.

Benefits

  • Load operations on LDI tables can span multiple transactions.
  • Multiple sessions can load LDI tables.

Considerations

  • After you perform the BEGIN ISOLATED LOADING statement, you must set the LDILoadGroup reserved query band to the load group you want to use for the load operations.
  • A load isolated table can be either in an explicit load state or an implicit load state, but not both. In an implicit load operation, the first concurrent load isolated (CLDI) operation in a transaction starts the load and is committed at the time of transaction commit.

SQL Changes

  • BEGIN ISOLATED LOADING statement
  • CHECKPOINT ISOLATED LOADING statement
  • END ISOLATED LOADING statement
  • LDILoadGroup reserved query band

Additional Information

For more information on Load Isolation enhancements, see:
  • Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144
  • Teradata Vantage™ - Database Administration, B035-1093