Segment

Specify a date or date/time field that Content Manager OnDemand uses to limit the number of tables that it searches to complete a query. If the Expiration Type is Segment, then Content Manager OnDemand also uses the Segment field to determine when to delete data from the application group. You can specify one and only one Segment field.

When the Database Organization is Multiple Loads per Database Table, IBM recommends that you 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.

If the segment field contains a date in the MMYY format, then Content Manager OnDemand deletes segments on the first day of the month (MM).

When you create an application group and do not define a Segment field, Content Manager OnDemand issues a warning message. Only under unusual circumstances would you ever create an application group and not define a Segment field. If you do not define a Segment field, then Content Manager OnDemand uses the date that the input file was loaded to determine when to delete data from the application group.