VORTEX_HOST_LOGOPTS

SQL OpenNet log options

WSupported on Windows
USupported on Unix
VSupported on OpenVMS
NSupported in Synergy .NET

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

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

APPEND

Append logging information to existing file.

ERROR

Log only statements with errors.

FULL

Perform full logging. If your program opens multiple database channels concurrently, MULTI must also be set (or you’ll get an error).

MULTI

Create a separate file for each channel when using multiple database channels. Set automatically when running vtxnetd on Windows.

PLAY

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

RECORD

Log data for support.

SQL

Create a file that contains SQL commands. Specify the filename (minus extension) and path (optional) with VORTEX_HOST_LOGFILE. The extension is .sql.

TIME

Log execution time for statements.

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.

The server, as follows:

xfODBC, SQL Connection

To record a full operation log and CPU time,

VORTEX_HOST_LOGOPTS=FULL+TIME