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
Start of changeDefault:End of change Start of change1End of change
Data sharing scope: It is recommended that all members use the same setting.
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:

Start of change
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. Start of changeThis is the default setting.End of change
2
Insert algorithm 2 is used unless INSERT ALGORITHM 1 was specified when the table space was created or altered.
End of change