Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1747)

Brocade Network Advisor SAN User Manual 1695
53-1003154-01
Database tables and fields
H
TABLE 395 SWITCH_PORT
Field Definition Format Size
ID* Unique generated database identifier. int
VIRTUAL_SWITCH_ID DB ID of virtual_switch to which this port belongs. int
WWN WWN of the port. char 23
NAME User friendly name of the port. char 32
SLOT_NUMBER Slot number.
Default value is 0. int
PORT_NUMBER The logical port number of the user port. There is no
assumption of any relation to the physical location of
a port within a chassis. smallint
USER_PORT_NUMBER User port number. Unique port number in a chassis. smallint
PORT_ID Port ID of this port. varchar 8
PORT_INDEX Number used for identifying port in zoning. smallint
AREA_ID Area number the port is assigned to. smallint
MAC_ADDRESS MAC address of this port. varchar 64
PORT_MOD Stores the port module type. Not applicable if port
doesn't have a GBIC installed. varchar 64
TYPE Port type. The specific mode currently enabled for the
port. The port type could be U-Port, F-Port, E-Port etc. varchar 16
FULL_TYPE Refers to the full type of the port, U-Port, F-Port etc. varchar 128
STATUS Refers to the Status of the port. Eg. No Light, No
Module, Mod_inv, Online etc. varchar 64
HEALTH Refers to the Health of the port. Eg. Unmonitored,
Healthy, Offline , Error etc. varchar 16
STATUS_MESSAGE Any additional port level status similar to what is
seen in CLI, like Segmented, Speed Mismatch, Trunk
master etc are stored here. varchar 255
PHYSICAL_PORT Indicates if the port is physical port. It will be 0 for
virtual ports Eg. Ports created by LISLs. smallint
LOCKED_PORT_TYPE Indicates the locked port type of the port. Ports can
be locked down so that they can come up only in that
mode. varchar 16
CATEGORY Denotes the category of the switch. 1 denotes FC
port and 2 denotes gige port. smallint
PROTOCOL The protocol used by the port. FC, FCIP etc. varchar 16
SPEED Actual speed at which the port is currently operating. varchar 64
SPEEDS_SUPPORTED The supported port speed as a list of comma
separated values. varchar 32
MAX_PORT_SPEED The maximum speed the port is capable of
supporting, in bits per second. int
DESIRED_CREDITS How many BB credits are desired for the port. int
BUFFER_ALLOCATED How many BB credits are allocated for the port. int