VORTEX_HOST_LOGFILE

SQL OpenNet log file

The VORTEX_HOST_LOGFILE environment variable turns on logging and specifies the path and name of the log file used to log statements passed to SQL OpenNet from the xfODBC driver and SQL Connection.

Value

The path and name of the Vortex host log file you want to produce. You do not need to specify a filename extension.

Discussion

VORTEX_HOST_LOGFILE specifies the file that logs calls and errors generated through SQL OpenNet server. You can use it to determine the driver API calls made between the driver client and the OpenNet server.

Vortex host logging applies only to a client/server configuration. You can use Vortex host logs only with vtxnet2. Vtxnetd (on Windows) does not support the VORTEX_HOST_LOGFILE environment variable.

Use the VORTEX_HOST_LOGOPTS environment variable to set options for the log file. 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:

On Windows, the opennet.srv file before starting vtxnet2.
On UNIX, the environment before starting vtxnetd.
On OpenVMS, a system-wide logical before starting the server program.

Used by

xfODBC, SQL Connection