CONNX will automatically issues a commit every specified number of inserts, regardless of transaction mode.  Important warning:  Setting COMMITCOUNT to a value other that zero can cause transactions to be committed earlier than expected, and subsequent rollbacks will be ineffective or incomplete.

 

    COMMITCOUNT=1000

 

Default = 0.

 

Environments: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  COMMITCOUNT

 

Unix Registry Setting: CONNX.COMMITCOUNT