ILM Archival

Once you execute the ILM Crawler batches, you can view the table partitions which are eligible for dropping. A table partition is eligible for dropping only when the following conditions are met:

  • All records in the table partition are eligible for dropping.

  • The high value of the table partition is earlier than or equal to the cutoff date.

The ILM Archival screen allows you to search for the table partitions which are eligible for dropping. It contains the following zone:

Note:

In the Transaction Feed Management (TFM) module, there is no physical enforcement of referential integrity between parent and child table partitions. However, if a particular partition of a parent TFM table is eligible for dropping, then its corresponding child tables are also eligible for dropping.

Please note that the parent and child table partition date range (i.e., daily, monthly, quarterly, etc.) must be same for the following TFM tables:

  • CI_​TXN_​DETAIL

  • CI_​TXN_​DTL_​PRITM

  • CI_​ROLLBACK_​TXN_​DETAIL

  • CI_​TXN_​DETAIL_​EXCP

The ILM crawler algorithm only marks the ILM_​ARCH_​SW column corresponding to the records to Y or N in the CI_​TXN_​DETAIL table. However, when you search for the eligible table partitions of the TFM module, the system lists the corresponding eligible partitions from the child tables along with the eligible partitions from the parent table.

Related Topics

For more information on... See...
How to view the table partitions which are eligible for dropping Viewing the Table Partitions Eligible for Dropping

Parent Topic: Information Lifecycle Management (ILM)