DB2 10.5 for Linux, UNIX, and Windows

INGEST SET command

Sets a configuration parameter for subsequent INGEST commands in the current CLP session.

Scope

The setting affects only later INGEST commands in the same CLP session that share the same CLP backend process. It does not affect INGEST commands in other CLP sessions or later CLP sessions that use a different CLP backend process.

Authorization

None.

Required connection

None.

Syntax


>>-INGEST SET--config-param--| value |-------------------------><

value

|--+-integer---------------+------------------------------------|
   +-| Boolean-value |-----+   
   '-| memory-size-value |-'   

Boolean-value

|--+-YES-+------------------------------------------------------|
   +-Y---+   
   +-NO--+   
   +-N---+   
   +-ON--+   
   +-OFF-+   
   +-0---+   
   '-1---'   

memory-size-value

|--integer--+----+----------------------------------------------|
            +-KB-+   
            +-MB-+   
            '-GB-'

Command parameters

config-param: Specifies one of the ingest configuration parameters
value: Specifies a value for the ingest configuration parameter. Each configuration parameter accepts either an integer value, a Boolean value, or a memory size value

Example

INGEST SET num_flushers_per_partition 5;
INGEST SET shm_max_size 2 GB;