Difference between revisions of "SET SYSLOGGING"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
==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]], [[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. | + | 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. | 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== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | set syslogging on</code> | + | set syslogging on |
+ | ... | ||
+ | SELECT * FROM syslogging | ||
+ | </code> | ||
==Products== | ==Products== | ||
− | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|SYSLOGGING]] | [[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