IMSTAT Procedure (Data and Server Management)

LIFETIME Statement

The LIFETIME statement enables you to associate an expiration date with an in-memory table. You must have sufficient authorization, which is equivalent to the authorization to drop the table. The server checks periodically if any tables have expired and drops the expired ones. This frees all resources associated with those tables.

Syntax

LIFETIME time-specification <MODE= ABSOLUTE | LASTUSE >;

Required Argument

time-specification

specifies the duration (in seconds) that the table is to remain in memory. The minimum value is 1 second.

LIFETIME Statement Options

MODE=ABSOLUTE | LASTUSE

specifies how to use the time-specification. If MODE=ABSOLUTE is specified, then the server drops the table after the specified number of seconds. If MODE=LASTUSE is specified, then the server drops the table the specified number of seconds after the last successful access to the table.

Default ABSOLUTE