Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# 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_idnumber(5)NOT NULL,logical_process_namevarchar2(10)NOT NULL,logical_process_instancenumber(5)NOT NULL,enablednumber(1)NOT NULL,persistentnumber(1)NOT NULL,last_known_statusvarchar2(20)NOT NULL,status_commentvarchar2(255)NULL)

Column | Description
`logical_machine_id` | ID of the server where this process instance runs, as defined in the node_cluster table.
`logical_process_name` | Logical name of this process instance. Note: For a list of logical process names, see the "Administering iProcess Engine Server Processes" topic in TIBCO iProcess Engine Administrator's Guide.
`logical_process_instance` | Unique ID for this process instance.
`enabled` | Flag that defines whether this process instance starts automatically (`1`) when the iProcess Engine starts, or whether it must be started manually (`0`).
`persistent` | 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.
`last_known_status` | Last known status of this process instance, as reported to the Process Sentinels by the process. 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.
`status_comment` | 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.

Key Name | Column(s) | Index Tablespace
`pk_process_config` | `logical_machine_id logical_process_name logical_process_instance` | SMALLINDEXSPACE

## Foreign Keys

The following foreign key is defined for this table.

Key Name | Column(s) | Referenced in Table...
`fk_process_config` `1 This key enforces the DELETE CASCADE referential action.` | `logical_machine_id` | node_cluster

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed | Tablespace
`idx_process_config_fk` | `logical_machine_id` | SMALLINDEXSPACE

## Storage

The following STORAGE values are defined for this table.

Value | Definition
Initial | SMALLTABLESIZE
Percentage Increase | SMALLTABLEPCTINCREASE
Tablespace | SMALLTABLESPACE

## 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 row is... | When...
added | a new process instance is added, either at installation or by using the `SWDIR``\util\swadm`, `SWDIR``\util\swsvrmgr` utilities.
updated | a process instance’s settings or status are updated, either by system activity, or by using the `SWDIR``\util\swadm` or `SWDIR``\util\swsvrmgr` utilities.
deleted | a process instance is deleted, either at installation or by using the `SWDIR``\util\swadm` or `SWDIR``\util\swsvrmgr` utilities.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine