Difference between revisions of "Seon Core environment variables"

From Seon
Jump to: navigation, search
(Database performance benchmarking)
m
Line 1: Line 1:
 
Environment variables are created and/or set by all Seon binaries, which values are based on the configuration of Seon. These variables are:  
 
Environment variables are created and/or set by all Seon binaries, which values are based on the configuration of Seon. These variables are:  
*<code>Seon_CFGFILE</code>: [[Seon_Core_installation#Main_configuration|Seon main configuration file (absolute path information)]]
+
*<code>Seon_CFGFILE</code>: [[Seon Core main configuration file|Seon main configuration file (absolute path information)]]
 
*<code>Seon_IN_DIR</code>: [[Seon_Core_configuration#data_incoming_directory|incoming data directory]]
 
*<code>Seon_IN_DIR</code>: [[Seon_Core_configuration#data_incoming_directory|incoming data directory]]
 
*<code>Seon_OUT_DIR</code>: [[Seon_Core_configuration#data_outgoing_directory|outgoing data directory]]
 
*<code>Seon_OUT_DIR</code>: [[Seon_Core_configuration#data_outgoing_directory|outgoing data directory]]

Revision as of 20:02, 10 May 2010

Environment variables are created and/or set by all Seon binaries, which values are based on the configuration of Seon. These variables are:

All processes started by Seon (event scripts, plugins, etc.) have access to these environment variables. The environment variable "Seon_CFGFILE" points to the absolute path to the Seon main configuration file. This has two effects:

  • you may start Seon programs in a shell where this variable is set without using the parameter "-C" for all binaries (because the environment variable points to the correct position of the configfile)
  • all subsequent processes started by Seon (like event scripts) don't have to bother about the given configfile (like plugins of Seon Enterprise).

Database performance benchmarking

Available in Seon 3 Core, an environment variable can be set to log all database access timing information into that given file:

Seon_DB_BENCHMARKLOG

You can set this variable to an absolute filename where Seon logs all innformation (example: "ksh" or "bash"):

export Seon_DB_BENCHMARKLOG=/tmp/db2perf.log

This file logs the connect and query time for every single database access, resulting in a fast growing file. The content if this file looks like this (using DB2 database abstraction layer, others like MySQL start with "MySQL"):

DB2 connect: 0.052482 seconds
DB2 SQL query: 0.126631 seconds
DB2 connect: 0.032447 seconds
DB2 SQL query: 0.004983 seconds
DB2 connect: 0.029555 seconds
DB2 SQL query: 0.004500 seconds
DB2 connect: 0.031012 seconds
DB2 SQL query: 0.001324 seconds