Verify that SET SESSION AUTOCOMMIT is set to off - Connect_ETL - 9.13

Connect ETL Vertica Load Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
Language
English
Product name
Connect ETL
Title
Connect ETL Vertica Load Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-11
ft:lastPublication
2023-09-11T19:09:11.694437

When connecting to a Vertica database through a vsql COPY command or through an ODBC connection, the SET SESSION AUTOCOMMIT option is set to Off by default.

To ensure optimal performance, Vertica recommends retaining the default SET SESSION AUTOCOMMIT setting. When SET SESSION AUTOCOMMIT is set to Off, transactions are not automatically committed after a specified number of records are processed.

For additional information on SET SESSION AUTOCOMMIT, see the SQL Statements section of the Vertica Enterprise SQL Reference Manual.