Difference between revisions of "OS4X Core environment variables"

From OS4X
Jump to navigation Jump to search
Line 20: Line 20:
 
*you may start OS4X programs in a shell where this variable is set without using the parameter "<code>-C</code>" for all binaries (because the environment variable points to the correct position of the configfile)  
 
*you may start OS4X programs in a shell where this variable is set without using the parameter "<code>-C</code>" for all binaries (because the environment variable points to the correct position of the configfile)  
 
*all subsequent processes started by OS4X (like event scripts) don't have to bother about the given configfile (like plugins of OS4X Enterprise).
 
*all subsequent processes started by OS4X (like event scripts) don't have to bother about the given configfile (like plugins of OS4X Enterprise).
 +
 +
== Database performance benchmarking ==
 +
Available in OS4X 3 Core, an environment variable can be set to log all database access timing information into that given file:
 +
OS4X_DB_BENCHMARKLOG
 +
You can set this variable to an absolute filename where OS4X logs all innformation (example: "ksh" or "bash"):
 +
export OS4X_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:
 +
<pre>
 +
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
 +
</pre>

Revision as of 08:02, 30 April 2010

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

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

  • you may start OS4X 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 OS4X (like event scripts) don't have to bother about the given configfile (like plugins of OS4X Enterprise).

Database performance benchmarking

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

OS4X_DB_BENCHMARKLOG

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

export OS4X_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:

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