ttRamPolicyGet

Description

Returns the RAM policy used to determine when a data store is loaded into memory. The policy can be either always, manual, or inUse.

Required privilege

This procedure requires no privilege.

Syntax

ttRamPolicyGet()

Result set

ttRamPolicyGet returns the results:

Column Type Description

Column	Type	Description
`ramPolicy`	TT_VARCHAR (10)	The policy used to determine when the data store is loaded into system RAM. Valid values are: `always` - specifies that the data store should remain in system RAM all the time. `manual` - specifies that the data store is only to be loaded in system RAM when explicitly loaded by the user, using the ttAdmin `-ramLoad` command. `inUse` - specifies that the data store is only loaded in system RAM when in use (i.e., when applications are connected). This option cannot be used with temporary data stores. TimesTen only allows a temporary data store to be loaded into RAM manually. Trying to set the policy generates a warning.
`ramGrace`	TT_INTEGER	If the `ramPolicy` is `inUse`, this field reports the number of seconds the data store 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 data store is loaded into system RAM. Valid values are:

always - specifies that the data store should remain in system RAM all the time.

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

inUse - specifies that the data store is only loaded in system RAM when in use (i.e., when applications are connected). This option cannot be used with temporary data stores. TimesTen only allows a temporary data store to be loaded into RAM manually. Trying to set the policy generates a warning.

ramGrace TT_INTEGER If the ramPolicy is inUse, this field reports the number of seconds the data store 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();