User's Manual

Brocade Network Advisor IP User Manual 1501
53-1003056-01
Database tables and fields
I
TWO_HOUR_SAMPLE_AGE The maximum time in seconds for retaining records
in the PM stats 2hour sample tables
(TIME_SERIES_DATA_1_2HOUR and
TIME_SERIES_DATA_2_2HOUR) in database.
int
ONE_DAY_SAMPLE_AGE The maximum time in seconds for retaining records
in the PM stats 1day sample tables
(TIME_SERIES_DATA_1_1DAY,
TIME_SERIES_DATA_2_1DAY) in database.
int
POLICY_TYPE Type of the aging policy. 100 is Default aging; 101 is
Raw samples to 1 day.
int
ACTIVE State of the aging policy. 1 is Active, 0 is Inactive. int 32
TABLE 282 PM_WIDGET_MEASURE_TYPE
Field Definition Format Size
Type Primary key column. int
NAME Storing the NAME of the measure. varchar 64
TABLE 283 PM_WIDGET_MEASURE_TYPE_ENTRY
Field Definition Format Size
WIDGET_ID The id of the widget definition. int
MEASURE_TYPE stores measure type id of the widget, a widget could
map to multiple measure types.
int
TABLE 284 PM_WIDGET_MONITOR_TYPE
Field Definition Format Size
Type Primary key column. int
NAME Storing the NAME of the monitor type. varchar 64
TABLE 285 PM_WIDGET_TARGET_ENTRY
Field Definition Format Size
WIDGET_ID The ID of the widget definition. int
TARGET_TYPE 0 - Device
1 - Port
smallint
TARGET_ID Stores device ID if taret_TYPE is Device, or interface
DB ID if target TYPE is port.
int
TABLE 286 PM_WIDGET_TIME_SERIES_ENTRY
Field Definition Format Size
WIDGET_ID The ID of the widget definition. int
COLLECTOR_ID ID of the PERF_COLLECTOR. int
TABLE 281 PM_STATS_AGING_POLICY (Continued)
Field Definition Format Size