The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.
The Fabric Manager Server database is a repository for data used by the Cisco MDS 9000 Family Fabric Manager applications, which include Fabric Manger, Performance Manager, and Device Manager. Performance Manger uses the data to generate reports.
The Fabric Manager Server database can also be used by third-party report generation tools to create custom reports. You can use the Structured Query Language (SQL) database schema definitions described in this document to access the database. The SQL schema definition file, dbname.script, can be found in the MDS 9000\bin directory on the computer where Fabric Manager was installed.
The schema tables are described in two sections:
•Related Fabric Manager Server Database Schema Tables
•Individual Fabric Manager Server Database Schema Tables
The tables in the Fabric Manager Server schema are grouped by related functions in the following sections:
•Cisco Traffic Analyzer Tables
•Storage Media Encryption Tables
The schema tables that relate to switch management are described in Table 1-1.
The schema tables that relate to enclosures are described in Table 1-2.
The schema tables that relate to the fabric are described inTable 1-3.
The schema tables that relate to network management are described in Table 1-4.
The schema tables that relate to Performance Manager are described in Table 1-5.
The schema tables that relate to Cisco Traffic Analyzer are described in Table 1-6.
The schema tables that relate to Cisco User Access are described in Table 1-7.
The schema tables that relate to configuration backup are described in Table 1-8.
|
|
---|---|
Describes the XML files where the configuration information is stored. |
|
Provides the configuration file where the information is stored. |
The schema tables that relate to storage media encryption are described in Table 1-9.
The schema tables that relate to the LAN are described in Table 1-9.
The individual schema tables contain the column name, the JDBC SQL data type, and a description. Footnoted after each table are the indexes defined against columns in that table. The following tables are described in this section:
•HBA
•ISL
•NTOP
•VSAN
•ZONE
Table 1-11 describes the cluster configurations in the CLUSTER database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Describes the ID of the entry in the table. |
FABRIC_ID1 |
INTEGER |
Describes the ID of the parent fabric. |
|
CLUSTER_ID |
VARCHAR2(255) |
Describes the ID of the cluster. |
|
NAME |
VARCHAR2(255) |
Describes the name of the cluster. |
|
CLUSTER_TYPE |
INTEGER |
Describes the cluster type. |
|
STATE |
INTEGER |
Describes the cluster state. |
|
IS_MASTER |
NUMBER(1) |
Describes whether this is the master IP. |
|
MASTER_ADDR_TYPE |
INTEGER |
Describes the master switch address type. |
|
MASTER_ADDR |
VARCHAR2(255) |
Describes the master switch address. |
|
MASTER_IP |
VARCHAR2(255) |
Describes the IP address of the master switch. |
|
SWITCH_ID2 |
INTEGER |
Describes the ID of the switch. |
|
IS_PRESENT |
NUMBER(1) |
Indicates whether the end port exists in any of the VSANs. |
|
LAST_UPDATE_TIME |
TIMESTAMP |
Provides the time when the entry was updated. |
1 BASE_SVC_CLUSTER_FABRIC_ID is an index based on the column FABRIC_ID. 2 BASE_SVC_CLUSTER_SWITCH_ID is an index based on the column SWITCH_ID. |
Note The CARD Fabric Manager Server database schema table is no longer in use.
Table 1-12 describes the card configurations in the CARD database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Describes the ID of the entry in the table. |
CARD_SLOT1 |
INTEGER |
Describes the card slot number. |
|
SWITCH_ID2 |
INTEGER |
Provides the ID of the switch that generated the event. |
|
NAME |
VARCHAR2(256) |
Describes the name of the enclosure. |
|
TYPE |
INTEGER |
Describes the type of the event. |
|
HW_VERSION |
VARCHAR2(256) |
Provides the hardware version |
|
SW_VERSION |
VARCHAR2(256) |
Provides the firmware version. |
|
SERIAL_NUMBER |
VARCHAR2(256) |
Provides the sequence number assigned to the peer node during manufacturing. |
|
ASSET_ID |
VARCHAR2(256) |
Provides the asset ID of the hardware component. |
|
LAST_SCAN_TIME |
INTEGER |
Provides the time when last seen, in milliseconds since 1/1/1970. |
|
LAST_UPDATE_TIME |
TIMESTAMP |
Provides the time when the entry was updated. |
|
STATUS |
INTEGER |
Describes the status of the card. |
|
MODEL_NAME |
VARCHAR2(256) |
Describes the model name of the hardware component. |
|
RESERVE_COL1 |
VARCHAR2(256) |
Deprecated. |
|
RESERVE_COL2 |
VARCHAR2(256) |
Deprecated. |
1 CARD_SWITCH_ID_INDEX is an index based on the column SWITCH_ID. 2 CARD_SLOT_INDEX is an index based on the column CARD_SLOT. |
Table 1-13 describes the configuration file information in the CONFIG_FILE database schema table.
Table 1-14 describes the device alias information in the DEVICE_ALIAS database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Describes the ID of the entry in the table. |
FABRIC_ID1 |
INTEGER |
Describes the ID of the parent fabric. |
|
CFS_REGION_ID2 |
INTEGER |
Describes the ID of the CFS region. |
|
WWN3 |
RAW(8) |
Describes the WWN of the end port. |
|
ALIAS |
VARCHAR2(256) |
Describes the device alias. |
|
LAST_UPDATE_TIME |
TIMESTAMP |
Provides the time when the entry was updated. |
|
RESERVE_COL1 |
VARCHAR2(256) |
Deprecated. |
|
RESERVE_COL2 |
VARCHAR2(256) |
Deprecated. |
1 DEVALIAS_FABRIC_ID is an index based on the column FABRIC_ID. 2 DEVALIAS_CFS_REGION_ID is an index based on the column CFS_REGION_ID. 3 DEVALIAS_WWN_INDEX is an index based on the column WWN. |
Table 1-15 describes an enclosure, which can be a physical or virtual entity in the ENCLOSURE database schema table.
This table describes an end port within a fabric. Use the FABRIC_ID to associate this end port with a fabric in the FABRIC table. Use the ENCLOSURE_ID to associate this end port with an enclosure in the ENCLOSURE table. Use the HBA_ID to associate this end port with an HBA in the HBA table. Use the PORT_ID to associate this end port with a port in the SWITCH_PORT table. Table 1-16 describes the END_PORT database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Describes the primary key of the entity. |
FABRIC_ID1 |
INTEGER |
— |
Describes the ID of the parent fabric. |
ENCLOSURE_ID2 |
INTEGER |
— |
Describes the ID of the enclosure to which the end port belongs. |
HBA_ID |
INTEGER |
— |
Describes the ID of the HBA to which the end port belongs. |
SWITCH_PORT_ID3 |
INTEGER |
— |
Describes the ID of the switch port that linked to the end port. |
WWN4 |
RAW(8) |
— |
Provides the WWN of the end port. |
NODE_WWN5 |
RAW(100) |
— |
Provides the WWN of the node. |
FICON_PORT_ADDRESS |
RAW(100) |
— |
Describes the FICON address of the end port. |
FLAGS |
INTEGER |
— |
Deprecated. |
SYM_PORT_NAME |
VARCHAR2(256) |
— |
Describes the symbolic name of the end port. |
SYM_NODE_NAME |
VARCHAR2(256) |
— |
Describes the symbolic name of the parent node. |
PORT_IP_ADDR |
VARCHAR2(256) |
— |
Provides the IP address of the parent node. |
ALIAS |
VARCHAR2(256) |
— |
Describes the port alias. |
IS_PRESENT |
NUMBER(1) |
— |
Describes whether the end port exists in any of the VSANs. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Describes the time when last seen, in milliseconds, since 1/1/1970. |
OPER_STATUS_CAUSE |
INTEGER |
— |
Describes if the link is down, the value represents the status. Refer to values for FcIfOperStatusReason in CISCO-FC-FE-MIB. |
IF_NAME |
VARCHAR2(256) |
— |
Describes the interface name of the attached switch port. |
IS_LOOP |
NUMBER(1) |
— |
Describes whether the link is an arbitrated loop. |
FC4_TYPES |
RAW(100) |
— |
Describes the FC4 types of the end port. Refer to values for fcNameServerFC4Type in CISCO-NS-MIB. |
FC4_FEATURES |
INTEGER |
— |
Describes the FC4 features of the end port. Refer to values for fcNameServerFC4Features in CISCO-NS-MIB. |
NAME |
VARCHAR2(256) |
— |
Describes the logical name of the end port. |
VFC_BINDTO |
VARCHAR2(256) |
— |
Describes the VFC (Virtual FC) bind information for end port. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 END_PORT_FABRIC_ID_INDEX is an index based on the column FABRIC_ID. 2 END_PORT_ENCLOSURE_ID_INDEX is an index based on the column ENCLOSURE_ID. 3 END_PORT_SWITCH_PORT_ID_INDEX is an index based on the column SWITCH_PORT_ID. 4 END_PORT_WWN_INDEX is an index based on the column WWN. 5 END_PORT_NODE_WWN_INDEX is an index based on the column NODE_WWN. |
This table describes Performance Manager events. Use the FABRICID to associate this event with a fabric in the FABRIC table. Use the SWITCHID to associate this event with a switch in the SWITCH table. Table 1-17 describes the EVENTS database schema table.
|
|
|
|
---|---|---|---|
EVENTID |
INTEGER |
NOT NULL |
Describes the ID of the event. |
HOST_TIME |
TIMESTAMP |
— |
Describes the host time of the event. |
SWITCH_TIME |
TIMESTAMP |
— |
Describes the switch time of the event. |
TYPE |
INTEGER |
— |
Type of the event. See Table 1-18. |
FACILITY |
VARCHAR2(20) |
— |
Describes the facility for syslog. |
SEVERITY1 |
INTEGER |
— |
Describes the severity of the event: |
SOURCE |
VARCHAR2(256) |
DEFAULT |
Describes the source fabric that generated the event. |
DESCR |
VARCHAR2(4000) |
DEFAULT |
Describes the description of the event. |
SYSLOGEVENT |
VARCHAR2(80) |
— |
Describes the system log events. |
VSANID |
INTEGER |
DEFAULT |
Describes the ID of the VSAN that generated the event. |
FABRICID |
INTEGER |
— |
Describes the ID of the fabric that generated the event. |
SWITCHID |
INTEGER |
— |
Describes the ID of the switch that generated the event. |
SRCID |
INTEGER |
— |
Describes the ID of the source port; applies to Performance Manager events only. |
DESTID |
INTEGER |
— |
Describes the ID of the destination port; applies to Performance Manager events only. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 EVENTS_SEVERITY_INDEX is an index based on the column SEVERITY. |
Table 1-19 describes the event-forward configurations in the EVENT_FORWARD database schema table.
Table 1-20 describes the ethernet switch configurations in the ETHSWITCH database schema table.
Table 1-21 describes the ethernet switch port configurations in the ETHSWITCH_PORT database schema table.
Table 1-22 describes the CDP_SEED configurations in the CDP_SEED database schema table.
Table 1-23 describes the LAN configurations in the LAN database schema table.
Table 1-24 describes the ethernet switch port VLAN configurations in the ETHSWITCH_PORT_VLAN database schema table.
Table 1-25 describes the ethernet isl VLAN configurations in the ETHISL_VLAN database schema table.
Table 1-26 describes a SAN fabric in the FABRIC database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the primary key of the database entry. |
SEED_SWITCH_ID1 |
INTEGER |
— |
Provides the ID of the switch where the fabric discovery originated. |
IVR_SEED_SWITCH_ID2 |
INTEGER |
— |
Provides the ID of the switch where the IVR data originated. |
ALIAS_SEED_SWITCH_ID |
INTEGER |
— |
Provides the ID of the alias switch. |
LICENSE_ID |
INTEGER |
— |
Deprecated. |
IVR_ENF_ZONESET_NAME |
VARCHAR2(256) |
— |
Provides the active IVR zone set name. |
IVR_ENF_ZONESET_ACTIVATE_TIME |
INTEGER |
— |
Provides the time in milliseconds when the IVR zone set is activated. |
IVR_ACTIVE_ZONESET_CHECKSUM |
RAW(100) |
— |
IVR active zone set checksum. |
POLLING_ENABLED |
NUMBER(1) |
— |
Describes the indication of whether the fabric is polled regularly. |
POLLING_INTERVAL |
INTEGER |
— |
Provides the fabric polling interval, in seconds. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds, since 1/1/1970. |
SNMP_RETRIES |
INTEGER |
— |
Provides the number of SNMP retries. |
SNMP_TIMEOUT |
INTEGER |
— |
Provides the SNMP timeout in milliseconds. |
FMUSER_ID |
INTEGER |
— |
Deprecated. |
NAME |
VARCHAR2(256) |
— |
Describes name of the fabric. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
SAN_ID |
INTEGER |
— |
Provides the ID of the parent SAN. |
FID |
INTEGER |
— |
Provides the ID of the fabric. |
IS_PERSISTENT |
NUMBER(1) |
— |
Indicates whether continuous monitoring is enabled. |
ON_DEMAND_POLL_FREQ |
INTEGER |
— |
On-demand polling interval for fabric discovery, in seconds. |
IVR_TOPO_CFG_CHECKSUM |
RAW(100) |
— |
Deprecated. |
IVR_TOPO_ACT_CHECKSUM |
RAW(100) |
— |
Deprecated. |
IVR_TOPO_AFID_CFG_CHECKSUM |
RAW(100) |
— |
Deprecated. |
IVR_TOPO_DEF_AFID_CHECKSUM |
RAW(100) |
— |
Deprecated. |
IVR_TOPO_VALIDATED |
NUMBER(1) |
— |
Deprecated. |
USE_GLOBAL_ALIAS |
NUMBER(1) |
— |
Indicates whether the fabric is set to use the global alias. |
IS_MANAGEABLE |
NUMBER(1) |
— |
Describes whether the fabric is manageable. |
DEVICE_ALIAS_SEED_ID3 |
INTEGER |
— |
Describes the ID of the device alias seed. |
DEVICE_ALIAS_CHECKSUM |
RAW(100) |
— |
Describes the checksum for device alias database in the fabric. |
VSANS_INCLUDED |
VARCHAR2(256) |
— |
Describes the VSANs included from the fabric. |
VSANS_EXLUDED |
VARCHAR2(256) |
— |
Describes the VSANs excluded from the fabric. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 FABRIC_SEED_SWITCH_ID is an index based on the column SEED_SWITCH_ID. 2 FABRIC_IVR_SEED_SWITCH_ID is an index based on the column IVR_SEED_SWITCH_ID. 3 FABRIC_DEVICE_ALIAS_SEED_ID is an index based on the column DEVICE_ALIAS_SEED_ID. |
This table describes the number of failed attempts by users. Table 1-27 describes the FAILED_ATTEMPTS database schema table.
|
|
|
|
---|---|---|---|
USER_NAME1 |
VARCHAR2(256) |
PRIMARY KEY |
Provides the username encrypted for security. |
FAILED_ATTEMPT_TIME |
INTEGER |
PRIMARY KEY |
Describes the failed attempt time of each user. |
1 FAILED_ATTEMPTS_INDEX is an index based on the column USER_NAME. |
This table describes a FICON connection to a switch. Use the PORT_ID to associate this FICON connection to a port in the SWITCH_PORT table. Table 1-28 describes the FICON_INFO database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the interface ID. |
VENDOR |
VARCHAR2(256) |
— |
Provides the name of the company that manufactured the peer node. |
TYPE_NUM |
VARCHAR2(256) |
— |
Provides the type number of the peer node. |
MODEL_NUM |
VARCHAR2(256) |
— |
Provides the model number of the peer node. |
SERIAL_NUM |
VARCHAR2(256) |
— |
Provides the sequence number assigned to the peer node during manufacturing. |
PORT_ID1 |
VARCHAR2(256) |
— |
Provides the identifier of the port in the peer node connected to this port. If the peer node is a control unit, this value will be 0. If the peer node is a channel, this value will be the channel path identifier of the channel path that contains the port in the peer node. If the peer node is a fabric, this value will be the port address of the port in peer node. Refer to CISCO-FC-FE-MIB for more information. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR |
— |
Deprecated. |
1 FICON_PORT_ID_INDEX is an index based on the column PORT_ID. |
This table describes a Fabric Manager user. Table 1-29 describes the FMUSER database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the Fabric Manager user. |
USER_NAME1 |
VARCHAR2(256) |
— |
Provides the username encrypted for security. |
AUTH_PASSWORD |
VARCHAR2(256) |
— |
Provides the authentication password encrypted for security. |
ROLE_NAME |
VARCHAR2(256) |
— |
Describes the User role name; can be either network administrator or operator. |
IS_LOGGING_IN |
NUMBER(1) |
— |
Provides the login status of the user. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
1 FMUSER_USERNAME_INDEX is an index based on the column USER_NAME. |
This table describes the Fabric Manager user session. Table 1-30 describes the FMSESSION database schema table.
This table describes a Fabric Manager group within a fabric. Use the FABRIC_ID to associate this group to a fabric in the FABRIC table. Table 1-31 describes the GROUPS database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the group. |
FABRIC_ID1 |
INTEGER |
— |
Provides the ID of the fabric to which the group belongs. |
NAME1 |
VARCHAR2(256) |
— |
Describes the name of the group. |
TYPE |
INTEGER |
— |
Type of the group: |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
1 GROUP_FABRICID_NAME_INDEX is an index based on the columns FABRIC_ID and NAME. |
This table describes the mapping between the user-defined logical groups and fabrics. Table 1-32 describes the GROUP_FABRIC_INFO database schema table.
|
|
|
|
---|---|---|---|
GROUP_ID1 |
INTEGER |
NOT NULL |
Provides the ID of the group. |
FABRIC_ID2 |
INTEGER |
NOT NULL |
Provides the ID of the fabric to which the group belongs. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
1 GROUP_FABRIC_GROUP_ID is an index based on the column GROUP_ID. 2 GROUP_FABRIC_FABRIC_ID is an index based on the column FABRIC_ID. |
This table describes a member of a group. Use the GROUP_ID to associate this member to a group. Use the MEMBER_ID to reference an ID in a SWITCH or END_PORT table. Table 1-33 describes the GROUP_MEMBER_INFO database schema table.
|
|
|
|
---|---|---|---|
GROUP_ID1 |
INTEGER |
NOT NULL |
Provides the ID of the group. |
MEMBER_ID2 |
INTEGER |
NOT NULL |
Provides the ID of the group member, which is a switch or an end port ID. |
TYPE |
INTEGER |
— |
Describes the type of the group member: |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
1 GROUP_MEMBER_GROUP_ID is an index based on the column GROUP_ID. 2 GROUP_MEMBER_MEMBER_ID is an index based on the column MEMBER_ID. |
This table describes a user of a group. Table 1-34 describes the GROUP_MEMBER_INFO database schema table.
|
|
|
|
---|---|---|---|
GROUP_ID1 |
INTEGER |
NOT NULL |
Provides the ID of the group. |
FMUSER_ID2 |
INTEGER |
NOT NULL |
Describes the Fabric Manager user ID for each user. |
LAST_UPDATE_TIME |
TIMESTAMP |
Provides the time when the entry was updated. |
1 GROUP_USER_GROUP_ID is an index based on the column GROUP_ID. 2 GROUP_USER_FMSUER_ID is an index based on the column FMUSER_ID. |
This table associates a WWN to a host bus adapter. Use the ENCLOSURE_ID to associate each HBA to an enclosure in the ENCLOSURE table. Table 1-35 describes the HBA database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the HBA. |
ENCLOSURE_ID1 |
INTEGER |
— |
Provides the ID of the parent enclosure. |
HWWN2 |
RAW(8) |
— |
Describes the HBA WWN, one of its port WWNs. |
NWWN3 |
RAW(8) |
— |
Describes the node WWN. |
TYPE |
SMALLINT |
— |
Deprecated. |
MANUFACTURER |
VARCHAR2(256) |
— |
Provides the manufacturer name. |
SERIAL_NUMBER |
VARCHAR2(256) |
— |
Provides the serial number of the HBA. |
MODEL |
VARCHAR2(256) |
— |
Provides the model of the HBA. |
MODEL_DESCRIPTION |
VARCHAR2(256) |
— |
Provides the model description of the HBA. |
HW_VERSION |
VARCHAR2(256) |
— |
Provides the hardware version. |
SW_VERSION |
VARCHAR2(256) |
— |
Provides the firmware version. |
DRIVER_VERSION |
VARCHAR2(256) |
— |
Provides the driver version. |
OPT_ROM_VERSION |
VARCHAR2(256) |
— |
Optional ROM version. |
OS |
VARCHAR2(256) |
— |
Deprecated. |
IP_ADDRESS |
VARCHAR2(256) |
— |
Provides the IP address of the HBA. |
IS_PRESENT |
NUMBER(1) |
— |
Indicates whether the HBA exists. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
STATUS |
INTEGER |
— |
Deprecated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 HBA_ENCLOSURE_ID_INDEX is an index based on the column ENCLOSURE_ID. 2 HBA_HWWN_INDEX is an index based on the column HWWN. 3 HBA_NWWN_INDEX is an index based on the column NWWN. |
This table provides the power and status indications for a hardware component. Use the HW_COMPONENT_ID to associate each row to a hardware component in the HW_COMPONENT table. Table 1-36 describes the HW_CARD database schema table.
|
|
|
|
---|---|---|---|
HW_COMPONENT_ID |
INTEGER |
NOT NULL |
Provides the ID of the entry in HW_COMPONENT table. |
MODEL_TYPE |
INTEGER |
— |
Provides the model type of the card. See Table 1-37. |
ADMIN_STATUS |
INTEGER |
— |
Describes the administrative status of the card: |
OPER_STATUS |
INTEGER |
— |
Provides the operational status of the card. See Table 1-38. |
RESET_REASON |
VARCHAR2(256) |
— |
Provides the reset reason for the card. |
STATUS_LAST_CHANGE_TIME |
INTEGERs |
— |
Provides the last status change time in hundredths of seconds. |
POWER_ADMIN_STATUS |
INTEGER |
— |
Describes the administrative status of the power for the card: |
POWER_OPER_STATUS |
INTEGER |
— |
Describes the operational status of the power for the card: |
POWER_CURRENT |
INTEGER |
— |
Describes the current measurement on the system power supply primary output. The range is from -1.0 x 106 A to 1.0 x 106 A. A negative value expresses the current used by the FRU. A positive value expresses the current supplied by the FRU. |
DMM_STATE |
INTEGER |
— |
Describes whether the module is capable on DMM (data migration). |
This table describes the hardware components of a switch, including the model number, the manufacturer, and the revision. Use the SWITCH_ID to associate each hardware component to a switch in the SWITCH table. Table 1-39 describes the HW_COMPONENT database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the hardware component. |
SWITCH_ID1 |
INTEGER |
— |
Provides the ID of the parent switch. |
NAME |
VARCHAR2(256) |
— |
Describes the name of the hardware component. |
PHYSICAL_INDEX |
INTEGER |
— |
Describes the value that when combined with the switch card offset yields the relative slot number. |
RELATIVE_POSITION |
INTEGER |
— |
Describes the relative position of the hardware component; for a card, it is the slot number. |
HW_TYPE |
INTEGER |
— |
Describes the type of the hardware component: |
VENDOR_TYPE |
RAW(200) |
— |
Provides the vendor type of the hardware component. |
HW_REVISION |
VARCHAR2(256) |
— |
Provides the hardware revision of the hardware component. |
FW_REVISION |
VARCHAR2(256) |
— |
Provides the firmware revision of the hardware component. |
SW_REVISION |
VARCHAR2(256) |
— |
Provides the software revision of the hardware component. |
SERIAL_NUMBER |
VARCHAR2(256) |
— |
Provides the serial number of the hardware component. |
MANUFACTURER |
VARCHAR2(256) |
— |
Provides the manufacturer of the hardware component. |
MODEL_NAME |
VARCHAR2(256) |
— |
Provides the model name of the hardware component. |
ASSET_ID |
VARCHAR2(256) |
— |
Provides the asset ID of the hardware component. |
STATUS_DESCRIPTION |
VARCHAR2(256) |
— |
Provides the status description of the hardware component. |
SEC_SERIAL_NUMBER |
VARCHAR2(256) |
Provides the secondary serial number of the hardware component. |
|
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds, since 1/1/1970. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
1 HW_COMPONENT_SWITCH_ID is an index based on the column SWITCH_ID. |
This table provides the status on power supplies in an enclosure. Use the HW_COMPONENT_ID to associate an entry with a hardware component in the HW_COMPONENT table. Table 1-40 describes the HW_POWER_SUPPLY database schema table.
This table describes an ISL that links two ports. Use the PORT1_ID and the PORT2_ID to associate these ports to a port in the SWITCH_PORT table. If this ISL is a PortChannel member, the CHANNEL_ID refers to the parent channel ID. Table 1-41 describes the ISL database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the ISL entry in the table. |
PORT1_ID1 |
INTEGER |
— |
Provides the ID of port1 (the port with smaller WWN). |
PORT2_ID2 |
INTEGER |
— |
Provides the ID of port2. |
OPER_MODE |
SMALLINT |
— |
Describes the operational mode of the link by port type: |
IS_PRESENT |
NUMBER(1) |
— |
Indicates whether the ISL is present in the current fabric. |
STATUS |
SMALLINT |
— |
Deprecated. |
OPER_STATUS_CAUSE |
INTEGER |
— |
Describes if OPER_MODE is MODE_DOWN, the value is the down status. |
OPER_STATUS_DESCRIPTION |
VARCHAR2(256) |
— |
Describes if OPER_MODE is MODE_DOWN, the value is the down status description. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds since 1/1/1970. |
CHANNEL_CONFIG_CHILD_COUNT |
INTEGER |
— |
Provides the configured PortChannel member count. |
CHANNEL_CURRENT_CHILD_COUNT |
INTEGER |
— |
Provides the PortChannel member count. |
AUTO_CREATED |
NUMBER(1) |
— |
Indicates whether the entry was automatically created. |
IS_CHANNELMEMBER3 |
NUMBER(1) |
— |
Indicates whether the ISL is a PortChannel member. |
CHANNEL_ID |
INTEGER |
— |
Describes when the ISL is a PortChannel member, the parent channel ID. |
IF_INDEX_1 |
INTEGER |
— |
IF index of the switch port at one end. |
IF_INDEX_2 |
INTEGER |
— |
IF index of the switch port at the other end. |
FICON_ADDRESS_1 |
INTEGER |
— |
Provides the FICON address of the switch port at one end. |
FICON_ADDRESS_2 |
INTEGER |
— |
Provides the FICON address of the switch port at the other end. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 ISL_P1_INDEX is an index based on the column PORT1_ID. 2 ISL_P2_INDEX is an index based on the column PORT2_ID. 3 ISL_CHANNELMEMBER is an index based on the column IS_CHANNELMEMBER. |
This table describes licenses configured and in use in a switch. Use the SWITCH_ID to associate each entry to a switch in the SWITCH table. Table 1-42 describes the LICENSE database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the license. |
SWITCH_ID1 |
INTEGER |
— |
Provides the ID of the switch where the license was installed. |
FEATURE_NAME |
VARCHAR2(256) |
— |
Provides the name of the license. |
TYPE |
INTEGER |
— |
Deprecated. |
LICENSE_FLAG |
RAW(100) |
— |
Provides the license flag that indicates the type of the license: |
MAX_LICENSE |
INTEGER |
— |
Describes the maximum number of licenses. |
MISSING_LICENSE |
INTEGER |
— |
Describes the number of missing licenses. |
CURRENT_LICENSE |
INTEGER |
— |
Describes the number of current licenses. |
EXPIRE |
INTEGER |
— |
Describes the expiration time of the license, in milliseconds. |
GRACE_PERIOD |
INTEGER |
— |
Describes the grace period of the license, in seconds. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
RESERVE_COL1 |
VARCHAR29256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 LICENSE_SWITCH_ID_INDEX is an index based on the column SWITCH_ID. |
This table describes a configured NTOP enity. Table 1-43 describes the NTOP database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Describes the ID of the entry. |
IP_ADDR1 |
VARCHAR2(256) |
— |
Describes the switch IP address. |
PORT_NUMBER2 |
INTEGER |
— |
Describes the switch port number. |
LAST_SCAN_TIME |
INTEGER |
— |
Describes the time when last seen, in milliseconds, since 1/1/1970. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
1 NTOP_IP_INDEX is an index based on the column IP_ADDR. 2 NTOP_PORT_INDEX is an index based on the column PORT_NUMBER. |
This table associates an NTOP entity with a SPAN port. Use the SPAN_PORT_ID to associate an entry with a SPAN port in the SPAN_PORT table. Table 1-44 describes the NTOP_SPAN_INFO database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Describes the ID of the entry. |
NTOP_ID1 |
INTEGER |
— |
Describes the foreign key to the NTOP table. |
SPAN_PORT_ID2 |
INTEGER |
— |
Describes the foreign key to the SPAN_PORT table. |
ETH_NAME |
VARCHAR29256) |
— |
Describes the Ethernet port name. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
1 NTOP_SPAN_NTOPID_INDEX is an index based on the column NTOP_ID. 2 NTOP_SPAN_SPANID_INDEX is an index based on the column SPAN_PORT_ID. |
This table describes the Nport virtualization link information.Table 1-45 describes the NPV_LINK database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the entry in the table. |
CORE_SWITCH_ID |
INTEGER |
— |
Provides the ID of the core switch. |
NP_SWITCH_ID |
INTEGER |
— |
Provides the ID of the NP switch. |
F_PORT_INDEX1 |
INTEGER |
— |
Provides the index of the F port. |
NP_PORT_INDEX2 |
INTEGER |
— |
Provides the index of the NP port. |
F_WWN |
RAW(8) |
— |
Provides the world wide name for log in device F port. |
NP_WWN |
RAW(8) |
— |
Provides the world wide name for log in device NP port. |
OPER_STATUS_CAUSE |
INTEGER |
— |
Describes the operation status cause. |
SPEED |
INTEGER |
— |
Describes the speed. |
IS_PRESENT |
NUMBER(1) |
— |
Describes whether the link is present. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds, since 1/1/1970. |
CHANNEL_CONFIG_CHILD_COUNT |
INTEGER |
— |
Describes the number of child counts. |
CHANNEL_CURRENT_CHILD_COUNT |
INTEGER |
— |
Describes the number of current child counts of the channel. |
AUTO_CREATED |
NUMBER(1) |
— |
Describes whether the NPV link is autocreated. |
IS_CHANNELMEMBER |
NUMBER(1) |
— |
Describes whether the link is channel member. |
CHANNEL_ID |
INTEGER |
— |
Provides the ID of the channel. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 NPV_LINK_FP_INDEX is an index based on the column F_PORT_INDEX. 2 NPV_LINK_NPP_INDEX is an index based on the column NP_PORT_INDEX. |
This table maintains the logical-to-physical mapping of RRD files. Table 1-46 describes the PMDATAINDEX database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
— |
Provides the ID of the entry. |
LOGICALFILENAME1 |
VARCHAR2(256) |
— |
Provides the logical RRD filename. |
FILETYPE |
INTEGER |
— |
File type has one of the following values: |
DATAINDEX |
INTEGER |
— |
Provides the RRD data source index. |
PHYSICLFILEINDEX |
INTEGER |
— |
Provides the physical file index. |
1 PMDATAINDEX_LOGICALFILE_INDEX is an index based on the column LOGICALFILENAME. |
This table defines object IDs and switch IPs for the Performance Manager data collection. Table 1-47 describes the PMEXTRAOID database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the record ID. |
FID1 |
INTEGER |
— |
Provides the fabric ID. |
NAME |
VARCHAR2(256) |
— |
Provides the Performance Manager object ID. |
DISPLAYNAME |
VARCHAR2(256) |
— |
Displays the name used in Web Client. |
SWITCHIP |
VARCHAR2(256) |
— |
Provides the IP address of the switch. |
TYPE |
VARCHAR2(256) |
— |
RRD data source type has one of the following character values: |
SWITCHNAME |
VARCHAR2(256) |
— |
Describes the switch name. |
1 PMEXTRAOID_FABRIC_ID_INDEX is an index based on the column FID. |
This table maintains the current bookmark index of the RRD files. Table 1-48 describes the PMINDEXBOOKMARK database schema table.
This table describes a Performance Manager collection. Use the FABRIC_ID to associate this collection to a fabric in the FABRIC table. Table 1-49 describes the PM_COLLECTION database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the entry. |
FABRIC_ID1 |
INTEGER |
— |
Provides the fabric ID; foreign key to a fabric table. |
VSAN_LIST |
VARCHAR2(256) |
— |
Provides the list of VSANs; for example, "1,5,6,4001". |
MONITOR_ISL |
NUMBER(1) |
— |
Describes whether to collect ISL PM for the fabric. |
MONITOR_HOST |
NUMBER(1) |
— |
Describes whether to collect host PM for the fabric. |
MONITOR_STORAGE |
NUMBER(1) |
— |
Describes whether to collect storage PM for the fabric. |
MONITOR_FLOW |
NUMBER(1) |
— |
Describes whether to collect flow PM for the fabric. |
MONITOR_GIGE |
NUMBER(1) |
— |
Describes whether to collect gigabit Ethernet port PM for the fabric. |
MONITOR_OTHER |
NUMBER(1) |
— |
Describes whether to collect other customized PM for the fabric. |
TRAFFIC_THRESHOLD_ENABLE |
NUMBER(1) |
— |
Describes whether threshold checking on traffic is enabled. |
EVENT_THRESHOLD |
NUMBER(1) |
— |
Describes whether threshold checking on event is enabled. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
1 PM_POLICY_FABRIC_ID_INDEX is an index based on the column FABRIC_ID. |
This table provides threshold details for a Performance Manager collection. Use the ID to associate these details with a Performance Manager collection in the PM_COLLECTION table. Table 1-50 describes the PM_OPTION database schema table.
This table describes the available role types for each user. Table 1-51 describes the ROLE database schema table.
|
|
|
|
---|---|---|---|
ROLE_NAME |
VARCHAR2(256) |
NOT NULL |
Describes the role name of the user. |
DESCRIPTION |
VARCHAR2(256) |
Describes each users role. |
This table describes the role types associated with each fabric and also describes the time when it was last updated. Table 1-52 describes the ROLE_FABRIC_INFO database schema table.
This table provides the WWN for a SCSI target. Use the ID to associate this SCSI target to a port in the SWITCH_PORT table. Table 1-53 describes the SCSI_TARGET database schema table.
This table describes the current long values for automatically generated IDs. Table 1-54 describes the SEQUENCE database schema table.
|
|
|
|
---|---|---|---|
ID |
SMALLINT |
NOT NULL |
Provides the catalog of IDs. |
VALUE |
INTEGER |
— |
Describes the starting value of database IDs. |
This table describes the SME settings information.Table 1-55 describes the SME_SETTINGS database schema table.
|
|
|
|
---|---|---|---|
NAME |
VARCHAR2(64) |
NOT NULL |
Provides the name of the SME. |
VALUE |
VARCHAR2(64) |
— |
Describes the SME settings value. |
This table describes the SME cluster information. Table 1-56 describes the SME_CLUSTER database schema table.
This table describes the SME cluster attributes information. Table 1-57 describes the SME_CLUSTER_ATTRIBUTES database schema table.
This table describes the SME cluster SmartCard information.Table 1-58 describes the SME_CLUSTER_SMARTCARD database schema table.
This table describes the SME tape group information.Table 1-59 describes the SME_TAPE_GROUP database schema table.
This table describes the SME tape volumegroup information.Table 1-60 describes the SME_TAPE_VOLUMEGROUP database schema table.
This table describes the SME key information.Table 1-61 describes the SME_KEY database schema table.
|
|
|
|
---|---|---|---|
GUID |
VARCHAR2(64) |
NOT NULL |
Provides the global unique ID for the key. |
CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL |
Provides the name of the cluster. |
CLONED_FROM_GUID1 |
VARCHAR2(64) |
— |
Describes whether this is a clone. |
CLUSTER_ID |
VARCHAR2(64) |
— |
ID of the cluster. |
STATUS |
INTEGER |
— |
Describes the status of the key. |
KEY_TYPE |
INTEGER |
— |
Describes the key type of the SME. |
ENTITY_INDEX2 |
VARCHAR2(256) |
— |
Describes the entity index. |
VERSION |
INTEGER |
— |
Provides the version of the SME. |
WRAP_BY_GUID |
VARCHAR2(64) |
— |
Describes the value wrapped by GUID. |
KEY_DAT |
VARCHAR2(2048) |
— |
Describes the key data. |
MASTER_KEY_GUID |
VARCHAR2(64) |
— |
Describes the master key GUID. |
CREATION_TIME |
TIMESTAMP |
— |
Provides the SME creation time. |
ARCHIVAL_TIME |
TIMESTAMP |
— |
Provides the SME archival time. |
1 SME_KEY_CLONED_FROM_GUID_INDEX is an index based on the column CLONED_FROM_GUID. 2 SME_KEY_ENTITY_INDEX is an index based on the column ENTITY_INDEX. |
This table describes the SME accounting log information. Table 1-62 describes the SME_ACCOUNTING_LOG database schema table.
This table describes the SME replication release.Table 1-63 describes the SME_REPLICATION_REL database schema table.
This table describes the SME replication key information.Table 1-64 describes the SME_REPL_PENDING_KEY database schema table.
This table describes the SME replication information.Table 1-65 describes the SME_REPL_ERROR_KEY database schema table.
This table describes an SNMP community. Table 1-66 describes the SNMP_COMMUNITY database schema table.
This table describes an SNMP user. Table 1-67 describes the SNMPUSER database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the SNMP user. |
VERSION |
INTEGER |
— |
Version of the SNMP user: |
USER_NAME1 |
VARCHAR2(256) |
— |
For SNMPv3, the name of the SNMP user. For SNMPv1 or SNMPv2, the community string. |
AUTH_PASSWORD |
VARCHAR2(256) |
— |
Password of the SNMP user; applies to SNMPv3 only. |
PRIV_PASSWORD |
VARCHAR2(256) |
— |
Deprecated. |
AUTH_PROTOCOL |
INTEGER |
— |
Deprecated. |
PRIV_PROTOCOL |
INTEGER |
— |
Deprecated. |
SECURITY_NAME |
VARCHAR2(256) |
— |
Security name of the SNMP user. |
ROLE_NAME |
VARCHAR2(256) |
— |
Describes the role of the SNMP user. |
IS_LOGGING_IN |
NUMBER(1) |
— |
Deprecated. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 SNMPUSER_USERNAME_INDEX is an index based on the column USER_NAME. |
This table escribes a SPAN port on a switch. Use the SWITCH_ID to associate this SPAN port to a switch in the SWITCH table. Table 1-68 describes the SPAN_PORT database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Describes the ID of the entry. |
IF_INDEX1 |
INTEGER |
— |
Describes the IF index value of the port. |
SWITCH_ID2 |
INTEGER |
— |
Describes the ID of the parent switch. |
LAST_SCAN_TIME |
INTEGER |
— |
Deprecated. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
1 SPANPORT_IFINDEX_INDEX is an index based on the column IF_INDEX. 2 SPANPORT_SWITCH_ID_INDEX is an index based on the column SWITCH_ID. |
This table escribes a SPAN session. Use the SPAN_PORT_ID to associate this session to a SPAN port in the SPAN_PORT table. Table 1-69 describes the SPAN_SESSION database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Describes the ID of the entry. |
SESSION_ID1 |
INTEGER |
— |
Describes the ID of session. |
SPAN_PORT_ID2 |
INTEGER |
— |
Describes the foreign key to the SPAN_PORT. |
OPER_STATUS |
INTEGER |
— |
Operation status: |
VSAN_FILTER |
VARCHAR2(256) |
— |
List of VSAN filters, for example, "1,3,5". |
VSAN_SOURCE |
VARCHAR2(256) |
— |
List of VSAN sources, for example, "1,3,5". |
LAST_SCAN_TIME |
INTEGER |
— |
Deprecated. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
1 SPANSESSION_SESSION_ID_INDEX is an index based on the column SESSION_ID. 2 SPANSESSION_SPANPORT_ID_INDEX is an index based on the column SPAN_PORT_ID. |
This table describes a SPAN source port. Use the SESSION_ID to associate this source port to a SPAN session in the SPAN_SESSION table. Table 1-70 describes the SPAN_SOURCE_PORT database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Describes the ID of the entry. |
IF_INDEX1 |
INTEGER |
— |
Describes the interface index of the port. |
DIRECTION |
INTEGER |
— |
Direction: |
SESSION_ID2 |
INTEGER |
— |
Session ID; foreign key to the SPAN_SESSION. |
LAST_SCAN_TIME |
INTEGER |
— |
Describes the time when last seen, in milliseconds since 1/1/1970. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
1 SPANSOURCEPORT_IFINDEX_INDEX is an index based on the column IF_INDEX. 2 SPANSOURCEPORT_SESSION_ID_INDEX is an index based on the column SESSION_ID. |
This table provides statistics gathered for a Performance Manager collection. Table 1-71 describes the STATISTICS database schema table.
|
|
|
|
---|---|---|---|
SRC_ID |
INTEGER |
PRIMARY KEY |
Describes the ID of the source port entry in the SWITCH_PORT table or the END_PORT table. |
DEST_ID1 |
INTEGER |
PRIMARY KEY |
Describes the ID of the destination port entry in SWITCH_PORT or END_PORT table. |
TYPE |
SMALLINT |
— |
Type of the statistic: |
RRD_FILE |
VARCHAR2(256) |
— |
Describes the RRD filename for the entity. |
XML_FILE |
VARCHAR2(256) |
— |
Describes the XML filename for the entity. |
CAPACITY |
INTEGER |
— |
Interface speed of the entity in bytes per second. |
AVG_RX |
BINARY_DOUBLE |
— |
Describes the average number of bytes received per second for the last day. |
AVG_TX |
BINARY_DOUBLE |
— |
Describes the average number of bytes transmitted per second for the last day. |
TOTAL_RXTX |
BINARY_DOUBLE |
— |
Describes the total number of bytes received and transmitted for the last day. |
MAX_RX |
BINARY_DOUBLE |
— |
Describes the peak number of bytes received for the last day. |
MAX_TX |
BINARY_DOUBLE |
— |
Peak number of bytes transmitted for the last day. |
TOTAL_ERR |
BINARY_DOUBLE |
— |
Describes the total number of errors for the last day. |
TOTAL_DISCARD |
BINARY_DOUBLE |
— |
Describes the total number of discards for the last day. |
LAST_WEEK_AVG_RX |
BINARY_DOUBLE |
— |
Average number of bytes received per second for the last week. |
LAST_WEEK_AVG_TX |
BINARY_DOUBLE |
— |
Average number of bytes transmitted per second for the last week. |
LAST_WEEK_TOTAL_RXTX |
BINARY_DOUBLE |
— |
Describes the total number of bytes received and transmitted for the last week. |
LAST_WEEK_MAX_RX |
BINARY_DOUBLE |
— |
Peak number of bytes received for the last week. |
LAST_WEEK_MAX_TX |
BINARY_DOUBLE |
— |
Peak number of bytes transmitted for the last week. |
LAST_WEEK_TOTAL_ERR |
BINARY_DOUBLE |
— |
Describes the total number of errors for the last week. |
LAST_WEEK_TOTAL_DISCARD |
BINARY_DOUBLE |
— |
Describes the total number of discards for the last week. |
LAST_MONTH_AVG_RX |
BINARY_DOUBLE |
— |
Average number of bytes received per second for the last month. |
LAST_MONTH_AVG_TX |
BINARY_DOUBLE |
— |
Average number of bytes transmitted per second for the last month. |
LAST_MONTH_TOTAL_RXTX |
BINARY_DOUBLE |
— |
Total number of bytes received and transmitted for the last month. |
LAST_MONTH_MAX_RX |
BINARY_DOUBLE |
— |
Peak number of bytes received for the last month. |
LAST_MONTH_MAX_TX |
BINARY_DOUBLE |
— |
Peak number of bytes transmitted for the last month. |
LAST_MONTH_TOTAL_ERR |
BINARY_DOUBLE |
— |
Total number of errors for the last month. |
LAST_MONTH_TOTAL_DISCARD |
BINARY_DOUBLE |
— |
Total number of discards for the last month. |
LAST_YEAR_AVG_RX |
BINARY_DOUBLE |
— |
Average number of bytes received per second for the last year. |
LAST_YEAR_AVG_TX |
BINARY_DOUBLE |
— |
Average number of bytes transmitted per second for the last year. |
LAST_YEAR_TOTAL_RXTX |
BINARY_DOUBLE |
— |
Total number of bytes received and transmitted for the last year. |
LAST_YEAR_MAX_RX |
BINARY_DOUBLE |
— |
Peak number of bytes received for the last year. |
LAST_YEAR_MAX_TX |
BINARY_DOUBLE |
— |
Peak number of bytes transmitted for the last year. |
LAST_YEAR_TOTAL_ERR |
BINARY_DOUBLE |
— |
Total number of errors for the last year. |
LAST_YEAR_TOTAL_DISCARD |
BINARY_DOUBLE |
— |
Total number of discards for the last year. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
LAST_THRESHOLD_EVENT_TIME |
TIMESTAMP |
— |
Last threshold event receive time. |
THRESHOLD_EVENT_COUNT |
SMALLINT |
— |
Threshold event count. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 STATISTICS_DEST_ID is an index based on the column DEST_ID. |
This table provides the sWWN and fabric ID for a switch. Use the FABRIC_ID to associate each switch to a fabric in the FABRIC table. Table 1-72 describes the SWITCH database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the switch entry in the switch table. |
FABRIC_ID1 |
INTEGER |
— |
Provides the ID of the parent fabric entry in fabric table. |
LICENSE_ID |
INTEGER |
— |
Deprecated. |
WWN2 |
RAW(8) |
— |
Provides the WWN of the switch. |
IP_ADDRESS3 |
RAW(100) |
— |
Provides the IP address of the switch. |
IS_MDS |
NUMBER(1) |
— |
Indicates whether the switch is an MDS switch. |
TYPE |
INTEGER |
— |
Model type of the switch; applies to MDS switches only. See Table 1-73. |
IS_MANAGABLE |
NUMBER(1) |
— |
Indicates whether the switch is manageable. |
UNMANAGABLE_CAUSE |
VARCHAR2(256) |
— |
Describes the reason why the switch is unmanageable. |
NON_MDS_MODEL |
VARCHAR2(256) |
— |
Model name for a non-MDS switch. |
SYS_NAME |
VARCHAR2(256) |
— |
Provides the system name. |
SYS_CONTACT |
VARCHAR2(256) |
— |
Provides the system contact information. |
SYS_LOCATION |
VARCHAR2(256) |
— |
Provides the system location information. |
SYS_UPTIME |
INTEGER |
— |
Provides the system uptime in hundredths of seconds. 0 indicates system down. |
ACTIVE_SUP_SLOT |
INTEGER |
— |
Provides the active supervisor slot number. |
STANDBY_SUP_STATE |
INTEGER |
— |
Status of the standby supervisor: |
CONN_UNIT_STATUS |
INTEGER |
— |
Connection unit status: |
FEATURE_FLAG |
INTEGER |
— |
Licensed features. Refer to CISCO-FEATURE-CONTROL-MIB for details. |
FEATURES_STRING |
VARCHAR2(256) |
— |
Describes the feature flag value in string format. |
IS_LICENSE_VIOLATION |
NUMBER(1) |
— |
Indicates whether the switch has a license violation. |
VERSION |
VARCHAR2(256) |
— |
Version of the switch. |
IS_PRESENT |
NUMBER(1) |
— |
Indicates whether the switch is present. |
SERIAL_NUMBER |
VARCHAR2(256) |
— |
Serial number of the switch. |
NUM_PORTS |
INTEGER |
— |
Number of Fibre Channel ports in the switch. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Time when last seen, in milliseconds, since 1/1/1970. |
IS_TRAP_REGISTERED |
NUMBER(1) |
— |
Indication of whether the trap receiver is registered in the switch. |
IS_SYSLOG_REGISTERED |
NUMBER(1) |
— |
Indicate whether the syslog receiver is registered in the switch. |
SYS_DESCRIPTION |
VARCHAR2(256) |
— |
Deprecated. |
VENDOR |
VARCHAR2(256) |
— |
Deprecated. |
FCFE_MODULE_ID |
INTEGER |
— |
Deprecated. |
STANDBY_SUP_SLOT |
INTEGER |
— |
Slot number of the standby supervisor card. |
MODULE_INDEX_OFFSET |
INTEGER |
— |
Module index offset. |
OPER_MODE |
INTEGER |
— |
Describes the operation mode. |
RESERVE_COL1 |
VARCHAR |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR |
— |
Deprecated. |
1 SWITCH_FABRIC_ID is an index based on the column FABRIC_ID. 2 SWITCH_WWN_INDEX is an index based on the column WWN. 3 SWITCH_IP_INDEX is an index based on the column IP_ADDRESS. |
This table provides the switch management port IP address. Use the SWITCH_ID to associate each entry to a switch in the SWITCH table. Table 1-74 describes the SWITCH_MGMT_ADDRESS database schema table.
|
|
|
|
---|---|---|---|
SWITCH_ID1 |
INTEGER |
NOT NULL |
Provides the ID of the switch. |
MGMT_ADDRESS |
RAW(100) |
— |
Provides the management IP address. |
MGMT_TYPE |
NUMBER(4) |
— |
Deprecated. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
1 SWITCH_MGMT_ADDRESS_ID_INDEX is an index based on the column SWITCH_ID. |
This table ssociates an SNMP ifIndex and pWWN to a port. Use the SWITCH_ID to associate each entry to a switch in the SWITCH table. Table 1-75 describes the SWITCH_PORT database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the primary key of the database entry. |
IF_INDEX |
INTEGER |
— |
Interface index of the port. |
SWITCH_ID1 |
INTEGER |
— |
Provides the ID of the parent switch. |
WWN |
RAW(8) |
— |
WWN of the port. |
FICON_PORT_ADDRESS |
RAW(100) |
— |
FICON address. |
IS_HUB |
NUMBER(1) |
— |
Indication of whether the port is a hub. |
IS_CHANNEL |
NUMBER(1) |
— |
Indication of whether the port belongs to a PortChannel. |
CHANNEL_ID2 |
INTEGER |
— |
PortChannel ID. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
STATUS |
SMALLINT |
— |
Status of the port. Refer to CISCO-FC-FE-MIB for details. |
IS_SPAN |
NUMBER(1) |
— |
Deprecated. |
PORT_GROUP |
INTEGER |
— |
Port group calculated from the port index; applies only to a 32-port card. |
SLOT |
SMALLINT |
— |
Describes the slot number. |
IF_SPEED |
INTEGER |
— |
Port speed in bits per second. |
IF_NAME |
VARCHAR2(256) |
— |
Port interface name. |
IF_TYPE |
INTEGER |
— |
Port interface type. Refer to values for IANAifType in IANAifType-MIB. |
PARENT |
INTEGER |
— |
Parent. |
CLUSTER_ID |
VARCHAR2(256) |
— |
Describes the cluster ID. |
SME_STATE |
INTEGER |
— |
Describes the SME state. |
IOA_STATE |
INTEGER |
— |
Describes the IOA state. |
IF_CONNTYPE |
INTEGER |
— |
Describes the interface connection type. |
IF_DESCR |
VARCHAR2(256) |
— |
Describes the interface description. |
RESERVE_COL1 |
VARCHAR |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR |
— |
Deprecated. |
1 SWITCH_PORT_SWITCH_ID_INDEX is an index based on the column SWITCH_ID. 2 SWITCH_PORT_CHANNEL_ID_INDEX is an index based on the column CHANNEL_ID. |
This table describes the server properties. Table 1-76 describes the SVR_PROP database schema table.
|
|
|
|
---|---|---|---|
KEY |
VARCHAR2(256) |
PRIMARY KEY |
Describes the server property. |
VALUE |
VARCHAR2(256) |
Describes the server property value. |
This table describes the user of a fabric. Table 1-77 describes the USERFABRIC_INFO database schema table.
This table describes the user switch information.Table 1-78 describes the USERSWITCH_INFO database schema table.
This table describes a VSAN within a fabric. Use the FABRIC_ID to associate this VSAN with a fabric in the FABRIC table. Table 1-79 describes the VSAN database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the entry in the table. |
NAME |
VARCHAR2(256) |
— |
Provides the name of the VSAN. |
IS_UP |
NUMBER(1) |
— |
Indicates whether the VSAN is up. |
IS_DISJOINT |
NUMBER(1) |
— |
Indicates whether the VSAN is segmented. |
SEED_SWITCH_ID |
INTEGER |
— |
Provides the ID of the seed switch. |
ENF_ZONESET_NAME |
VARCHAR2(256) |
— |
Active zone set name. |
ENF_ZONESET_ACTIVATE_TIME |
INTEGER |
— |
Provides the time in milliseconds when the zone set is activated. |
FABRIC_ID1 |
INTEGER |
— |
Provides the parent fabric ID. |
VSAN_ID1, 2 |
INTEGER |
— |
Provides the VSAN ID. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
PRINCIPAL_SWWN |
RAW(100) |
— |
WWN of the principal switch. |
FICON_STATE |
INTEGER |
— |
FICON state: |
INTER_OPER_MODE |
INTEGER |
— |
Interoperation mode of the VSAN: |
PRINCIPAL_SW_ID |
INTEGER |
— |
Provides the ID of the principal switch. |
ADMIN_STATE |
NUMBER(4) |
— |
Administrative state of the VSAN: |
MTU |
INTEGER |
— |
Provides the MTU of the VSAN. |
LOAD_BALANCING_TYPE |
NUMBER(4) |
— |
Type of load balancing used by the VSAN: |
INORDER_DELIVERY |
NUMBER(1) |
— |
Indicates whether in-order delivery is guaranteed. |
NETWORK_DROP_LATENCY |
INTEGER |
— |
Provides the network drop latency in milliseconds. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 VSAN_FABRIC_VSAN_ID_INDEX is an index based on the columns FABRIC_ID and VSAN_ID. 2 VSAN_VSAN_ID_INDEX is an index based on the column VSAN_ID. |
This table associates a VSAN with a domain on a swtich. Use the SWITCH_ID to associate this VSAN and domain with a switch in the SWITCH table. Table 1-80 describes the VSAN_DOMAIN_INFO database schema table.
|
|
|
|
---|---|---|---|
VSAN_ID1 |
INTEGER |
NOT NULL |
Provides the ID of the VSAN. |
SWITCH_ID2 |
INTEGER |
NOT NULL |
Provides the ID of the switch. |
DOMAIN_ID |
SMALLINT |
— |
Provides the domain of the switch in the VSAN. |
WWN |
RAW(100) |
— |
Provides the WWN of the switch in the VSAN. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Indicates the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 VSAN_DOMAIN_VSAN_ID is an index based on the column VSAN_ID. 2 VSAN_DOMAIN_SWITCH_ID is an index based on the column SWITCH_ID. |
This table provides the FCID for an end port in a VSAN. Use the VSAN_ID to associate this end port with a VSAN in the VSAN table. Table 1-81 describes the VSAN_ENDPORT_INFO database schema table.
|
|
|
|
---|---|---|---|
VSAN_ID1 |
INTEGER |
NOT NULL |
Provides the ID of the VSAN. |
ENDPORT_ID2 |
INTEGER |
NOT NULL |
Provides the ID of the end port. |
FCID |
INTEGER |
— |
Provides the FC ID of the end port in the VSAN. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 VSAN_ENDPORT_VSAN_ID is an index based on the column VSAN_ID. 2 VSAN_ENDPORT_ENDPORT_ID is an index based on the column ENDPORT_ID. |
This table provides the status for an ISL in a VSAN. Use the VSAN_ID to associate this ISL with a VSAN in the VSAN table. Table 1-82 describes the VSAN_ISL_INFO database schema table.
|
|
|
|
---|---|---|---|
VSAN_ID1 |
INTEGER |
NOT NULL |
Provides the ID of the VSAN. |
ISL_ID2 |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the ISL. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 VSAN_ISL_VSAN_ID is an index based on the column VSAN_ID. 2 VSAN_ISL_ISL_ID is an index based on the column ISL_ID. |
This table describes the XML documents information.Table 1-83 describes the XMLDOCS database schema table.
This table describes the VSAN NPVL information.Table 1-84 describes the VSAN_NPVL_INFO database schema table.
|
|
|
|
---|---|---|---|
VSAN_ID1 |
INTEGER |
NOT NULL |
Provides the ID of the VSAN. |
NPVL_ID2 |
INTEGER |
NOT NULL |
Provides the ID of NPVL. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Indicates the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 VSAN_NPVL_VSAN_ID is an index based on the column VSAN_ID. 2 VSAN_NPVL_NPVL_ID is an index based on the column NPVL_ID. |
This table describes a zone. Use the IS_IVR to determine if this zone is an IVR zone. If it is an IVR zone, use the PARENT_ID to associate this zone with a fabric in the FABRIC table. Otherwise, use the PARENT_ID to associate this zone with a VSAN in the VSAN table. Table 1-85 describes the ZONE database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the entry in the table. |
PARENT_ID1 |
INTEGER |
— |
Provides the ID of the parent. Parent could be either a fabric (IVR zone) or VSAN. |
IS_IVR2 |
NUMBER(1) |
— |
Indicates whether the zone is an IVR zone. |
ZONE_INDEX |
INTEGER |
— |
Describes the index of the zone. |
NAME |
VARCHAR2(256) |
— |
Describes the name of the zone. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Indicates the time when the entry was updated. |
READ_ONLY |
NUMBER(1) |
— |
Indicates whether the zone can be modified. |
QOS |
NUMBER(1) |
— |
Indicates whether QoS is supported by the zone. |
QOS_PRIORITY |
INTEGER |
— |
Priority of the LUN: |
BROADCAST |
NUMBER(1) |
— |
Indicates whether the zone supports broadcast. |
CFS_REGION_ID3 |
INTEGER |
— |
Provides the region ID of the CFS. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
1 ZONE_VSAN_INDEX is an index based on the column PARENT_ID. 2 ZONE_ISIVR_INDEX is an index based on the column IS_IVR. 3 ZONE_CFS_INDEX is an index based on the column CFS_REGION_ID. |
This table describes a member of a zone. Use the ZONE_ID to associate this member with a zone in the ZONE table. Table 1-86 describes the ZONE_MEMBER database schema table.
|
|
|
|
---|---|---|---|
ID |
INTEGER |
NOT NULL |
Provides the ID of the entry in the table. |
ZONE_ID1 |
INTEGER |
— |
Provides the ID of the parent zone. |
TYPE |
INTEGER |
— |
Type of the member: |
MEMBER_ID2 |
RAW(100) |
— |
Provides the ID of the zone member. |
LUN_ID3 |
RAW(1000) |
— |
Provides the ID of LUNs. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
IVR_VSAN_ID |
INTEGER |
— |
Provides the VSAN ID for the IVR zone member. |
PORT_STATUS |
RAW(100) |
— |
Deprecated. |
AFID |
INTEGER |
— |
Provides the AFID of the IVR zone member. |
CFS_REGION_ID4 |
INTEGER |
— |
Provides the region ID of the CFS. |
RESERVE_COL1 |
VARCHAR |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR |
— |
Deprecated. |
1 ZONE_MEMBER_ZONEID_INDEX is an index based on the column ZONE_ID. 2 ZONE_MEMBER_MEMBERID_INDEX is an index based on the column MEMBER_ID. 3 ZONE_MEMBER_LUN_ID_INDEX is an index based on the column LUN_ID. 4 ZONE_MEMBER_CFS_REGID_INDEX is an index based on the column CFS_REGION_ID. |