Loading index data

The ADDRPTOND command works with the database manager to add the index data to the database. Depending on the database organization that you specified when you defined the application group, IBM® Content Manager OnDemand either creates a new table each time that you load a report or adds the index data to an existing database table.

Content Manager OnDemand uses a segment table as a high level index to the index data for an application group. Each row in the segment table identifies a specific table of application group index data. The fields in the segment table identify the application group and the dates found in a table. The dates represent the earliest and latest dates that can be found in that segment of application group index data. Content Manager OnDemand can use the segment table to limit a query to a specific table of application group index data.

The database manager updates the segment table if the beginning date in the report is earlier than a date already stored in the table.

Content Manager OnDemand limits the size of a table to improve performance and storage management. The number of rows in a table can be specified when you define the application group. The default size of a table is ten million rows. The database manager automatically closes a table and opens a new table when this threshold is reached. When closing a table, the database manager updates the segment table with the latest ending date found in the table.