Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1701

Advertising
background image

Brocade Network Advisor SAN User Manual

1649

53-1003154-01

Database tables and fields

H

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 279

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 or peri port. 0 indicates
non-stacking, 1-indicates stacking interface,
2-indicates peri port.

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

UNIT_NUMBER

This is the unit number of which the interface is
located for IP stacking products.
If it is not applicable, the value is -1.

int

SLOT_NUMBER

This is the slot number of which the interface is
located for the devices and switches.
If it is not applicable, the value is -1.

int

PORT_NUMBER

This is the port number of the interface.

int

PORT_TYPE

This column is used to store the port type of the
interface. The value will be populated by the
NosSwitchAssetCollector during the discovery of the
VCS switch.The value of 0 means its edge port, and 1
means its trill port. Default value is 0.

smallint

UNIT_TYPE

Indicates unit type in the stack. This column stores
the model type of a stackable unit such as
"ICX6610-48P". For non-stacking device it will be
empty

varchar

64

TABLE 278

PHYSICAL_DEVICE (Continued)

Field

Definition

Format

Size

Advertising