ASA Database Administration Guide
  Connection and Communication Parameters
    Connection parameters

Logfile connection parameter [LOG]

Function 

To send client error messages and debugging messages to a file.

Usage 

Anywhere

Values 

String

Default 

No log file

Description 

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

If the file name includes 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.

Example 

The following command line starts Interactive SQL connecting to the ASA 9.0 Sample data source with a LogFile (LOG) connection parameter:

dbisql -c "DSN=ASA 9.0 Sample;LOG=d:\logs\test.txt"

Typical log file contents are as follows:

Fri Oct 27 2000 11:45
Application information:
"HOST=NAME-PC;OS=Windows NT 4.0 (Service Pack 5);PID=0x14b;THREAD=0x148;EXE=C:\ASA90\WIN32\DBPING.EXE;VERSION=9.0.0.1271;API=DBLIB;TIMEZONEADJUSTMENT=-300"
Attempting to connect using:
UID=dba;PWD=***;ENG=name;DBG=YES;LOG=c:\temp\cli.out;LINKS=shmem,tcpip
Attempting to connect to a running server...
Trying to start SharedMemory link ...
    SharedMemory link started successfully
Attempting SharedMemory connection (no asasrv.ini cached address)
Failed to connect over SharedMemory
Trying to start TCPIP link ...
Loading wsock32.dll
Loading ws2_32.dll
TCP using Winsock version 2.0
My IP address is 172.31.142.196
My IP address is 127.0.0.1
    TCPIP link started successfully
Attempting TCPIP connection (address 172.31.143.196:2638 found in asasrv.ini cache)
Trying to find server at cached address 172.31.143.196:2638 without broadcasting
    Server not found (no reply received)
Looking for server with name NAME
I am in a class B network
Sending broadcast to find server
Using broadcast address of: 172.31.255.255:2638
I am in a class A network
Sending broadcast to find server
Using broadcast address of: 127.255.255.255:2638
Found database server at address 172.31.142.196:2638
Found database server NAME on TCPIP link
Connected to server over TCPIP at address 172.31.142.196:2638
Writing server address 172.31.142.196:2638 to asasrv.ini cache
   Liveness timeout 120, liveness retransmit period 30
Connected to the server, attempting to connect to a running database...
Connected to database successfully