Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 2 Process Sentinels : process_event_log

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
INTEGER NOT NULL,
logical_process_name VARCHAR(10) NOT NULL,
logical_process_instance INTEGER NOT NULL,
process_id INTEGER NOT NULL,
process_status INTEGER NOT NULL,
process_status_comment VARCHAR(255) NULL,
timestamp TIMESTAMP NOT NULL)
Note: See "Administering iProcess Engine Server Processe" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
3000 - process instance started.
3001 - process instance stopping.
3002 - process instance stopped.
3003 - process instance died.
3004 - process instance paused.
3005 - process instance unpaused.
Description of the process_status entry, as reported to the Process Sentinels by the process.
Primary Key
None.
Foreign Keys
None.
Indexes
None.
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.
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 © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.