Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1205
53-1002696-01
Database tables and fields
H
AD_ENVIRONMENT 1 = there are user-defined ADs in this fabric.
Default value is 0.
smallint
MANAGED 1 = it is an actively "monitored" fabric; otherwise, it is
an "unmonitored" fabric.
Default value is 1.
smallint
MANAGEMENT_STATE Bit map to indicate various management indications
for the fabric.
Default value is 0.
smallint
TRACK_CHANGES 1 = changes (member switches, ISL and devices) in
the fabric are tracked.
Default value is 0.
smallint
STATS_COLLECTION 1 = statistics collection is enabled on the fabric.
Default value is 0.
smallint
CREATION_TIME When the fabric record is inserted, i.e., created.
Default value is ’now()’.
timestamp
LAST_FABRIC_CHANGED Time when fabric last changed. timestamp
LAST_SCAN_TIME Last Scan time for the fabric i.e. when the switch was
scanned for changes.
timestamp
LAST_UPDATE_TIME Time when fabric was last updated.
Default value is ’now()’.
timestamp
ACTIVE_ZONESET_NAME Name of the zone configuration which is effective /
active in that fabric.
varchar 256
USER_DEFINED_VALUE_1 User-defined custom value. varchar 256
USER_DEFINED_VALUE_2 User-defined custom value. varchar 256
USER_DEFINED_VALUE_3 User-defined custom value. varchar 256
PRINCIPAL_SWITCH_WWN WWN of the principal switch of the fabric char 23
ZONE_TRANSACTION_TIM
EOUT
Number of seconds that a ZONE_TRANSACTION can
be idle
Default value is 180.
int
FABRIC_MODEL Default value is 1. smallint
LAST_FAILURE_TIMESTAM
P
Denotes the last failure timestamp. timestamp
LAST_SUCCESSFUL_TIME
STAMP
Dentoes the last successful timestamp. timestamp
ENHANCED_TI_ZONE_SUP
PORT
Holds the value if the fabric has enhanced TI Zone
support or not. Default: 0 Values: 0|1.
smallint
FABRIC The fabric name persisted on switches running FOS
7.0 and later. Not to be confused with NAME, which is
store on Network Advisor only.
varchar 128
STATUS Overall operational status of the fabric. 0 is unknown,
1 is healthy, 2 is marginal, 3 is down, 5 is Reachable, 6
is unreachable, 7 is Degraded link.
int
TABLE 108 FABRIC (Continued)
Field Definition Format Size