14.1 sp414_assigned_ports

This table is similar to sp409_component_ports. However, no columns are nullable and refer to the actual ports currently in use by the specified component. In particular, if a port is randomly selected, then the actual port used is populated in port_no rather than 0 or null.

Although primarily updated by individual components, system monitor may clear the entries for a component if this component has closed prematurely without tidying up its entries of this table. When system monitor is run with the -c flag, this table will be truncated.

Table Definition

Field	Type	Default	Nullable
component_no
port_type	number
port_no	number
port_address	varchar2(50)
listener_count	number

Keys

unique (component_no, port_type)
foreign key (component_no) references 14.1 sp400_components(component_no)
foreign key (port_type) references 14.1 sp411_component_port_types(type_no)

Column Descriptions

Field	Description
component_no	Component identifier.
port_type	The sort of port this row is to configure. Different options are valid for each type of component.
port_no	Port number for the specified port type.
port_address	Address (IP or hostname) for the port.
listener_count	Number of threads to listen on this port.