CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);

CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);

CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);

CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER;

New table spaces will start consuming storage on the new path.

Existing table spaces will not consume storage on the new path.

The storage group will be placed in "Rebalance Pending" mode.

DB2 will verify that space is available on the storage path specified.

The MON_GET_CONTAINER table function.

The SNAP_GET_TBSP_PART table function.

The SNAPTBSP_RANGE administrative view.

The TS_GET_CONTAINER administrative view.

To use value compression, you must have a license for the DB2 Storage Optimization Feature.

Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.

Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.

When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same

Page-level dictionaries are stored in hidden rows within the table.

Table-level dictionaries are stored in hidden rows within the table.

Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.

Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.