Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1631)

Brocade Network Advisor SAN User Manual 1579
53-1003154-01
Database tables and fields
H
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
TRACKING_STATUS This represents bitmask as an integer value which
represents missing or untrusted state of fabric
members, ISLs, SANConnections, device Nodes and
device ports. 1 is missing switch/ISL in fabric, 2 is
untrusted switch or ISL in fabric, 4 is missing initiator
or port in fabric, 8 is untrusted initiator or port in
fabric, 16 is missing target or port in fabric, 32 is
untrusted target or port in fabric. int
BOTTLENECK_STATUS Holds bottleneck status of fabric. Default is 0, Values
are 0 or 1. int
TABLE 130 FABRIC (Continued)
Field Definition Format Size