Brocade Network Advisor SAN + IP User Manual v12.1.0 User Manual

Page 2223

Advertising
background image

2186

Brocade Network Advisor SAN + IP User Manual

53-1002949-01

Database tables and fields

I

RATE_LIMITED

Denotes if the port has Rate Limiting Enabled.

smallint

QOS_CAPABLE

Indicates if the port is QOS capable.

smallint

QOS_ENABLED

Indicates if the port is QOS enabled.

smallint

TUNNEL_CONFIGURED

Denotes if the port has a fcip tunnel configured.

smallint

FCIP_TUNNEL_UP

Denotes if the fcip tunnel that is configured is up.

smallint

FCR_FABRIC_ID

Stores the FCR fabric ID. Applicable if the port is
configured as an EX port.

smallint

FCR_INTEROP_MODE

The interop mode of the FCR fabric. Applicable if the
port is an EX port.

smallint

CALCULATED_STATUS

The calculated status of the port. Eg. Healthy, Down,
Marginal etc.

varchar

64

USER_DEFINED_VALUE1

User defined value used for annotation.

varchar

256

USER_DEFINED_VALUE2

User defined value used for annotation.

varchar

256

USER_DEFINED_VALUE3

User defined value used for annotation.

varchar

256

KIND

Stores the port kind from the NVP portKind.

varchar

32

STATE

The state of the port whether it is online or offline

varchar

64

PREVIOUS_STATUS

This table can hold the same values as STATUS
column. But this will be holding the previous status of
the PORT. These values to be populated by switch
asset collector.

varchar

64

AUTO_DISABLE_CONFIGUR
ED

To represent auto disable configuration state (set by
user).
Default value is 0.

smallint

AUTO_DISABLED

To represent auto disabled status (set by switch).
Default value is 0.

smallint

OCCUPIED

Default value is 0.

smallint

LAST_UPDATE

Last update time stored as long value. Elapsed time
from 1970 in milliseconds.

bigint

PORT_BIT_MASK

F-Port trunk bit mask value.
Default value is 0.

int

LOGICAL_PORT_NUMBER

F-Port trunk logical port number.
Default value is -1.

smallint

DEFAULT_AREA_ID

Default Area id of F-Port trunk port.
Default value is -1.

smallint

LOGICAL_PORT_WWN

Logical port WWN of F-Port trunk group.

char

23

PREVIOUS_TYPE

This fields copies the old state of the port type. The
field could be used to track the state change
information for the switch port type.
SwitchAssetCollector sets this field during the
collection time. SMIA requested this information but
could be used by any module which needs to track
the type state change.

varchar

16

TABLE 418

SWITCH_PORT (Continued)

Field

Definition

Format

Size

Advertising