Sample SQL for Enabling ILM in C2M for CC&B (Initial Install)

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

• To Do Entry, which does not include an LOB field.

• Sync Request, which does include an LOB field.

Other maintenance object's implementations can follow the appropriate pattern based on whether there is a LOB field or not.

The following DDL(s):

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

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

• Partitions are defined with respective Tablespace.

• Child Tables are referenced partitioned.

• Make sure all compression recommendations are incorporated.