Maximum Rows

If you select the Multiple loads per database table database organization:

• Content Manager OnDemand uses the value to determine when to segment application group index data. That is, when a table of application group index data contains the number of rows specified in the Maximum Rows field, Content Manager OnDemand closes the table and initializes a new table. The closed table supports queries. Content Manager OnDemand adds index records created during subsequent input processing to the new table.
• On z/OS and Multiplatforms servers, the default value of 10000000 balances query and data loading performance. If the application group contains a small amount of data, then you should decrease the value provided. A smaller value typically provides better query performance, without affecting data loading time. If you plan to archive a very large amount of data in the application group and the index data must reside in the same table, then you should increase the value provided. However, you might experience longer data loading times when an application group index table exceeds 10 million rows. On IBM i servers, the default setting is Single table for all loads. All index data loaded into the application group is stored in one table.
• The maximum value you can specify in the Maximum Rows field is 2147483647.

IBM recommends that you use the default value of ten million rows on z/OS and Multiplatforms servers, and Single table for all loads on IBM i servers.

For the Single load per database table database organization:

• Content Manager OnDemand uses the value to determine the amount of space to allocate for each table.
• Content Manager OnDemand allocates the same amount of space for each table, regardless of the number of rows added to the database. For example, assume that the average number of indexed items in an input file is 20,000. However, one input file per month contains 50,000 indexed items. If you select the Single load per database table database organization, then you should specify 50000 in the Maximum Rows field, so that Content Manager OnDemand allocates enough space to hold the items for the largest input file.