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

Brocade Network Advisor SAN User Manual 1399
53-1002948-01
Database tables and fields
H
TABLE 213 HBA_NODE_MAP
Field Definition Format Size
DEVICE_NODE_ID Primary key from the Device Node table int
HBA_ID Primary key from the HBA table int
TABLE 214 HBA_PORT
Field Definition Format Size
DEVICE_PORT_ID Primary key on the owner Device port table int
CONFIGURED_STATE Indicates whether the port is enabled or disabled.
The default value is 0.
smallint
CONFIGURED_SPEED The configured speed of the port. E.g. Auto-negotiate varchar 64
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 List of supported FC4 types for this port. varchar 32
SUPPORTED_COS Supported Class of Service (COS) for this port. varchar 32
TRUSTED Denotes whether port is trusted or not. 0 denotes
untrusted and 1 is for trusted.
smallint
CREATION_TIME HBA port record creation time. This tells us when this
HBA port was first discovered.
timestamp
MISSING Denotes whether port is missing or not. 0 denotes
present and 1 states that port is missing from fabric.
smallint
MISSING_TIME States the missing time of the this port. 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 Port number of this HBA port. 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