Chapter 3. Administration 49
When you define the database information, you must determine the number of rows 
(Maximum Rows) that are stored in each database table and the number of report loads that 
are included in each database table. These values are important to system performance and 
maintenance.
Maximum Rows value
Physically, an application group consists of one or more tables that contain the index data for 
the stored documents and reports. Each table is referred to as an application group segment 
table. The Maximum Rows value determines how many data rows are loaded into each of 
these “segment” tables. When the Maximum Rows value is reached, the open segment table 
is closed and a new segment table is created. We selected the default value of 10 million rows 
because in most cases, this value is sufficient for balancing the performance of data loads 
and queries. 
Consider the following factors when you specify the Maximum Rows value:
/SM590000The number of rows that is specified needs to be large enough to handle the largest 
possible input report file. 
/SM590000Decrease the value if the total number of indexes (documents) that is stored for the 
application group will never reach the 10 million rows value.
/SM590000Increase the Maximum Rows value if the 10 million rows value is too small compared to 
the number of indexes (documents) to be stored so that many application group segment 
tables are created and as a result, a single user query results in a search of multiple 
tables.
Storage Management
The Storage Management setting determines how long report data and indexes are kept in 
cache storage before they are expired. Options determine how soon data is migrated to 
archive storage after the report load completes.
For a detailed description of the storage management options, see Chapter 5, “Storage 
management” on page 89.