HP Neoview Release 2.4 Software User Manual

Page 54

Advertising
background image

Table 3-10 EVENTS_VW1 Field Definitions (continued)

Description

Data Type

Field Name

Primary Key

A sequence number used to
differentiate between two
events that have identical LOG
and GENERATED timestamps.

INTEGER UNSIGNED

SEQ_NUMBER

Timestamp, in Coordinated
Universal Time, indicating
when the event was recorded
in the EMS log.

TIMESTAMP(6)

LOG_TIMESTAMP_UTC

Timestamp, in Local Civil Time,
indicating when the event was
generated.

TIMESTAMP(6)

GENERATED_TIMESTAMP_LCT

Number assigned to the event
by the subsystem that logged it
to EMS. NOTE: A different
subsystem can use the same
number for an event that occurs
within that subsystem.

INTEGER

EVENT_NUMBER

Subsystem ID of the subsystem
that generated the event. This
column always uses the
ISO88591 character set.

CHAR(20)

SSID

segment_name

of the process

that generated the event. This
column always uses the
ISO88591 character set.

TIP:

Use this column to select

or group events by segment.

CHAR(8)

PROCESS_SEGMENT

segment_name,process_name
of the process that generated
the event. This column always
uses the ISO88591 character set.

CHAR(20)

PROCESS_ID

Instance number of the process
that generated the event.

INTEGER UNSIGNED

PROCESS_ID_INSTANCE

Processing node number of the
process that generated the
event.

INTEGER UNSIGNED

NODE_ID

Process identification number
of the process that generated
the event.

INTEGER UNSIGNED

PIN

Segment number of the process
that generated the event. For
example, 1 for segment
\NEO0101 or 3 for segment
\NEO0103.

INTEGER UNSIGNED

SEGMENT_ID

Reserved for future expansion

Reserved for future expansion

START_ENTRY_ID

Reserved for future expansion

Reserved for future expansion

START_ENTRY_ID

SQL error code. Null if event is
not SQL-related.

INTEGER, nullable

SQLCD

54

Repository Views

Advertising