Skip to main content

Datometry Documentation

Enable Generation 2 Bulk Load Error Handling

The second generation of Hyper-Q bulk load error handling, generation 2 improves performance and provides more information about errors than the previous version of bulk load error handling, advanced adaptive error handling (AAEH). You enable generation 2 bulk load error handling using the Hyper-Q hint bulk_load_err_gen2.

If generation 2 bulk load error processing encounters an error, it will fall back to AAEH error handling for errors on DML operations other than INSERT. If you enable AAEH and generation 2 error handling in your Hyper-Q environment, AAEH (which you enable using the configuration parameter bulk_load_retry_max_error_rows), is ignored.

The syntax for bulk_load_err_gen2 is:

bulk_load_err_gen2 = true | false | force

where:

Parameter

Description

true

Enable generation 2 to bulk load error handling.

false

Disables generation 2 bulk load error handling.

force

When set to force , Hyper-Q will perform a hard abort that interrupts bulk loader execution if it encounters an error.

Hint Scope

The bulk_load_err_gen2 hint can be specified at the request, session, and global level. To learn more about Hyper-Q SQL hints, and how to use them within a SQL query, see About Hyper-Q SQL Hints.

Example 68. Specify that Hyper-Q use Generation 2 Bulk Load Error Handling as a Global Setting

You can specify bulk_load_err_gen2 as a global setting in the Hyper-Q configuration file (dtm.ini). To enable bulk_load_err_gen2, set it to true. The default value is false.

"gateway".bulk_load_err_gen2 = true

To learn more about specifying a hint as a gateway option in the Hyper-Q configuration file, see Gateway Configuration Parameters



Example 69. Specify that Hyper-Q use Generation 2 Bulk Load Error Handling as a Query Hint

You can specify bulk_load_err_gen2 as a query hint at either the session or request level. This example specifies that the hint be used at the for session level.

SET QUERY_BAND = 'UtilityDataSize=LARGE;' FOR SESSION
--@dtm_bulk_load_err_gen2=true for session
BEGIN LOADING Employee ERRORFILES ErrorTable1,ErrorTable2 CHECKPOINT 50000;

To learn more about Hyper-Q SQL hints, and how to use them within a SQL query, see About Hyper-Q SQL Hints.