Document toolboxDocument toolbox

14.1 sp404_component_status_decodes

This table contains the textual version of the status values used in the sp402_components_states table. 
The current settings are:
1   StartingProcess has been started 
2   InitialisingProcess is loading 
3   ReadyProcess has loaded 
4   RunningProcess is able to service requests 
5   Shutting DownProcess is shutting down 
6   StoppedProcess has exited normally 
7   MissingProcess state is being investigated 
8   UnresponsiveProcess is not responding to requests 
9   FailedProcess has exited abnormally 
10 In Doubt Process may have data integrity problems


 

Table Definition

Field
Type
Default
Nullable
state_nonumber (error)
state_namevarchar2(15) (error)
descriptionvarchar2(50) (error)

Keys

primary key (state_no) 
unique (state_no)

Primary Key Referenced From

Column Descriptions

FieldDescription
state_noState identifier.
state_name Short name for the state.
descriptionFull description of the state.