Document toolboxDocument toolbox

14.1 sp415_assigned_ports_audit

This table is the audit table for sp414_assigned_ports. 

Housekeeping

This table is tidied by sp_dbtidy's Audit group


 

Table Definition

Field
Type
Default
Nullable
component_nonumber (error)
sequence_nonumber (error)
timestampdate (error)
user_idvarchar2(20) (tick)
port_typenumber (error)
old_portnumber (tick)
new_portnumber (tick)
old_addressvarchar2(50) (tick)
new_addressvarchar2(50) (tick)
old_listener_countnumber (tick)
new_listener_countnumber (tick)

Keys

None.

 

Column Descriptions

FieldDescription
component_no Component identifier.
sequence_noUnique identifier: the sequence number of the update. 
timestampDate and time at which these details were saved. Uses the time zone of the DBMS server machine.
user_idNot used.
port_typeThe sort of port this row is to configure. Different options are valid for each type of component. 
old_port Old port number for the specified port type.
new_portNew port number for the specified port type.
old_address Old address (IP or hostname) for the port.
new_addressNew address (IP or hostname) for the port.
old_listener_countOld number of threads to listen on this port.
new_listener_countNew number of threads to listen on this port.