Progress
DataServer
for ORACLE Guide


Accessing the DataServer Log

Progress supports a log file named dataserv.lg that is dedicated to tracking information related to DataServers. Information about the processes for all DataServers is located in this single file. The log file provides a useful record of connection and disconnection processes and error messages that you can use to diagnose problems or failures. In addition, for Windows clients, it has information about the ORACLE DLL. For each process, the log provides the process identification number, physical database name, database type, user ID, and a message about the process’ status. Here is an excerpt from a sample DataServer log file:

    Fri May 15 11:40:33 1997
11:40:33  (pid 2361) ORACLE SERVER db: t user: odemo
      Remote ORACLE Server begin. (message number)
11:40:33  (pid 2361) ORACLE SERVER db: t user: odemo
      Login to db as user odemo. (message number) 

The query-tuning DEBUG option causes the DataServer to write information about the SQL that it generates to the dataserv.lg file as well.

To have access to the DataServer log file, follow these steps on the host machine:

  1. Before starting up the broker, set the DSLOGDIR environment variable or logical to the name of the directory where you want to place the log file.
  2. If you don’t set the environment variable, Progress writes the information to the dataserv.lg file in the process’s current directory. If Progress cannot open this file, it writes the information to the ds_<process-id>.lg file in the process’ current directory, and you will have one file per process.

  3. Open the dataserv.lg file to read the DataServer log.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095