User Manual v12.3.0 Owner's manual

Brocade Network Advisor IP User Manual 1607
53-1003153-01
Database tables and fields
I
BB_PORT_ID Backbone switch port ID. int
BB_PORT_WWN Backbone switch port WWN. varchar 23
TABLE 188 INTERFACE
Field Definition Format Size
INTERFACE_ID int
SWITCH_SERVICE_ID int
DEVICE_ID int
NAME varchar 255
IDENTIFIER varchar 255
TABLE_SUBTYPE varchar 255
TAG_MODE smallint
VLAN_TAG_TYPE int
UNTAGGED_VLAN_ID The existing Data type short has been modified to
integer. Hence it supports 16 bit additionally.
int
IF_NAME varchar 64
LLDP_PORT_ID_SUBTYPE smallint
LLDP_PORT_ID bytea
IS_FDP_ENABLED num (1,0)
IS_CDP_ENABLED num (1,0)
PORT_STATUS smallint
PORT_STATE smallint
IF_INDEX This column is used to store the ifIndex of the
interface. The value will be populated by the DCB
collector during the discovery of the DCB switch.
Since this value is not populated by IP discovery
engine, making the field as nullable.
int
AMPP_PROFILE_MODE Specifies whether the interface is set to AMPP profile
mode.
smallint
DOT1D_PORT_NUM To store dot1d port number in DB to reduce SNMP
calls to switch from IfIndexUtility
int
EDGE_TYPE The type of the device that is connected to the edge
switch port.
-1 : NA, 0 : connected to device with unknown type, 1
: connected to managed Brocade branded AP, 2 :
connected to standalone Brocade branded AP.
int
USER_DEFINED_VALUE_1 User defined value used for IP Port. varchar 256
USER_DEFINED_VALUE_2 User defined value used for IP Port. varchar 256
TABLE 187 IFL_CONNECTION
Field Definition Format Size