VORTEX_HOST_LOGOPTS

SQL OpenNet log options

WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows
USupported on UNIX
VSupported on OpenVMS

The VORTEX_HOST_LOGOPTS environment variable specifies options for the file determined by VORTEX_HOST_LOGFILE.

Value

One or more of the following, separated by a plus sign (+):

FULL

Perform full logging.

ERROR

Log only statements with errors.

TIME

Log execution time for statements.

RECORD

Log data for support.

PLAY

Set an option that enables Synergy/DE Developer Support to play back an operation.

Discussion

Vortex host logging applies only to a client/server configuration.

Use the VORTEX_HOST_LOGFILE environment variable to specify the name and location of the log file that is generated. If you set VORTEX_HOST_LOGFILE without setting VORTEX_HOST_LOGOPTS, the log file includes a list of all operations along with a total count for each operation.

Once you have successfully logged the error, turn logging off by unsetting the VORTEX_HOST_LOGFILE and VORTEX_HOST_LOGOPTS environment variables (and reboot if necessary). Logging slows performance, and the log files can quickly fill your disk.

Setting location

The server, as follows:

Used by

xfODBC, SQL Connection.

See also

Examples

To record a full operation log and CPU time,

VORTEX_HOST_LOGOPTS=FULL+TIME