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 Jun 08 2010 13:39:12
13:39:12 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_48055888;ASTOP=YES;LOG=c:\logs\t
13:39:12 Attempting to connect to a running server...
13:39:12 Trying to start SharedMemory link ...
13:39:12     SharedMemory link started successfully
13:39:12 Attempting SharedMemory connection (no sasrv.ini cached address)
13:39:12 Connected to server over SharedMemory
13:39:12 Connected to SQL Anywhere Server version 12.0.0.2413
13:39:12 Application information:
13:39:13 IP=10.25.99.117;HOST=DCHAMPAG-D630;OSUSER=user1;OS='Windows XP Build 2600 Service Pack 3';
EXE='C:\Program Files\SQL Anywhere 12\bin32\dbisql.exe';PID=0x112c;THREAD=0x16fc;VERSION=12.0.0.2413;
API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-240
13:39:13 Connected to the server, attempting to connect to a running database...
13:39:14 [    3] Connected to database successfully
13:39:15 [    3] The number of prefetch rows has been reduced to 16 due to the prefetch buffer
13:39:15 [    3] limit. Increasing the PrefetchBuffer connection parameter may improve performance.
13:39:29 [    3] Disconnected from server

The following command line starts Interactive SQL, connecting 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