monErrorLog

Description

Returns the most recent error messages from the Adaptive Server error log. Use errorlog pipe max messages to tune the maximum number of messages returned. See “Stateful historical monitoring tables”.

NoteEnable the enable monitoring, errorlog pipe active, and errorlog pipe max messages configuration parameters for this monitoring table to collect data.

Columns

Name

Datatype

Attributes

Description

SPID

smallint

Session process identifier (spid)

KPID

int

Kernel process identifier (kpid)

FamilyID

smallint

spid of the parent process

EngineNumber

smallint

Engine on which the process was running

ErrorNumber

int

Error message number

Severity

int

Severity of error

State

int

State of error

Time

datetime

Timestamp when error occurred

ErrorMessage

varchar(512)

Null

Text of the error message