Sends client error messages and debugging messages to a file.
Anywhere
String
No log file.
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 11\Samples\demo.db';ENG=demo11;START='C:\Program Files\
SQL Anywhere 11\bin32\dbeng11.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 11\Samples\demo.db';ENG=demo11;START='C:\Program Files\
SQL Anywhere 11\bin32\dbeng11.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 11.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 11\bin32\scjview.exe';VERSION=11.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. |
The following command line starts Interactive SQL, connecting to the sample database with a LogFile (LOG) connection parameter:
dbisql -c "DSN=SQL Anywhere 11 Demo;LOG=d:\logs\test.txt" |
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |