Copyright © Cloud Software Group, Inc. All rights reserved.

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.

Copyright © Cloud Software Group, Inc. All rights reserved.