Brocade Communications Systems IP250 user manual Database tables and fields TIMESERIESDATA32HOUR

		Database tables and fields		I
TABLE 410	TIME_SERIES_DATA_3_2HOUR (Continued)
Field		Definition	Format	Size
TARGET_ID		Target ID of the PM collector data. For device level	int
		collector it will use deviceId/virtualSwitchId, for port
		level it will use interfaceId/switchPortId/
		fcipTunnelId/devicePortId.
COLLECTOR_ID		DB ID of the pm_data_collector.	int
MEASURE_INDEX		Stores the index_map value in case of an expression.	varchar	256
ME_ID		ME_ID of the target.	int
VALUE		Stores the 2 hours aggregated data.	double
			precision
MIN_VALUE		Minimum value in 30 min table while aggregating 2	double
		hours of data.	precision
MAX_VALUE		Maximum value in 30 min table while aggregating 2	double
		hours of data.	precision
SUM_VALUE		Named after SUM_VALUE to be consistent with	double
		column names in aggregated data tables.Stores the	precision
		delta changes for counter values between two
		samples, only used for counter values, 0 for all other
		types of measures.
TABLE 411	TIME_SERIES_DATA_3_30MIN
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.	smallint
MEASURE_ID		ID of the measure (MIB/Expression).	int
TARGET_ID		Target ID of the PM collector data. For device level	int
		collector it will use deviceId/virtualSwitchId, for port
		level it will use interfaceId/switchPortId/
		fcipTunnelId/devicePortId.
COLLECTOR_ID		DB ID of the pm_data_collector.	int
MEASURE_INDEX		Stores the index_map value in case of an expression.	varchar	256
ME_ID		ME_ID of the target.	int
VALUE		Stores the 30 minutes aggregated data.	double
			precision
MIN_VALUE		Minimum value in raw performance statistics table	double
		while aggregating 30 minutes of data.	precision
MAX_VALUE		Maximum value in raw performance statistics table	double
		while aggregating 30 minutes of data.	precision
SUM_VALUE		Named after SUM_VALUE to be consistent with	double
		column names in aggregated data tables.Stores the	precision
		delta changes for counter values between two
		samples, only used for counter values, 0 for all other
		types of measures.

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