Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2186)

Brocade Network Advisor SAN + IP User Manual 2149
53-1002949-01
Database tables and fields
I
THRESHOLD_OP Stores the threshold operator value. varchar 10
REARM_OP Stores the rearm operator value. varchar 10
IS_REARM_ABS Whether or not the rearm. Default - 0. smallint
THRESHOLD_SEVERITY The severity for the threshold event. smallint
REARM_SEVERITY The severity for the rearm event. smallint
IS_SYSTEM Indicates whether this is a system built in collector,
user cannot delete it. Default - 1. smallint
TABLE 323 PM_MEASURE
Field Definition Format Size
ID* Unique generated database identifier. int
DESCRIPTION The description of the
. varchar 64
NAME Name of the measure. varchar 32
TABLE 324 PM_STATS_AGING_POLICY
Field Definition Format Size
ID Auto generated unique Identifier. Primary key for the
table. int
RAW_SAMPLE_AGE The maximum time in seconds for retaining records
in the PM stats raw sample tables
(TIME_SERIES_DATA_1 or TIME_SERIES_DATA_2) in
database.
int 64
THIRTY_MIN_SAMPLE_AGE The maximum time in seconds for retaining records
in the PM stats 30min sample tables
(TIME_SERIES_DATA_1_30MIN and
TIME_SERIES_DATA_2_30MIN) in database.
int
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 325 PM_WIDGET_MEASURE_TYPE
Field Definition Format Size
Type Primary key column. int
NAME Storing the NAME of the measure. varchar 64
TABLE 322 PM_DATA_COLLECTOR (Continued)
Field Definition Format Size