Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 2 Process Sentinels : process_config

process_config
The process_config table stores information about each process instance that is defined on the system.
Multiple instances of each server process can be used to optimize iProcess Engine efficiency - for example, to increase the processing capability on one server, or to spread the processing load across multiple servers.
Structure
The process_config table has the following structure:
TABLE process_config(
logical_machine_id number(5) NOT NULL,
logical_process_name varchar2(10) NOT NULL,
logical_process_instance number(5) NOT NULL,
enabled number(1) NOT NULL,
persistent number(1) NOT NULL,
last_known_status varchar2(20) NOT NULL,
status_comment varchar2(255) NULL)
Note: See "Administering iProcess Engine Server Processes" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
Flag that defines whether this process instance starts automatically (1) when the iProcess Engine starts, or whether it must be started manually (0).
Flag that defines whether this process instance is automatically restarted (1) or not (0) when the iProcess Engine is shut down and restarted.
Note: Any row in which the persistent value is 0 is deleted when the iProcess Engine starts up.
Either: STARTING, RUNNING, PAUSED, SUSPENDED, SHUTTING DOWN or STOPPED.
Note: The process_event_log table provides an audit trail of changes to the status of a process instance.
Brief explanation of the last_known_status, as reported to the Process Sentinels by the process.
Primary Key
The following primary key is defined for this table.
Foreign Keys
The following foreign key is defined for this table.
Indexes
The following index is defined for this table.
Storage
The following STORAGE values are defined for this table.
Table Activity
The process_config table contains one row for each instance of each server process defined on the system.
Rows are added, updated and deleted in the following situations.
a new process instance is added, either at installation or by using the SWDIR\util\swadm, SWDIR\util\swsvrmgr utilities or the iProcess Server Manager.
a process instance’s settings or status are updated, either by system activity, or by using the SWDIR\util\swadm, SWDIR\util\swsvrmgr utilities or the iProcess Server Manager.
a process instance is deleted, either at installation or by using the SWDIR\util\swadm, SWDIR\util\swsvrmgr utilities or the iProcess Server Manager.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved