Difference between revisions of "SET SYSLOGGING"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET SYSLOGGING=
 
 
 
==Class==
 
Environment
 
 
 
 
==Purpose==
 
==Purpose==
 
Enable or disable internal system logging
 
Enable or disable internal system logging
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
ERROR(), MESSAGE(), DB_LOGDIR
+
[[DB_LOGDIR]], [[Configuration Files]], [[ERROR()]], [[MESSAGE()]], [[SYSLOGGING|SYSLOGGING System Table]]
  
  
 
==Description==
 
==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. The format of the log file is as follows:
+
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.
 
+
{|
+
|Column Number||Description
+
|-
+
|One||Process ID of the user writing the line to the log file
+
|-
+
|Two||Date line was written
+
|-
+
|Three||Time line was written
+
|-
+
|Four||Internal file name
+
|-
+
|Five||Internal line number
+
|-
+
|Six||Operating system error number
+
|-
+
|Seven||General description
+
|-
+
|}
+
  
 
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.
 
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.
 
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|SYSLOGGING System Table]].
  
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
set syslogging on</pre>
+
set syslogging on
 +
...
 +
SELECT * FROM syslogging
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 +
[[Category:Documentation]]
 +
[[Category:Commands]]
 +
[[Category:Set_Commands|SYSLOGGING]]
 +
[[Category:Error Handling and Debugging]]
 +
[[Category:Error Handling and Debugging Set Commands]]

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