ttRamPolicyGet

This procedure returns the RAM policy used to determine when a database is loaded into memory. The policy can be either always, manual, or inUse.

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

ttRamPolicyGet()

Parameters

ttRamPolicyGet has no parameters.

Result Set

ttRamPolicyGet returns the results:

Column Type Description

Column	Type	Description
`ramPolicy`	`TT_VARCHAR (10)`	The policy used to determine when the database is loaded into system RAM. Valid values are: `always` - Specifies that the database should remain in system RAM all the time. `manual` - Specifies that the database is only to be loaded in system RAM when explicitly loaded by the user, using the `ttAdmin` `-ramLoad` command. `inUse` (default) - Specifies that the database is only loaded in system RAM when in use (when applications are connected). This option cannot be used with temporary databases. TimesTen only allows a temporary database to be loaded into RAM manually. Trying to set the policy generates a warning. This policy is not supported in TimesTen Scaleout.
`ramGrace`	`TT_INTEGER`	If the `ramPolicy` is `inUse`, this field reports the number of seconds the database is kept in RAM after the last application has disconnected. Otherwise, this field is `NULL`.

ramPolicy

TT_VARCHAR (10)

The policy used to determine when the database is loaded into system RAM. Valid values are:

always - Specifies that the database should remain in system RAM all the time.

manual - Specifies that the database is only to be loaded in system RAM when explicitly loaded by the user, using the ttAdmin -ramLoad command.

inUse (default) - Specifies that the database is only loaded in system RAM when in use (when applications are connected). This option cannot be used with temporary databases. TimesTen only allows a temporary database to be loaded into RAM manually. Trying to set the policy generates a warning. This policy is not supported in TimesTen Scaleout.

ramGrace

TT_INTEGER

If the ramPolicy is inUse, this field reports the number of seconds the database is kept in RAM after the last application has disconnected. Otherwise, this field is NULL.

Parameters

ttRamPolicyGet has no parameters.

Examples

To view the RAM policy, use:

CALL ttRamPolicyGet();