Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# running_processes

The `running_processes` table stores information about each process instance that is currently running on the system.

## Structure

The `running_processes` table has the following structure:

    TABLE running_processes (
    	logical_machine_id	 INTEGER	        NOT NULL,
    	logical_process_name	 VARCHAR(10)		NOT NULL,
    	logical_process_instance INTEGER		NOT NULL,
    	process_id		 INTEGER		NOT NULL,
    	port_number	 	 INTEGER	        NOT NULL)

Column | Description
`logical_machine_id` | ID of the server where this process instance is running, as defined in the node_cluster table.
`logical_process_name` | Logical name of this process instance. Note: See "Administering iProcess Engine Server Processes" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
`logical_process_instance` | ID of this process instance, as defined in the process_config table.
`process_id` | Process ID (PID) of this process instance.
`port_number` | Port number that this process instance is running on.

## Primary Key

None.

## Triggers

None.

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed
`idx_running_processes_fk` | `logical_machine_id logical_process_name logical_process_instance`

## Table Activity

The `running_processes` table contains one row for each instance of an iProcess Engine server process that is currently running on the system.

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

A row is... | When...
added | a new process instance is started.
updated | a process instance is restarted (`process_id` and `port_number` are updated).
deleted | a process instance is stopped.

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