Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# port_range_active

The `port_range_active` table lists what port/RPC numbers are being actively used to provide RPC services by iProcess Engine processes.

Note | The table only lists processes that provide RPC services. These processes are RPC_TCP_LI, RPC_UDP_LI, RPC_POOL, RPC_SWIP, WQS and WIS.

## Structure

The `port_range_active` table has the following structure:

    TABLE port_range_active (
    	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,
    	rpc_number			INTEGER		NOT 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: See "Administering iProcess Engine Server Processes" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
`logical_process_instance` | Unique ID for this process instance.
`process_id` | Operating system process ID of this process instance.
`port_number` | Port number being used by this process instance.
`rpc_number` | RPC number being used by this process instance.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_port_range_active` | `logical_machine_id`, `logical_process_name`, `logical_process_instance`

## Triggers

None.

## Indexes

None.

## Table Activity

The `port_range_active` table contains one row per port/RPC number that is being actively used by the iProcess Engine.

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

A row is... | When...
added | an iProcess Engine process allocates itself a port/RPC number from either the port_range table or the operating system.
updated | never.
deleted | an iProcess Engine process stops using its assigned port/RPC number, that is, is shut down.

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