SYSLOGGING

From Recital Documentation Wiki
Revision as of 12:11, 13 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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