I

Database tables and fields

 

 

 

 

 

TABLE 412 TIME_SERIES_DATA_4

 

 

 

 

 

 

 

 

 

 

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 raw data received from the device.

double

 

 

 

 

 

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 413 TIME_SERIES_DATA_4_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.

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 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

 

 

 

 

 

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.

 

 

 

 

 

 

1556

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1608
Image 1608
Brocade Communications Systems IP250 user manual TIMESERIESDATA41DAY