Document toolboxDocument toolbox

sp402_component_states

This table contains the dynamic data associated with a Monitored Component i.e. the current state of the process being monitored, stored in a single row per Monitored Component. 

This data is updated every time a Monitored Component changes state, so it will always show the last known state of the process. It can be read by the monitor when it starts to determine if the system was shutdown completely before the monitor stopped, or whether the monitor is being restarted into a running system.


 

Table Definition

Field
Type
Default
Nullable
component_nonumber (error)
current_statusnumber (error)
current_process_idnumber (tick)
consecutive_startsnumber (tick)

Keys

primary key (component_no) 
foreign key (component_no) references sp400_components (component_no) 
foreign key (current_status) references sp404_component_status_decodes (state_no)

Column Descriptions

FieldDescription
component_noComponent identifier.
current_statusWhat the process is currently doing e.g. starting/initialising/stopping etc.
current_process_idPID of the process currently running for this component.
consecutive_startsNumber of times this process has been started without reaching the ready state.