DBC database connectors performance when bulk loading data.

0 Likes
over 2 years ago

Problem :

How to improve performance of Database Connectors when bulk loading data.

Resolution :

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

References :

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

Comment List
Anonymous
Related Discussions
Recommended