sp416_host_machines
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Loading data...
This table contains a list of all the host machines that could be configured for use in a distributed ServiceOptimizer instance.
Â
If the ServiceOptimizer instance is not distributed then this table will have a single entry in with host_machine "localhost".
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| host_machine | varchar2(64) | Â |  |
| description | varchar2(64) | Â |  |
| monitor_no | number | Â | |
| archive_location | varchar2(260) | Â | |
| sphome | varchar2(260) | Â | |
Keys
primary key (host_machine)Â
foreign key (monitor_no) references sp406_monitors(component_no)
Column Descriptions
| Field | Description |
|---|---|
| host_machine | A computer that's available for use in this ServiceOptimizer instance. |
| description | Computer description. |
| monitor_no | Component number of the system monitor that is to run on this host. If NULL, this machine will not be used to host any SP components. |
| archive_location | Folder under which application log files are archived.  |
| sphome | The value of the SPHOME environment variable used for this host. |