Table Name:	server
Table Number:	5684
Group:	System
Description:	Stores information about server instances
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_server

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
is_alive	LONG	tinyint			0	DIRECT	Flag to signal if the process is alive or not; 0=dead, 1=is alive, default=0
is_local	LONG	tinyint			0	DIRECT	Whether the node is local; i.e., 0=Local, 1=Remote, default=0
last_start_time	CLK_TIME	datetime					Date/time of last time when the process was started
machine_name	CHAR	varchar		80			Name of the server where the server instance is running (e.g machine name where Notifier is running)
objid	LONG	int	3			DIRECT	Internal record number
process_name	CHAR	varchar		80			Name of the server server process e.g. Notifier, Rule Mgr
server_state	LONG	int			0	DIRECT	Indicates the state of the process: i.e., 0=Not running, 1=running, 2=waiting etc
update_timestamp	CLK_TIME	datetime	46				Date/time of update of the Server information

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
server2server_stats	OTM	server_stats	server_stats2server	Performance statistics for the server
server2time_zone	MTM	time_zone	time_zone2server	Time zones in which server is located		mtm_time_zone3_ server0

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

server

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user