Sample SQL for Enabling ILM for MDM (Initial Install)

This section provides more detail about steps needed to fully support ILM on tables for maintenance objects that support the functionality.

Three maintenance objects are shown:

• To Do Entry - does not include a LOB field.

• Sync Request - does include a LOB field and has one tablespace per partition.

• Initial Measurement Data - includes LOB fields and has one tablespace per subpartition (shown using subretention). Other maintenance object's implementations can follow the appropriate pattern based on whether there is a LOB field or not.

The following DDL(s):

• Follows Naming convention recommendations for partitions\subpartitions\tablespaces.

• Ensures all the ILM Storage requirements are incorporated, failing which, ILM functionality will not be achieved.

• Partitions/subpartitions are defined with respective Tablespace.

• Child Tables are referenced partitioned.

• Ensures all Compression recommendations are incorporated.