HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 104

E Database tables and fields TABLE 170 SWITCH_PORT (Continued) Field Definition Format Size PORT_NUMBER The logical port number of the user port. There is no smallint assumption of any relation to the physical location of a port within a chassis. 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 varchar 64 TYPE Port type. The specific mode currently enabled for the varchar 16 port. FULL_TYPE Port type. varchar 128 STATUS The current status of the switch port. varchar 64 HEALTH varchar 16 STATUS_MESSAGE Status message if any. varchar 255 PHYSICAL_PORT 1 = it is a physical port 0 = it is a virtual port Default value is 1. smallint LOCKED_PORT_TYPE Locked port type. varchar 16 CATEGORY smallint PROTOCOL varchar 16 SPEED Actual speed at which the port is currently operating. varchar 64 SPEEDS_SUPPORTED Supported speed values. varchar 32 MAX_PORT_SPEED The maximum speed the port is capable of int supporting, in bits per second. DESIRED_CREDITS How many BB credits are desired for the port. int BUFFER_ALLOCATED How many BB credits are allocated for the port. int ESTIMATED_DISTANCE The estimated physical distance of the connection int between ports. ACTUAL_DISTANCE The physical distance of the connection on the port in int relation to the other port. LONG_DISTANCE_SETTING Whether long distance enabled. int DEGRADED_PORT Whether a port is degraded or not. varchar 16 REMOTE_NODE_WWN Node WWN of the attached port. varchar 255 REMOTE_PORT_WWN WWN of the attached port. varchar 255 LICENSED 1 = the port is licensed; otherwise, 0. smallint SWAPPED 1 = port is swapped; otherwise, 0. smallint TRUNKED 1 = port is trunked; otherwise, 0. smallint TRUNK_MASTER 1 = the port is trunk master; otherwise, 0. smallint 96 Brocade Network Advisor Documentation Updates 53-1002363-02