ttOptSetMaxCmdFreeListCnt

This procedure sets the maximum count of the free list of SQL compiled commands for regular tables. To get the current setting use the ttOptGetMaxCmdFreeListCnt procedure.

Required Privilege

This procedure requires the ADMIN privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

TimesTen Scaleout applications can call this built-in procedure.

In TimesTen Scaleout, this procedure runs locally on the element from which it is called.

Syntax

ttOptSetMaxCmdFreeListCnt(maxCnt)

Parameters

ttOptSetMaxCmdFreeListCnt has the required parameter:

Parameter	Type	Description
`maxCnt`	`TT_INTEGER NOT NULL`	The max number of free SQL compiled commands for regular tables.

Result Set

ttOptSetMaxCmdFreeListCnt returns no results.

Examples

CALL ttOptSetMaxCmdFreeListCnt(40);