Versions Compared

Version Old Version 1 New Version Current
Changes made by

Jenni Wallin

Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section contains information that is specific to the database type TimesTen.

Supported Functions

  The TimesTen database can be used with:

...

Note
titleNote!

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 Image Added .

  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.

Info
titleExample - $TT_HOME is set to the path where TimesTen is installed


Code Block
languagetext
themeEclipse
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.

...

Info
titleExample - Configuring the connection pool size for TimesTen


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



Scroll ignore
scroll-viewportfalse
scroll-pdftrue
scroll-officefalse
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmlfalse


Next:



Scroll pagebreak