Difference between revisions of "SET SYSLOGGING"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 25: Line 25:
 
set syslogging on
 
set syslogging on
 
...
 
...
EXEC SQL
+
SELECT * FROM syslogging
  SELECT * FROM syslogging;
+
 
</code>
 
</code>
  

Latest revision as of 16:00, 5 July 2011

Purpose

Enable or disable internal system logging


Syntax

SET SYSLOGGING ON | OFF | (<expL>)


See Also

DB_LOGDIR, Configuration Files, ERROR(), MESSAGE(), SYSLOGGING System Table


Description

When SET SYSLOGGING is ON internal system logging is performed while the process is running. The information logged can be used to find performance problems or track down system errors.

All the logging information is written to a file called recital.log. If the environment variable DB_LOGDIR is not defined, then the log files are created in the root directory, otherwise the log files will be created in the specified directory.

This command allows the optional logical expression <expL> to be evaluated. If a value of .T. is returned, SYSLOGGING is set ON. If a value of .F. is returned, SYSLOGGING is set OFF. By default SYSLOGGING is OFF.

SYSLOGGING information can be accessed in table format via the SYSLOGGING System Table.


Example

set syslogging on
...
SELECT * FROM syslogging


Products

Recital Server, Recital