LogFile (LOG) connection parameter

{ LogFile | LOG }=filename

Anywhere

filename This string specifies the name of the file where client error messages and debugging messages are saved. If the file name does not include a path, it is relative to the current working directory of the client application.

No log file.

The LogFile (LOG) connection parameter is connection-specific, so from a single application you can set different LogFile arguments for different connections.

Typical log file contents are as follows:

Tue Jan 22 2013 10:59:3
10:59:31 Attempting to connect using:
UID=DBA;PWD=********;DBF='C:\Users\Public\Documents\SQL Anywhere 16\Samples\demo.db';ServerName=demo16;START='C:\Program Files\SQL Anywhere 16\Bin32\dbeng16.exe';CON=SQL_DBC_10b9d400;ASTOP=YES;LOG=c:\logs\test.txt
10:59:31 Attempting to connect to a running server...
10:59:31 Attempting SharedMemory connection (no sasrv.ini cached address)
10:59:31 Connected to server over SharedMemory
10:59:31 Connected to SQL Anywhere Server version 16.0.0.1403
10:59:31 Application information:
10:59:31 IP=192.138.151.100;HOST=MyComputer1-PC;OSUSER=user1;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:\Program Files\SQL Anywhere 16\bin32\dbisql.exe';PID=0x145c;THREAD=0x508;VERSION=16.0.0.1403;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300
10:59:31 Connected to the server, attempting to connect to a running database...
10:59:31 [  205] Connected to database successfully
10:59:31 [  205] The number of prefetch rows has been reduced to 16 due to the prefetch buffer
10:59:31 [  205] limit. Increasing the PrefetchBuffer connection parameter may improve performance.

The following command line starts Interactive SQL, and connects to the sample database with a LogFile (LOG) connection parameter:

dbisql -c "DSN=SQL Anywhere 16 Demo;LOG=c:\logs\test.txt"

LogFile (LOG) connection parameter

Syntax

Usage

Allowed values

Default

Remarks

See also

Example