Document toolboxDocument toolbox

sp408_monitor_audit

Owned by Jason Andrew
Oct 02, 2024

This table contains the history of changes to sp406_monitors, showing the before and after state for any transaction.

Housekeeping

This table is tidied by sp_dbtidy's Audit group.

 

Table Definition

Field
Type
Default
Nullable
sequence_nonumber (error)
timestampdate (error)
old_component_nonumber (tick)
old_heartbeat_portnumber (tick)
old_heartbeat_addressvarchar2(50) (tick)
old_PCI_portnumber (tick)
old_PCI_addressvarchar2(50) (tick)
old_pidnumber (tick)
old_monitor_statenumber (tick)
new_component_nonumber (tick)
new_heartbeat_portnumber (tick)
new_heartbeat_addressvarchar2(50) (tick)
new_PCI_portnumber (tick)
new_PCI_addressvarchar2(50) (tick)
new_pidnumber (tick)
new_monitor_statenumber (tick)

Keys

None.

Column Descriptions

FieldDescription
sequence_no For ordering queries- several events may happen at the same time.
timestamp Time at which the change happened (Uses the time zone of the DBMS server machine).
old_component_noOld value for component identifier.
old heartbeat_portOld value for port number for the monitor to listen for heartbeats on.
old_heartbeat_addressOld value for address (IP or hostname) for the port for the monitor to listen for heartbeats on.
old_PCI_portOld value for the port number for the monitor to listen for Process Control commands on.
old_PCI_address Old value for address (IP or hostname) for the port for the monitor to listen for Process Control commands on.
old_pid Old value for monitor process id.
old_monitor_state Old value for monitor state.
new_component_noNew value for component identifier.
new_heartbeat_portNew value for port number for the monitor to listen for heartbeats on.
new_heartbeat_address New value for address (IP or hostname) for the port for the monitor to listen for heartbeats on.
new_PCI_portNew value for the port number for the monitor to listen for Process Control commands on.
new_PCI_addressNew value for address (IP or hostname) for the port for the monitor to listen for Process Control commands on.
new_pidNew value for monitor process id.
new_monitor_stateNew value for monitor state.