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.
| 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.