SYSLOGGING
From Recital Documentation Wiki
Revision as of 12:11, 13 March 2009 by Yvonnemilne (Talk | contribs)
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
