DEFAULT INSERT ALGORITHM field (DEFAULT_INSERT_ALGORITHM subsystem parameter)
The DEFAULT_INSERT_ALGORITHM subsystem parameter specifies the default algorithm for inserting data into table spaces.
This subsystem parameter is new in Db2 12. It can be set at any function level, but it takes effect only after activation of function level 500 or higher.
| Acceptable values: | 0, 1, 2 |
|---|---|
 Default: |
1 |
| Data sharing scope: | Same setting recommended on all members |
| Online changeable: | Yes |
| DSNZPxxx: | DSN6SPRM.DEFAULT_INSERT_ALGORITHM |
The following list describes how the DEFAULT_INSERT_ALGORITHM subsystem parameter setting is applied in relation to the INSERT ALGORITHM clauses of the CREATE TABLESPSACE and ALTER TABLESPACE statements:
- 0
- The basic insert algorithm (insert algorithm 1) is always used regardless of any INSERT ALGORITHM parameter setting that might have been specified when the table space was created or altered.
- 1
- The basic insert algorithm is used unless INSERT ALGORITHM 2 was specified when the table space was created or altered. This is the default setting.
- 2
- Insert algorithm 2 is used unless INSERT ALGORITHM 1 was specified when the table space was created or altered.