Brocade Communications Systems IP250 Pmmeasure, Database tables and fields Pmdatacollector

I Database tables and fields

TABLE 279 PM_DATA_COLLECTOR (Continued)

Field	Definition	Format	Size
STATUS	Status of the collector. 0 - disabled and 1 - enabled.	smallint
	Default - 0.
TYPE	Target type of the snmp collector data. for device	smallint
	level collector the target type is 0, for port level it is 1.
POLLING_INTERVAL	Time interval in seconds; indicates the frequency	int
	with which the collector will poll the device to get the
	data.
CREATED_TIME	Collector created time.	timestamp
CREATE_USER_ID	The user id who has created this collector.	int
ENABLE_THRESHOLD	Widget definition created server time.	smallint
THRESHOLD	Stores the threshold value.	double
		precision
REARM	Stores the rearm value.	double
		precision
THRESHOLD_OP	Stores the threshold operator value.	varchar	10
REARM_OP	Stores the rearm operator value.	varchar	10
IS_REARM_ABS	Whether or not the rearm. Default - 0.	smallint
THRESHOLD_SEVERITY	The severity for the threshold event.	smallint
REARM_SEVERITY	The severity for the rearm event.	smallint
IS_SYSTEM	Indicates whether this is a system built in collector,	smallint
	user cannot delete it. Default - 1.

TABLE 280 PM_MEASURE

Field	Definition	Format	Size
ID*	Unique generated database identifier.	int
DESCRIPTION	The description of the	varchar	64
	.
NAME	Name of the measure.	varchar	32

TABLE 281 PM_STATS_AGING_POLICY

Field	Definition	Format	Size
ID	Auto generated unique Identifier. Primary key for the	int
	table.
RAW_SAMPLE_AGE	The maximum time in seconds for retaining records	int	64
	in the PM stats raw sample tables
	(TIME_SERIES_DATA_1 or TIME_SERIES_DATA_2) in
	database.
THIRTY_MIN_SAMPLE_AGE	The maximum time in seconds for retaining records	int
	in the PM stats 30min sample tables
	(TIME_SERIES_DATA_1_30MIN and
	TIME_SERIES_DATA_2_30MIN) in database.

1500	Brocade Network Advisor IP User Manual
	53-1003056-01