Copyright © Cloud Software Group, Inc. All Rights Reserved

process_event_log

The process_event_log table logs all changes in the status of server process instances.

Structure

The process_event_log table has the following structure:

TABLE process_event_log (
logical_machine_id number(5) NOT NULL,
logical_process_name varchar2(10) NOT NULL,
logical_process_instance number(5) NOT NULL,
process_id number(10) NOT NULL,
process_status number(5) NOT NULL,
process_status_comment varchar2(255) NULL,
timestamp date NOT NULL)

Column	Description
logical_machine_id	ID of the server where the process instance that this event applies to is running, as defined in the node_cluster table.
logical_process_name	Logical name of the process that this event applies to. Note: See "Administering iProcess Engine Server Processe" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
logical_process_ instance	ID of the process instance that this event applies to, as defined in the process_config table.
process_id	Process ID (PID) of the process instance that this event applies to.
process_status	Status change event that occurred for the specified process instance. One of the following: • 3000 - process instance started. • 3001 - process instance stopping. • 3002 - process instance stopped. • 3003 - process instance died. • 3004 - process instance paused. • 3005 - process instance unpaused.
process_status_comment	Description of the process_status entry, as reported to the Process Sentinels by the process.
timestamp	Date and time that this event occurred.

Primary Key

None.

Foreign Keys

None.

Indexes

None.

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	MEDIUMTABLESIZE
Percentage Increase	MEDIUMTABLEPCTINCREASE
Tablespace	MEDIUMTABLESPACE

Table Activity

The process_event_log table contains one row for each status change event that has occurred to each instance of a server process.

Rows are added, updated and deleted in the following situations.

A row is...	When...
added	a process starts, receives a shutdown command, or shuts down.
updated	never.
deleted	never. Note: Because rows are never deleted automatically, TIBCO recommend that you regularly monitor the size of this table and delete or archive rows manually if you need to.

Copyright © Cloud Software Group, Inc. All Rights Reserved