224 IBM Content Manager OnDemand Guide
Scenario 4: Both cache and storage manager, then expiration
The storage object is stored directly to both cache and the storage manager. After a short 
period, the data is expired from cache. Then, after a much longer period, the data is expired 
from the storage manager. Typically, this methodology is used under the following 
circumstances:
/SM590000The cache file system allows more efficient data retrieval.
/SM590000The data needs to be kept for a longer period.
/SM590000The hierarchical storage management (or other features) of the storage manager is 
required.
The Cache data field determines whether Content Manager OnDemand stores data in cache 
storage. If the storage set is a cache-only storage set, Yes is the only selection. If the storage 
set is an archive manager-controlled storage set (OAM, Tivoli Storage Manager, or ASM), you 
can optionally add storing the data in cache.
10.2.2  Storing the index data
The Content Manager OnDemand load process extracts document indexes from the report 
data and stores the indexes in the Content Manager OnDemand database application group 
data tables. With these indexes, users can efficiently locate, select, and retrieve documents. 
Typically, indexes are expired when the document data is expired.
Each application group is segmented into multiple physical tables by using a date or a date 
and time field. The size of each physical table is determined by the Max rows setting. Each 
row in the table contains a set of user-defined and system-defined indexes that enable the 
search for a report segment or a document. Index data is loaded into a table. When the Max 
rows value is reached, the table is closed and a new table is created. The number of physical 
tables that represent an application group might grow from 1 to n.
10.2.3  Storing the resource data 
If data caching is enabled, Content Manager OnDemand stores resources in the cache. Two 
locations on the Storage Management tab affect how resources are stored:
/SM590000Resource Data
/SM590000Document Data
Note: Whether the data is stored in cache or in a storage manager, the main performance 
differences are a result of the following items:
/SM590000The hardware speed (and I/O channels and interfaces) on which the data is stored.
/SM590000The location of the hardware device in relations to the object server. 
If the hardware device connects over a TCP/IP link, that link can form a bottleneck, 
depending on the link’s throughput and the required data retrieval rate.