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:

Mon Jan 17 2011 08:17:56
08:17:56 Attempting to connect using:
UID=DBA;PWD=********;DBF='C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples\demo.db';ServerName=demo12;START='C:\Program Files\SQL Anywhere 12\Bin32\dbeng12.exe';CON=SQL_DBC_47d853e8;ASTOP=YES;LOG=c:\logs\t
08:17:56 Attempting to connect to a running server...
08:17:56 Trying to start SharedMemory link ...
08:17:56     SharedMemory link started successfully
08:17:56 Attempting SharedMemory connection (no sasrv.ini cached address)
08:17:56 Connected to server over SharedMemory
08:17:56 Connected to SQL Anywhere Server version 12.0.1.3149
08:17:56 Application information:
08:17:56 IP=10.7.169.107;HOST=MCBRIDEM-PC;OSUSER=user1;OS='Windows XP Build 2600 Service Pack 2';EXE='C:\Program Files\SQL Anywhere 12\bin32\dbisql.exe';PID=0xa4c;THREAD=0x1430;VERSION=12.0.1.3149;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-480
08:17:56 Connected to the server, attempting to connect to a running database...
08:17:56 [    2] Connected to database successfully
08:17:57 [    2] The number of prefetch rows has been reduced to 16 due to the prefetch buffer
08:17:57 [    2] 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 12 Demo;LOG=c:\logs\test.txt"

LogFile (LOG) connection parameter

Syntax

Usage

Allowed values

Default

Remarks

See also

Example