Inserting rows at the end of a partition

To specify how you want DB2® to insert rows at the end of a partition, you can use the CREATE TABLE or ALTER TABLE statement.

Procedure

To insert rows at the end of a partition:

Issue a CREATE TABLE or ALTER TABLE statement and specify the APPEND option. The APPEND option has the following settings:

YES: Requests data rows to be placed into the table by disregarding the clustering during SQL INSERT and online LOAD operations. Rather than attempting to insert rows in cluster-preserving order, rows are appended at the end of the table or appropriate partition.
NO: Requests standard behavior of SQL INSERT and online LOAD operations, namely that they attempt to place data rows in a well clustered manner with respect to the value in the row's cluster key columns. NO is the default option.

After populating a table with the APPEND option in effect, you can achieve clustering by running the REORG utility.

Restriction: You cannot specify the APPEND option for tables created in XML or work file table spaces.