sp400_components
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Loading data...
This table gives all the required information to start a component process.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
component_no | number | Â | |
component_id | varchar2(15) | Â | |
component_type | number | Â | |
parameters | varchar2(200) | Â | |
host_machine | varchar2(64) | Â | |
fru_no | number(4) | Â | |
active | number(1) | Â | |
max_restarts | number | Â | |
trace_mask_no | number | Â | |
max_log_file_size | number | Â | |
trace_cycle_enabled | number(1) | Â | |
 Keys
primary key (component_no)Â unique (component_id)Â unique (fru_no)Â foreign key (component_type) references sp405_component_types (type_no)Â foreign key (fru_no) references sp058_responsibility_units (resp_unit_no)Â foreign key (trace_mask_no) references sp412_trace_masks (trace_mask_no)
Primary Key Referenced From
sp401_component_hierarchysp402_component_statessp406_monitorssp409_component_portssp414_assigned_ports
Â
Â
Column Descriptions
| Field | Description |
|---|---|
component_no | Internal identifier for the component. |
component_id | Textual identifier for the component.
|
component_type | Type of process as in sp405. |
parameters | Command line parameters other than those automatically supplied by spsysmon. |
host_machine | Specifies the host machine on which this component should run. If this field is set to NULL, "localhost" or the master System Monitor's host, then this component will run on the same host as the master System Monitor. Otherwise the specified host must exist in sp416_host_machines. The host on which a system monitor is configured is not specified here but in sp416_host_machines instead: this field will always be NULL for a system monitor. |
fru_no | If component is an spfru, which fru it is serving. |
active | Boolean: whether monitor should start/update this process or not. |
max_restarts | Number of times restart can be attempted if the process fails to start cleanly. |
trace_mask_no | Specifies the trace level used by this component for diagnostic log output. If null, sp083_system_parameters value glob_trace_mask_no will be used instead. |
max_log_file_size | Specifies the maximum size of the diagnostic log file produced by this component, in Mb. When this limit is reached older entries are overwritten. If null, sp083_system_parameters value glob_trace_max_file_size will be used instead. |
trace_cycle_enabled | Log file can either re-cycle or create a new instance once a maximum size has been reached. Default (1) use log re-cycling. |
 This column does not support wide (i.e. multibyte) characters.