Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1264 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
PHANTOM_TYPE The phantom type of the port, either front or xlate int
BB_FABRIC_ID Denotes the Backbone Fabric ID. int
TABLE 234 PHYSICAL_DEVICE
Field Definition Format Size
PHYSICAL_DEVICE_ID Unique generated database identifier. int
DEVICE_ID Database identifier of the DEVICE instance. int
DESCRIPTION System description of the device. varchar 255
NUM_SLOTS Number of slots present in the device. num (4,0)
TABLE_SUBTYPE Table name where additional properties/attributes
about this physical device stored. Possible value is
FOUNDRY_PHYSICAL_DEVICE.
varchar 32
UNIT_NUMBER Unit number in the stack if it is stackable device . For
non-stacking device it will be always 0.
num (2,0)
UNIT_NEIGHBOR1 Stacking neighbor's unit(left) number for the
stackable devices. If there is no neighbor unit/non
stackable devices, then set to 0.
num (2,0)
UNIT_NEIGHBOR2 Stacking neighbor's unit(left) number for the
stackable devices . If there is no neighbor unit/non
stackable devices, then set to 0.
num (2,0)
UNIT_PRESENT Used to identify the stack unit is present in the
chassis or not. Present-1 and Not Present-2.
num (1,0)
TABLE 235 PHYSICAL_INTERFACE
Field Definition Format Size
INTERFACE_ID Primary key for this table. int
PHYSICAL_PORT_ID Foreign key which refers PHYSICAL_PORT table. int
SPEED_IN_MB Interface speed in Mega Bytes. int
PHYSICAL_ADDRESS MAC address of this interface. varchar 64
LINK_ID Foreign key which refers LINK table. int
DUPLEX_MODE Interface duplex mode. Full/Half/Auto. smallint
IS_STACKING_INTERFACE This flag is to indicate whether the interface is
stacking interface. 0 indicates non-stacking and
1-indicates stacking interface.
num (1,0)
IS_PORT_PRESENT This flag is to indicate whether the port is presented
in the device.
0 = Unknown
1 = Present
2 = Not present
int
PHYSICAL_DEVICE_ID For DCB switch, this is the core switch id.
For IP products, this is the physical_device_id in
physical_device table.
int
TABLE 233 PHANTOM_PORT (Continued)
Field Definition Format Size