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 Performance and Tuning: Monitoring Tables.

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

Columns

The columns for monErrorLog are:

Name

Datatype

Description

SPID

smallint

Session process identifier (spid)

InstanceID

int

(Cluster environments only) ID of an instance in a shared-disk cluster.

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. Adaptive Server versions 15.7 and later use a value of 99 to indicate stack traces; versions earlier than 15.7 use a value of 0.

State

int

State of error

Time

datetime

Timestamp when error occurred

ErrorMessage

varchar(512)

Text of the error message. Attribute is null.