To correctly model a lifecycle you must define the lifecycle and its phases, and then associate your tables to it.
-
Select to access the List of Lifecycles, and click the Add a Row tool.
-
Click the Properties tool to open the lifecycle property sheet, and specify a name and start date and to specify the total retention period that the lifecycle must cover.
-
Click the Phases tab, and create as many phases as you need. Lifecycles often contain three phases to cover high performance, nearline, and historical storage.
-
Select each phase in turn and click the properties tool to open its property sheet. Specify a name, retention period and tablespace to represent the physical storage in which the data is stored during this phase.
-
Open the property sheet for each of your tablespaces and enter any appropriate properties, including a value for the cost per GB to be used when calculating cost savings.
-
Returning to the lifecycle property sheet, click the Tables tab and select the tables you want to associate with the lifecycle. For each table, specify the start date on which you want it to become subject to the lifecycle (which cannot be earlier than the start date of the lifecycle) and enter an estimate for the initial number of rows and a percentage growth rate to permit the calculation of cost savings.
Note: If you intended to model multiple lifecycles, and/or want to confirm that all of your tables are associated with a lifecycle, you may find it useful to visualize these associations in the form of a dependency matrix. To view the Lifecycle/Table Matrix, select .
-
[optional] You can, at any time, select one or more tables in the list and click the Estimate Cost Savings tool to estimate the savings to be accrued for them by the timely transfer of data to cheaper storage. You can view the detail of the cost savings by year on the Lifecyle tab of each table property sheet (see Table Properties).