Difference between revisions of "SET SYSLOGGING"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 12: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[DB_LOGDIR]], [[Configuration Files]], [[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]]. | ||
| Line 47: | Line 28: | ||
<code lang="recital"> | <code lang="recital"> | ||
set syslogging on | set syslogging on | ||
| + | ... | ||
| + | EXEC SQL | ||
| + | SELECT * FROM syslogging; | ||
</code> | </code> | ||
Revision as of 15:49, 20 April 2009
Class
Environment
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 ... EXEC SQL SELECT * FROM syslogging;
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
