Scenario: ExampleBANK reclaiming table and index space - Creating an insert time clustering table

Insert time clustering (ITC) tables can help Olivia, and ExampleBANK, manage database size more effectively without manual intervention or database downtime.

Olivia creates an insert time clustering table as a test. The ORGANIZE BY INSERT TIME clause ensures that the table is created as an ITC table:

DB2 CREATE TABLE T1(c1 int, c2 char(100), ...) IN TABLESPACE1
      ORGANIZE BY INSERT TIME;
DB2 CREATE INDEX INX1 ON T1(C1);