Ingest utility configuration parameters

You can set these configuration parameters to control how the INGEST utility performs on your Db2® client.

commit_count - Commit count configuration parameter
This parameter specifies the number of rows each flusher writes in a single transaction before issuing a commit.
commit_period - Commit period configuration parameter
Specifies the number of seconds between committed transactions.
num_flushers_per_partition - Number of flushers per database partition configuration parameter
Specifies the number of flushers to allocate for each database partition.
num_formatters - Number of formatters configuration parameter
Specifies the number of formatters to allocate.
pipe_timeout - Pipe timeout configuration parameter
This parameter specifies the maximum number of seconds to wait for data when the input source is a pipe.
retry_count - Retry count configuration parameter
Specifies the number of times to retry a failed, but recoverable, transaction.
retry_period - Retry period configuration parameter
Specifies the number of seconds to wait before retrying a failed, but recoverable, transaction.
shm_max_size - Maximum size of shared memory configuration parameter
Specifies the maximum size of Inter Process Communication (IPC) shared memory in bytes. Because the ingest utility runs on the client, this memory is allocated on the client machine.

Parent topic: Configuration parameters