Difference between revisions of "SYSLOGGING"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (3 intermediate revisions by one user not shown) | |||
| 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 11: | Line 4: | ||
==See Also== | ==See Also== | ||
| − | [[DATA TYPES]], [[SQL SELECT|SELECT]], [[SYSTEM TABLES]] | + | [[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|SYSTEM TABLES]] |
| Line 21: | Line 14: | ||
!Column||Data Type||Width||Description | !Column||Data Type||Width||Description | ||
|- | |- | ||
| − | |LEVEL||N||1||Logging level: 0-FATAL, 1-ERROR, | + | |LEVEL||N||1||Logging level: 0-FATAL, 1-ERROR, 2-WARNING, 3-INFORMATION, 4-LOGON/LOGOFF |
| − | 2-WARNING, 3-INFORMATION, | + | |
| − | 4-LOGON/LOGOFF | + | |
|- | |- | ||
|PID||N||8||Process ID | |PID||N||8||Process ID | ||
| Line 52: | Line 43: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | SELECT user_name, level FROM syslogging | |
| − | SELECT user_name, level | + | |
| − | FROM syslogging | + | |
</code> | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:System Tables]] | [[Category:System Tables]] | ||
Latest revision as of 16:50, 22 December 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
SELECT user_name, level FROM syslogging
Products
Recital, Recital Server
