Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1379
53-1002948-01
Database tables and fields
H
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
VCS_LICENSED Indicates whether the fabric has VCS license or not.
Possible values are 0 for not applicable, 1 for licensed,
2 for not licensed. 0 is default. Fabrics representing
clusters with 2 or less nodes will have value of 0 as all
those are automatically licensed. Fabrics representing
clusters with 3 or more nodes will have values 1 or 2
depending on whether the license was acquired or
not.
int
TABLE 176 FABRIC (Continued)
Field Definition Format Size