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

Database tables and fields E TABLE 170 SWITCH_PORT (Continued) Field Definition Format PERSISTENT_DISABLE 1 = port is persistently disabled. smallint FICON_SUPPORTED 1 = FICON is supported; otherwise, 0. smallint BLOCKED 1 = port is blocked; otherwise, 0. smallint PROHIBIT_PORT_NUMBERS varchar PROHIBIT_PORT_COUNT smallint NPIV Whether NPIV mode is enabled. smallint NPIV_CAPABLE Instance NPIV mode capability: 1 = indicates port has NPIV capability 2 = NPIV license is enabled smallint NPIV_ENABLED Whether NPIV mode is enabled. smallint FC_FAST_WRITE_ENABLED 1 = FC fast write is enabled. smallint ISL_RRDY_ENABLED smallint RATE_LIMIT_CAPABLE smallint RATE_LIMITED smallint QOS_CAPABLE smallint QOS_ENABLED smallint TUNNEL_CONFIGURED smallint FCIP_TUNNEL_UP smallint FCR_FABRIC_ID smallint FCR_INTEROP_MODE smallint CALCULATED_STATUS varchar USER_DEFINED_VALUE1 varchar USER_DEFINED_VALUE2 varchar USER_DEFINED_VALUE3 varchar KIND varchar STATE varchar 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 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 bigint PORT_BIT_MASK F-Port trunk bit mask value. int Default value is 0. Size 1024 64 256 256 256 32 64 64 Brocade Network Advisor Documentation Updates 97 53-1002363-02