I

Database tables and fields

 

 

 

 

 

TABLE 405 TIME_SERIES_DATA_2_1DAY

 

 

 

 

 

 

 

 

 

 

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

smallint

 

 

 

 

IP_DEVICE(0), IP_PORT(1), IP_TRUNK(2),

 

 

 

 

 

FOS_DEVICE(3), FC_PORT(4), GE_PORT(5),

 

 

 

 

 

TE_PORT(6), HBA_PORT(7), CNA_PORT(8),

 

 

 

 

 

VIRTUAL_FCOE_PORT(9), FCIP_TUNNEL(10),

 

 

 

 

 

EE_MONITOR(11), IP_DEVICE_GROUP(12),

 

 

 

 

 

IP_PORT_GROUP(13), VIRTUAL_GROUP(14),

 

 

 

 

 

TRILL_TRUNK(15), ALL_SAN_PRODUCTS(16).

 

 

 

 

 

 

 

 

 

 

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 One day aggregated data.

double

 

 

 

 

 

precision

 

 

 

 

 

 

 

 

 

MIN_VALUE

Minimum value in 2 hour table while aggregating 1

double

 

 

 

 

day data.

precision

 

 

 

 

 

 

 

 

 

MAX_VALUE

Maximum value in 2 hour table while aggregating 1

double

 

 

 

 

day data.

precision

 

 

 

 

 

 

 

TABLE 406 TIME_SERIES_DATA_2_2HOUR

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

smallint

 

 

IP_DEVICE(0), IP_PORT(1), IP_TRUNK(2),

 

 

 

FOS_DEVICE(3), FC_PORT(4), GE_PORT(5),

 

 

 

TE_PORT(6), HBA_PORT(7), CNA_PORT(8),

 

 

 

VIRTUAL_FCOE_PORT(9), FCIP_TUNNEL(10),

 

 

 

EE_MONITOR(11), IP_DEVICE_GROUP(12),

 

 

 

IP_PORT_GROUP(13), VIRTUAL_GROUP(14),

 

 

 

TRILL_TRUNK(15), ALL_SAN_PRODUCTS(16).

 

 

 

 

 

 

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

 

1552

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1604
Image 1604
Brocade Communications Systems IP250 user manual TIMESERIESDATA21DAY, TIMESERIESDATA22HOUR