How to improve performance of Database Connectors when bulk loading data.
In the ACU configuration file, pointed to by the A_CONFIG environment variable.
Set
4GL_COMMIT_COUNT=1024
Using 4GL_COMMIT_COUNT=1024 should increase performance when loading the database.
Example ACU configuration file entries needed for bulk loading of data.
DEFAULT_HOST=ODBC A_ODBC_DATASOURCE=mssqlrh7sup A_ODBC_LOGIN=SA A_ODBC_PASSWD=zx81rocks A_ODBC_LOCK_METHOD=SETSTMTOPTION 4GL_COMMIT_COUNT=1024
4GL_COMMIT_COUNT configuration variable
extend Product GuidesAcu4GL Version 10.2.1 User's GuideCompiler and Runtime OptionsRun-time Configuration Variables4GL_COMMIT_COUNT configuration variable
A_DB2_ALTERNATE_COMMIT_LOGIC configuration variable
extend Product GuidesAcu4GL Version 10.2.1 User's GuideAppendix F: Acu4GL for DB2Configuration File VariablesA_DB2_ALTERNATE_COMMIT_LOGIC configuration variable
Record and Table Locking
extend Product GuidesAcu4GL Version 10.2.1 User's GuideAppendix D: Acu4GL for ODBCRecord and Table Locking
ACUFH Configuration Variables
ACUFH Configuration File Variables for ODBC
Support
Documentation
Learning Services
Partner Programs