ttRamPolicyAutoReloadSet

This procedure determines the RAM autoreload policy if a database is invalidated. The policy can be either autoreload or noautoreload.

Required Privilege

This procedure requires the ADMIN 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

ttRamPolicyAutoReloadSet(flag)

Parameters

ttRamPolicyAutoReloadSet has the parameters:

Parameter Type Description

Parameter	Type	Description
`flag`	`TT_INTEGER NOT NULL`	The policy used to determine if the database is reloaded into RAM after an invalidation. Valid values are: `0` - The database is not automatically reloaded into memory after an invalidation. This is the equivalent of the command `ttAdmin -noAutoReload`. `1` - The database is automatically reloaded into memory after an invalidation. This is the equivalent of the command `ttAdmin -autoReload`. This is the default autoreload policy.

flag

TT_INTEGER NOT NULL

The policy used to determine if the database is reloaded into RAM after an invalidation. Valid values are:

0 - The database is not automatically reloaded into memory after an invalidation. This is the equivalent of the command ttAdmin -noAutoReload.

1 - The database is automatically reloaded into memory after an invalidation. This is the equivalent of the command ttAdmin -autoReload. This is the default autoreload policy.

Result Set

ttRamPolicyAutoReloadSet returns no results.

Examples

To automatically reload a database into RAM after an invalidation, use:

CALL ttRamPolicyAutoReloadSet(1);