8.6.14 TimesTen
This section contains information that is specific to the database type TimesTen.
Supported Functions
The TimesTen database can be used with:
- Audit Profile
- Database Bulk Lookup Functions (APL)
- Database Table Related Functions (APL)
- Event Notifications
- Prepared Statements (APL)
- Shared Table Profile
- SQL Collection/Forwarding Agents
- Task Workflows Agents (SQL)
Note!
When storing a date MIM value in TimesTen, do not use the DATE column type. Instead, use the TIMESTAMP type.
Preparations
The TimesTen Client must be installed on every host (Platform or Execution Context instance) that is connected to a TimesTen data source through .
- Place the ttjdbc6.jar file in the
$MZ_HOME/3pp directory
. - Restart the Platform and EC/ECSAs for the change to take effect.
Additionally, the LD_LIBRARY_PATH
variable in the shell from which you launch the Platform or Execution Context instance, should include the path to the TimesTen Client native library.
Example - $TT_HOME is set to the path where TimesTen is installed
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$TT_HOME/tt70/lib
Performance Tuning
In order to use the direct driver, you must install TimesTen on the Execution Context hosts. By doing so you improve performance.
To decrease re-connection overhead, database connections are saved in a connection pool. To configure the connection pool size, set the Execution Context property timesten.connectionpool.maxlimit
in relevant <pico>.conf
file.
Example - Configuring the connection pool size for TimesTen
$ mzsh topo set topo://container:<container>/pico:<pico name>/val:config.properties.timesten.connectionpool.maxlimit 45