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 .

  1. Place the ttjdbc6.jar file in the $MZ_HOME/3pp directory.
  2. 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