Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1017
53-1002167-01
Database tables and fields
E
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
timestamp
LAST_SUCCESSFUL_TIME
STAMP
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
TABLE 135 FABRIC_MEMBER
Field Definition Format Size
FABRIC_ID* Fabric ID, foreign key to FABRIC table. int
VIRTUAL_SWITCH_ID* ID of the virtual switch which is a member of this fabric,
foreign key to VIRTUAL_SWITCH table.
int
TRUSTED 1 = the switch is a trusted member of the fabric. Either
found in the initial discovery or user subsequently
entrusted the switch by user action.
Default Value is 0.
smallint
CREATION_TIME When the switch became a member.
Default Value is ’now()’.
timestamp
MISSING 1 = it is missing from the fabric.
Default Value is 0.
smallint
MISSING_TIME When it is missed from the fabric; null if the member is
entrusted.
timestamp
LAST_UPDATE bigint
TABLE 133 FABRIC (Continued)
Field Definition Format Size