Whic date controls expiration?

[pankaj.puranik]

Could someone please confirm that the date which is marked as segment date is considered when it comes to expiration of document.

For example,
If load date is marked as segment date then it would be considered.
If report date is marked as segment date then report date would be considered while expiring the document.

[Alessandro Perucchi]

Hello Pankaj,

Well you have basically 2 types of expiration of document:

Expiration type:

- SEGMENT / LOAD

For these 2 types of expiration, CMOD will use the "SEGMENT DATE" to check what needs to be expired.

- DOCUMENT

For this expiration type, it checks the date associated with the "EXPIRE DATE" option of a date field in the application group field information.



For you information here are the difference between the 2 options (http://publib.boulder.ibm.com/infocenter/cmod/v8r4m1/topic/com.ibm.ondemand.mp.doc/arsa0093.htm)

Segment. If the Data Type of the field is date or date/time, identifies the field that OnDemand uses to limit the number of tables it searches to complete a query. You can specify one and only one Segment field. If the Database Organization is Multiple Loads per Database Table, IBM strongly encourages you to define a Segment field for the application group. Limiting a query to a specific table or set of tables significantly improves the performance of queries for application groups that contain large amounts of data. When you create an application group and do not define a Segment field, OnDemand issues a warning message. Only under unusual circumstances would you ever create an application group and not define a Segment field. OnDemand uses the value of the Segment field to determine when to delete data from the application group. If you do not define a Segment field, OnDemand uses the date that the input file was loaded to determine when to delete the segment from the application group. If the Segment field contains a date in the MMYY format, then OnDemand deletes segments on the first day of the month (MM).

Expire Date. If the Data Type of the field is date or date/time and the Expiration Type is Document, identifies the field that OnDemand uses to determine when to delete documents from the application group. You can specify one and only Expire Date field. If the Expire Date field contains a date in the MMYY format, then OnDemand deletes documents on the first day of the month (MM).


And this one for the Expiration Type available (http://publib.boulder.ibm.com/infocenter/cmod/v8r4m1/index.jsp)


Cheers,
Alessandro