ECN-XD109 AcuXDBC dynamic logging

For JDBC data sources, if you did not enable transaction logging during the initial setup, you can now enable it dynamically when connecting to the data source each time.

You can now append the required GENESIS variables to your connection string to enable logging for that connection only; for example, the following string sets full logging:

jdbc://uid/pwd/xvision:acuxdbc.cfg@20222:machinename!acuxdbc04,GENESIS_LOGFILE=/path/to/logfile.log,GENESIS_LOGOPTS=3

Configuration file:

To extend this dynamic logging further, a new configuration file, vortex.properties, is available, which is used if it is in the same directory as vortex.jar.

# VORTEXJava logging
# logfile is the name of the logfile, e.g. /tmp/logfile
#logfile=/tmp/logfile
# logopts is a list of options, separated by + (optional)
#logopts=FULL+MULTI+TIME
#
# VORTEXjdbc connection commands:
# These are sent to the target after the connection succeeds.
# A maximum of 20 statements are sent and they must be consecutively numbered
# without gaps.
#
#jdbcsql0=set option logfile '/tmp/test_c3po.log'
#jdbcsql1=set option plan on
#
# VORTEX network parameters
# connect_timeout - seconds to wait on a connect
#connect_timeout=15
# read_timeout - seconds to wait on a read response
#read_timeout=1440
# key_connect - integer key to use for uid/pwd obfuscation. Must match the
#               -kn vtxnetd option value.
#key_connect=1999
#environment_variables=VORTEX_HOST_LOGFILE=/tmp/test,VORTEX_HOST_LOGOPTS=FULL

Uncomment (and edit, where required) the options in the configuration file; for example, to enable full logging:

logfile=/tmp/logfile
logopts=FULL

The valid logopts keywords are:

FULL

Verbose output

MULTI

Append a time-stamp to the logfile name

TIME

Inserts time-stamps in the logfile.

You can specify more than one option, separated by +; the order in which you specify each option is not important.

The VORTEXjdbc commands are typically set option commands; no query statements are allowed here. The statements are sent immediately after the connection is made.

The Vortex network parameters affect the network connection.

The environment_variables value is appended to the connection string to make it easier to manage server-side logging.