When you configure result set caching, the Data Integration Service caches the results of the DTM process associated with each web service request. The Data Integration Service caches the results for the expiration period that you configure. When an external client makes the same query or request before the cache expires, the Data Integration Service returns the cached results. If a cache does not exist or has expired, the Data Integration Service starts a DTM instance to process the request.

When the amount of data in the cache exceeds the maximum cache size memory, the Data Integration Service stores the result set in an encrypted cache file at

<Informatica_install_dir>/tomcat/bin/disTemp/<Service_Name>/<Node_Name>/

.

The Data Integration Service stores the result set cache for web services by user when the web service uses WS-Security. The Data Integration Service stores the cache by the user name that is provided in the username token of the web service request. When the Data Integration Service caches the results by user, the Data Integration Service only returns cached results to the user that sent the web service request.

Use the following steps to configure result set caching in the Administrator tool:

Configure the result set cache properties in the Data Integration Service Process properties.
The following table describes the result set cache properties:
Property	Description
Maximum Total Disk Size	Maximum number of bytes allowed for the total result set cache storage. Default is zero.
Maximum Per Cache Memory Size	Maximum number of bytes to allocate for a single result set cache instance in memory. Default is zero.
Maximum Total Memory Size	Maximum number of bytes allocated for the total result set cache storage in memory. Default is zero.
Maximum Number of Caches	Maximum number of result set cache instances allowed for the Data Integration Service. Default is zero.
Configure the cache expiration period in the SOAP web service operation properties or the REST web service resource properties.
The result set cache expiration period if the number of milliseconds that the result set is available to use. If set to -1, the cache never expires. If set to zero, result set caching is disabled. Changes to the expiration period do not apply to existing caches. To set all caches to use the same expiration period, purge the result set cache after you change the expiration period. Default is zero.
To enable the Data Integration Service to cache the results by user, enable WS-Security in the web service properties.

To disable result set caching for a web service request when the web service operation is configured to cache the result set, include the following syntax in the HTTP header of the SOAP request:

WebServiceOptions.disableResultSetCache=true