Configure Asynchronous Queries | Teradata Query Service - 3.01 - Configuring Asynchronous Queries - Teradata Query Service

Teradata® Query Service Installation, Configuration, and Upgrade Guide for Customers

prodname
Teradata Query Service
vrm_release
3.01
created_date
May 2019
category
Configuration
Installation
featnum
B035-2700-059K
When you set queries with an asyncResponse flag, the result sets are saved. You can set limits for these saving these metrics.
  1. From the Service Configuration view, click Advanced.
  2. 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

  3. [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.
  4. Click Apply.