Difference between revisions of "SYSLOGGING"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 21: | Line 21: | ||
!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 | ||
Revision as of 12:12, 13 March 2009
SYSLOGGING
Class
SQL Applications
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 Database Server, Recital Mirage Server, Recital Terminal Developer
