Lifecycle Properties

You can modify an object's properties from its property sheet. To open a lifecycle property sheet, double-click its Browser entry in the Lifecycles folder.

Property Description
Name Specifies the name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users.
Code Specifies the technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces.
Comment Specifies a descriptive label for the item.
Stereotype Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined.
Policy type Specifies the criteria used to advance data through the lifecycle. You can choose between:
  • Age-based - where data are moved from phase to phase in named partitions depending on the time since their creation.
  • Access-base - where tables are moved from phase to phase depending on the time since the data in the tables were last accessed.
Start date [age-based lifecycles only] Specifies the date from which you want the lifecycle to manage data movement.
Total retention

Specifies the total length of time during which data is controlled by the lifecycle. For example, if you specify a total retention of 5 years, the lifecycle will manage the movement of each record from the moment of its creation until it has existed for 5 years.

For age-based lifecycles, the total retention time must be equal to the sum of all the retention times of all the phases contained within the lifecycle.

For access-based lifecycles, the total retention time is used as the minimum total time that the data must remain in the lifecycle.

Partition range [age-based lifecycles only] Specifies the period of data to be contained in partitions for tables governed by the lifecycle. For example, a partition range of one month means that each partition will contain one month's data.

Lifecycle Property Sheet Phases Tab

Lists the phases (see Phases (PDM)) associated with the lifecycle. You can create phases directly on this tab.

Lifecycle Property Sheet Tables Tab

Lists the tables subject to the lifecycle. You can add tables to the lifecycle on this tab and also specify all the properties necessary for them to participate in the lifecycle. The following tools are available on this tab:

Tool Description
properties.gif Properties - Opens the property sheet of the selected table.
Analyze Cost Saving Analyze Cost Saving - Calculates an estimate of the cost savings to be obtained by moving the data to cheaper storage during the course of the lifecycle.
addobjects.gif Add Objects - Opens a dialog to add tables to the lifecycle. Note that if the lifecycle is used to archive data in an external database, the choice of tables to attach is limited to the tables in the external database, and the selected tables are generated to the warehouse PDM if they were not already present.
Create an Object Create an Object - Creates a new table and adds it to the lifecycle.
delete.gif Delete - Detaches the selected table from the lifecycle.
findarow.gif Find a Row - Opens a dialog to let you search the list.
customizecolumnsandfilter.gif Customize Columns and Filter - Opens a dialog to control the display of columns in the tab, and filter their contents.
enabledisablefilter.gif Enable/Disable Filter - Applies the specified filter.