- From the Service Configuration view, click Advanced.
Under Advanced Details, enter a number for any of the following metrics:
Metric Description Maximum number of rows to spool per query Maximum number of rows that are returned by an asynchronous query.
Default value: 1,000,000
Maximum number of spooled result sets Number of result sets to keep.
Increase this number if you have many short queries or a heavily used Query server.
After this setting is reached, the oldest spool files are automatically deleted until approximately 10% of the maximum result set count is deleted.
Default value: 1,000
Maximum retention time for spooled result sets Number of hours results are stored for asynchronous queries before they are deleted.
The minimum setting is 1 hour.
Every hour, all spool files that exceed the maximum retention time are deleted.
Default value: 24 hours
Maximum space available for spooled result sets Total allocated space, in gigabytes, for saving result sets of asynchronous queries before they are deleted.
After this setting is reached, the oldest spool files are automatically deleted until approximately 10% free space is reached.
Increase this number for a heavily used Query server.
Default value: 20 GB
[Optional] Enter a new default location of the spool directory that stores the result sets for asynchronous queries.
Current default location is /var/opt/teradata/rest/daemon/spool.
- Click Apply.
When you set queries with an asyncResponse flag, the result sets are saved. You can set limits for these saving these metrics.