14.1 sp417_system_state

This table contains a single row that describes the current system state of the ServiceOptimizer instance.

Table Definition

Field	Type	Default	Nullable
state	number
osuser	varchar2(256)
master_host	varchar2(64)
system_start	date
system_end	date

foreign key (state) references 14.1 sp407_monitor_state_decodes(state_no)

Field	Description
state	State of the ServiceOptimizer instance e.g. startingSP/runningSP/stoppingSP etc.
osuser	Operating system user that ran the last master system monitor process. This is stored for recovery purposes. It is null if the master system monitor has exited normally.
master_host	Server machine that ran the last master system monitor process. This is stored for recovery purposes. Note that this is the real host name (e.g. "spserver") and not the configured host name in sp416_host_machines (e.g. "localhost"). It is null if the master system monitor has exited normally.
system_start	The date and time at which the ServiceOptimizer instance was last started.This is the time on the host machine on which the master system monitor is running, with no reference to effective time, in the default SP timezone (reference sp083_system_parameters entry for value 'tz_Default').
system_end	The date and time at which the ServiceOptimizer instance ended. (Timezone as per system_start). NULL if system is currently running.