ttCacheAWTThresholdGet

This procedure returns the current transaction log file threshold for databases that include AWT cache groups.

Required Privilege

This procedure requires no privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Related Views

This procedure has no related views.

Syntax

ttCacheAWTThresholdGet()

Parameters

ttCacheAWTThresholdGet has no parameters.

Result Set

ttCacheAWTThresholdGet returns the result:

Column Type Description

threshold

TT_INTEGER NOT NULL

The number of transaction log files for all AWT cache groups associated with the database. If the result is 0, there is no set limit.

Examples

CALL ttCacheAWTThresholdGet();

This procedure is available only for cache operations.