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

1138 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
CONFIGURED_TOPOLOGY The topology setting.
The default value is 1.
int
MAX_SPEED_SUPPORTED The maximum port speed that is supported on the
port, in Gb/s. The default value is 0.
int
OPERATING_STATE Indicates whether the link is online or offline. The
default value is 0.
smallint
OPERATING_TOPOLOGY The topology setting at which the port is operating.
The default value is 1.
int
SUPPORTED_FC4_TYPES varchar 32
SUPPORTED_COS varchar 32
TRUSTED The default value is 1. smallint
CREATION_TIME The default value is ‘ now() ‘. timestamp
MISSING The default value is 0. smallint
MISSING_TIME timestamp
OPERATING_SPEED Operating speed of the hba port. The default value is
0.
varchar 64
CNA_PORT_ID Nullable foreign key, related FC pot with the CNA port int
PORT_NWWN Node WWN for the HBA port varchar 23
PHYSICAL_PORT_WWN Physical Ports WWN in case of V port varchar 128
SWITCH_IP IP of the switch, HBA port is connected to varchar 23
PRINCIPAL_SWITCH_WWN WWN of the principal switch of the fabric, HBA is
connected to
varchar 128
HBA_ID HBA ID of the HBA this port belongs to int
PORT_NUMBER The default value is -1. smallint
NAME Name defined for the HBA port in HCM varchar
FACTORY_PORT_WWN Factory configured Port WWN defined for the HBA
port in HCM
varchar
FACTORY_NODE_WWN Factory configured Node WWN defined for the HBA
port in HCM
varchar
PREBOOT_CREATED Flag to identify vports created during preboot varchar
TABLE 388 HBA_PORT_DETAIL
Field Definition Format Size
DEVICE_PORT_ID Device port id acts as the primary key int
PERSISTENT_BINDING The default value is 0. smallint
FABRIC_NAME varchar 64
BOOT_OVER_SAN Flag to indicate whether boot over SAN is enabled or
not..
The default value is 0.
smallint
BOOT_OPTION The default value is 0. smallint
TABLE 387 HBA_PORT (Continued)
Field Definition Format Size