17.10 - SnapBypassAggrCache - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Specifies whether snapshot dumps are suppressed if resource exhaustion is detected when reserving memory for aggregate processing.

Field Group

General

Valid Settings

Setting Description
TRUE Snapshot dumps are suppressed.

In this case, although snapshot dumps are not created when resources are exhausted, insufficient memory errors are still returned.

FALSE Snapshot dumps are created when memory resources are exhausted.

Default

TRUE

Changes Take Effect

After the next database restart.

Usage Notes

SnapBypassAggrCache can be used when submitting transactions that involve many aggregate functions, which require much cache processing. In these situations, memory resource exhaustion would normally cause snapshot dumps, slowing the system down. Use SnapBypassAggrCache to turn off snapshot dumps temporarily. If memory resources become exhausted, the transaction will be aborted with an error message, but the system will not record a snapshot dump.

To avoid masking real memory leak issues, reset SnapBypassAggrCache to FALSE when the memory intensive query has completed. Snapshot dumps are useful for tracing the cause of real memory problems.