Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual
Page 2391
Brocade Network Advisor SAN + IP User Manual
2319
53-1003155-01
Database tables and fields
I
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