iAnywhere.com - LogFile connection parameter [LOG]

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Connection Parameters and Network Protocol Options » Connection parameters

LogFile connection parameter [LOG]

Sends client error messages and debugging messages to a file.

Usage

Anywhere

Values

String

Default

No log file.

Remarks

If you want to save client error messages and debugging messages in a file, use the LogFile (LOG) connection parameter.

If the file name does not include a path, it is relative to the current working directory of the client application.

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 Aug 28 2006 12:29:46
12:29:46 Attempting to connect using:
UID=DBA;PWD=********;DBF='C:\Documents and Settings\All Users\Documents\SQL Anywhere 10\Samples\demo.db';
ENG=demo10;START='C:\Program Files\SQL Anywhere 10\win32\dbeng10.exe';CON='Sybase Central 1';
ASTOP=YES;LOG=c:\mylog.txt
12:29:46 Attempting to connect to a running server...
12:29:46 Trying to start SharedMemory link ...

12:29:46 SharedMemory link started successfully

12:29:46 Attempting SharedMemory connection (no sasrv.ini cached address)

12:29:46 Failed to connect over SharedMemory

12:29:46 No server found, attempting to run START line...
12:29:47 Autostarted server, attempting to connect using:
UID=DBA;PWD=********;DBF='C:\Documents and Settings\All Users\Documents\SQL Anywhere 10\Samples\demo.db';
ENG=demo10;START='C:\Program Files\SQL Anywhere 10\win32\dbeng10.exe';CON='Sybase Central 1';ASTOP=YES
12:29:47 Attempting SharedMemory connection (no sasrv.ini cached address)

12:29:47 Connected to server over SharedMemory

12:29:47 Connected to SQL Anywhere Server version 10.0.0.2456
12:29:47 Application information:
12:29:47 IP=10.25.99.227;HOST=mymachine-XP;OS='Windows XP Build 2600 Service Pack 2';PID=0x21c;
THREAD=0xa38;EXE='C:\Program Files\SQL Anywhere 10\Sybase Central 5.0.0\win32\scjview.exe';
VERSION=10.0.0.2456;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-240
12:29:47 Connected to the server, attempting to connect to a running database...
12:29:48 [    1] Connected to database successfully
12:29:53 [    1] The number of prefetch rows has been reduced to 168 due to the prefetch buffer
12:29:53 [    1] limit. Consider using the PrefetchBuffer connection parameter.

Example

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