Difference between revisions of "SYSLOGGING"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Provides System Logging information. 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. | Provides System Logging information. 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. | ||
| Line 57: | Line 50: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:System Tables]] | [[Category:System Tables]] | ||
Revision as of 11:57, 17 November 2009
Contents
Purpose
Provides System Logging information. 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.
See Also
DATA TYPES, SELECT, SYSTEM TABLES
Description
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
| Column | Data Type | Width | Description |
|---|---|---|---|
| LEVEL | N | 1 | Logging level: 0-FATAL, 1-ERROR, 2-WARNING, 3-INFORMATION, 4-LOGON/LOGOFF |
| PID | N | 8 | Process ID |
| USER_NAME | C | 30 | User name |
| DATE | D | 4 | Date logged |
| TIME | C | 8 | Time logged |
| FILE_NAME | C | 10 | Internal |
| LINE_NUMBER | N | 6 | Internal |
| OS_ERROR_NUMBER | N | 4 | OS error number |
| PRODUCT_NAME | C | 28 | Name of logging product |
| PATCH_LEVEL | C | 30 | Patch level of logging product |
| COMPILE_DATETIME | C | 20 | Compile date of logging product |
| MESSAGE | C | 100 | Textual information |
Example
EXEC SQL SELECT user_name, level FROM syslogging;
Products
Recital, Recital Server
