Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# port_range

The `port_range` table contains the firewall data about individual port/RPC numbers that lie within port range configurations defined on this iProcess Engine.

## Structure

The `port_range` table has the following structure:

    TABLE port_range (
    	port_range_id			NUMERIC(10)	NOT NULL,
    	slot_number			NUMERIC(10)	NOT NULL,
    	rpc_number			NUMERIC(10)	NOT NULL,
    	port_number			NUMERIC(10)	NOT NULL,
    	status				NUMERIC(10)	NOT NULL,
    	logical_machine_id		NUMERIC(10)	NULL,
    	logical_process_name		VARCHAR(10)	NULL,
    	logical_process_instance	NUMERIC(10)	NULL)

Column | Description
`port_range_id` | Unique ID of the port range configuration that this port/RPC number belongs to, as defined in the port_range_conf table.
`slot_number` | Internal slot in memory used by this port/RPC number.
`rpc_number` | RPC number.
`port_number` | Port number.
`status` | Defines whether this port/RPC number is available or in use by a process. One of the following values:
| • | `-2` Reserved for future use.
| • | `-1` Unobtainable. (A process tried to use the port but found that it was already in use.)
| • | `0` Unallocated.
| • | `1` Allocated to the process defined by the `logical_machine_id`, `logical_process_name` and `logical_process_instance` columns.
`logical_machine_id` | Either:
| • | ID of the server where the process instance that this port/RPC number has been allocated to runs, as defined in the node_cluster table.
| • | `0`, if the port/RPC number has not been allocated to a process.
`logical_process_name` | Logical name of the process instance that this port/RPC number has been allocated to.
`logical_process_instance` | Unique ID of the process instance that this port/RPC number has been allocated to.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_port_range` | `port_range_id`, `slot_number`

## Foreign Keys

The following foreign key is defined for this table.

Key Name | Column(s) | Referenced in Table...
`fk_port_range` | `port_range_id` | port_range_conf

## Indexes

None.

## Table Activity

The `port_range` table contains one row per port/RPC number used by the iProcess Engine (if you are using iProcess on a network with a firewall and using port range filtering or RPC filtering).

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

A row is... | When...
added | a user defines a new port range configuration, that is, a new record in the port_range_conf table, or modifies the range of an existing port range configuration, using the `SWDIR``\util\swadm` utility.
updated | a process is assigned a slot, or frees up a slot.
deleted | a user deletes a port range configuration, that is, a record in the port_range_conf table, using the `SWDIR``\util\swadm` utility.

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