15.00 - SnapBypassAggrCache - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

SnapBypassAggrCache

Purpose  

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 Teradata 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.