Brocade Communications Systems IP250 user manual Thresholdmeasure, Thresholdpolicy, Timeseriesdata

	Database tables and fields		I
TABLE 394 THRESHOLD_MEASURE
Field	Definition	Format	Size
MEASURE_ID*	References the ID In PM_MEASURE table, where all	int
	measures are defined.
HIGH_BOUNDARY	Configured high boundary threshold value for	int
	measure ID.
LOW_BOUNDARY	Configured low boundary threshold value for	int
	measure ID.
BUFFER_SIZE	Configured buffer size for measure ID.	int
POLICY_ID*	References the ID in THRESHOLD_POLICY table.	int
TABLE 395 THRESHOLD_POLICY
Field	Definition	Format	Size
ID*		int
NAME	Name of the policy.	varchar	100
TYPE	Type of the policy.	varchar	20
DESCRIPTION	Description about the policy.	varchar	100
TABLE 396 TIME_SERIES_DATA
Field	Definition	Format	Size
TIME_IN_SECONDS	Time when value of the measure retrieved from the	int
	corresponding target.
TARGET_TYPE	Target type of the PM collector data. For device level	smallint
	collector the target type is 0, for port level it is 1.
MEASURE_ID	ID of the measure.	int
TARGET_ID	Target ID of the PM collector data. For device level	int
	collector it will use deviceId, for port level it will use
	interfaceId.
COLLECTOR_ID	ID of the data_collector.	int
MEASURE_INDEX	'Stores the index_map value in case of anexpression.	varchar	256
ME_ID	ME_ID of the target.	int
VALUE	30 mins aggregated data.	double
		precision
TABLE 397 TIME_SERIES_DATA_1DAY
Field	Definition	Format	Size
TIME_IN_SECONDS	Time when the record is inserted.	int
TARGET_TYPE	Target type of the PM collector data. For device level	smallint
	collector the target type is 0, for port level it is 1.
MEASURE_ID	ID of the measure.	int
TARGET_ID	Target ID of the PM collector data. For device level	int
	collector it will use deviceId, for port level it will use
	interfaceId.

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