ttConfiguration

The ttConfiguration built-in procedure returns the values for most, but not all, connection attributes and some options for the current database connection.

Required Privilege

This procedure requires no 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.

Related Views

This procedure has these related views.

SYS.GV$CONFIGURATION

SYS.V$CONFIGURATION

Syntax

ttConfiguration(['paramName'])

Parameters

ttConfiguration has the optional parameter:

Parameter	Type	Description
`paramName`	`TT_VARCHAR (30)`	The name of a connection attribute or option for which you want this procedure to return the value.

Result Set

ttConfiguration returns the result set:

Column	Type	Description
`paramName`	`TT_VARCHAR (30) NOT NULL`	The names of the connection attributes specified in the connection string, returned in alphabetical order.
`paramValue`	`TT_VARCHAR (1024)`	The values of the connection attributes specified in the connection string.

Examples

To see the value of the QueryThreshold connection attribute, use

CALL ttConfiguration('querythreshold');
<QueryThreshold, 0>
1 row found

To see the values of all attributes, use:

CALL ttConfiguration();
< CkptFrequency, 600 >
< CkptLogVolume, 0 >
. . .

Notes

The values of client driver attributes are not returned by this procedure.
The values of some attributes, such as ForceConnect, may not be returned by this procedure, as well.