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)

Preparations

The TimesTen Client must be installed on every host (Platform or Execution Context instance) that is connected to a TimesTen data source.

...

1. Place the ttjdbc11.jar file in the $MZ_HOME/3pp directory.

2. Setting Java library path to include TimesTen library.

...

1. Include TimesTen library to Java library path

   Code Block
   vi $MZ_HOME/common/config/cell/default/master/cell.conf # Update existing property value as below java.library.path="$TIMESTEN_HOME/install/lib"

2. Topo activate changes.

...

...

1. Topo activate

   Code Block
   mzsh topo activate --allow-disconnected

2. Restart the Platform and ECs for the change to take effect.
   Additionally, the TIMESTEN_HOME variable in the shell from which you launch the Platform or Execution Context instance, should include the path to the TimesTen Client native library.

export TIMESTEN_HOME=/path/to/timesten_home

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.

$ mzsh topo set topo://container:<container>/pico:<pico name>/val:config.properties.timesten.connectionpool.maxlimit 45

...