Table Of Contents
Fabric Manager Server Database Schema
Overview
Related Fabric Manager Server Database Schema Tables
Switch Management Tables
Enclosure Tables
Fabric Tables
Network Management Tables
Performance Manager Tables
Cisco Traffic Analyzer Tables
Individual Fabric Manager Server Database Schema Tables
CARD (Deprecated)
ENCLOSURE
END_PORT
EVENTS
EVENT_FORWARD
FABRIC
FICON_INFO
FMUSER
GROUPS
GROUP_FABRIC_INFO
GROUP_MEMBER_INFO
HBA
HW_CARD
HW_COMPONENT
HW_POWER_SUPPLY
ISL
LICENSE
NTOP
NTOP_SPAN_INFO
PMDATAINDEX
PMEXTRAOID
PMINDEXBOOKMARK
PM_COLLECTION
PM_OPTION
SCSI_TARGET
SEQUENCE
SNMP_COMMUNITY
SNMPUSER
SPAN_PORT
SPAN_SESSION
SPAN_SOURCE_PORT
STATISTICS
SWITCH
SWITCH_MGMT_ADDRESS
SWITCH_PORT
USERFABRIC_INFO
VSAN
VSAN_DOMAIN_INFO
VSAN_ENDPORT_INFO
VSAN_ISL_INFO
ZONE
ZONE_MEMBER
Fabric Manager Server Database Schema
Overview
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.
An example that uses the database schema tables described in this document is shown in Appendix A.
Caution Once you connect to the Fabric Manager Server database you will be able to modify values in it. Modifying some of these values may corrupt the database. Therefore, we suggest that you only read values from the database.
The schema tables are described in two sections:
•Related Fabric Manager Server Database Schema Tables
•Individual Fabric Manager Server Database Schema Tables
Related Fabric Manager Server Database Schema Tables
The tables in the Fabric Manager Server schema are grouped by related functions in the following sections:
•Switch Management Tables
•Enclosure Tables
•Fabric Tables
•Network Management Tables
•Performance Manager Tables
•Cisco Traffic Analyzer Tables
Switch Management Tables
The schema tables that relate to switch management are described in Table 1-1.
Table 1-1 Switch Management Tables
Table Name
|
Description
|
SWITCH
|
Provides the sWWN and fabric ID for a switch. Use the FABRIC_ID to associate each switch to a fabric in the FABRIC table.
|
SWITCH_MGMT_ADDRESS
|
Provides the switch management port IP address. Use the SWITCH_ID to associate each entry to a switch in the SWITCH table.
|
SWITCH_PORT
|
Associates an SNMP ifIndex and pWWN to a port. Use the SWITCH_ID to associate each entry to a switch in the SWITCH table.
|
LICENSE
|
Describes licenses configured and in use in a switch. Use the SWITCH_ID to associate each entry to a switch in the SWITCH table.
|
HW_COMPONENT
|
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.
|
HW_CARD
|
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.
|
HW_POWER_SUPPLY
|
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.
|
FICON_INFO
|
Describes a FICON connection to a switch. Use the PORT_ID to associate this FICON connection to a port in the SWITCH_PORT table.
|
ISL
|
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.
|
SCSI_TARGET
|
Provides the WWN for a SCSI target. Use the ID to associate this SCSI target to a port in the SWITCH_PORT table.
|
Enclosure Tables
The schema tables that relate to enclosures are described in Table 1-2.
Table 1-2 Enclosure Tables
Table Name
|
Description
|
ENCLOSURE
|
Describes an enclosure, which can be a physical or virtual entity.
|
HBA
|
Associates a WWN to a host bus adapter. Use the ENCLOSURE_ID to associate each HBA to an enclosure in the ENCLOSURE table.
|
END_PORT
|
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.
|
Fabric Tables
The schema tables that relate to the fabric are described inTable 1-3.
Table 1-3 Fabric Tables
Table Name
|
Description
|
FABRIC
|
Describes a SAN fabric.
|
VSAN
|
Describes a VSAN within a fabric. Use the FABRIC_ID to associate this VSAN with a fabric in the FABRIC table.
|
VSAN_DOMAIN_INFO
|
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.
|
VSAN_ENDPORT_INFO
|
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.
|
VSAN_ISL_INFO
|
Provides the status for an ISL in a VSAN. Use the VSAN_ID to associate this ISL with a VSAN in the VSAN table.
|
ZONE
|
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.
|
ZONE_MEMBER
|
Describes a member of a zone. Use the ZONE_ID to associate this member with a zone in the ZONE table.
|
Network Management Tables
The schema tables that relate to network management are described in Table 1-4.
Table 1-4 Network Management Tables
Table Name
|
Description
|
FMUSER
|
Describes a Fabric Manager user.
|
GROUPS
|
Describes a Fabric Manager group within a fabric. Use the FABRIC_ID to associate this group to a fabric in the FABRIC table.
|
GROUP_FABRIC_INFO
|
Describes the mapping between the user-defined logical groups and fabrics.
|
GROUP_MEMBER_INFO
|
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.
|
SEQUENCE
|
Describes the current long values for automatically generated IDs.
|
SNMPUSER
|
Describes an SNMP user.
|
SNMP_COMMUNITY
|
Describes an SNMP community.
|
USERFABRIC_INFO
|
Describes the user of a fabric.
|
Performance Manager Tables
The schema tables that relate to Performance Manager are described in Table 1-5.
Table 1-5 Performance Manager Tables
Table Name
|
Description
|
EVENTS
|
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.
|
EVENT_FORWARD
|
Describes the event-forward configurations.
|
PMDATAINDEX
|
Maintains the logical-to-physical mapping of RRD files.
|
PMEXTRAOID
|
Defines object IDs and switch IPs for the Performance Manager data collection.
|
PMINDEXBOOKMARK
|
Maintains the current bookmark index of the RRD files.
|
PM_COLLECTION
|
Describes a Performance Manager collection. Use the FABRIC_ID to associate this collection to a fabric in the FABRIC table.
|
PM_OPTION
|
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.
|
STATISTICS
|
Provides statistics gathered for a Performance Manager collection.
|
Cisco Traffic Analyzer Tables
The schema tables that relate to Cisco Traffic Analyzer are described in Table 1-6.
Table 1-6 Cisco Traffic Analyzer Tables
Table Name
|
Description
|
NTOP
|
Describes a configured NTOP enity.
|
NTOP_SPAN_INFO
|
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.
|
SPAN_PORT
|
Describes a SPAN port on a switch. Use the SWITCH_ID to associate this SPAN port to a switch in the SWITCH table.
|
SPAN_SESSION
|
Describes a SPAN session. Use the SPAN_PORT_ID to associate this session to a SPAN port in the SPAN_PORT table.
|
SPAN_SOURCE_PORT
|
Describes a SPAN source port. Use the SESSION_ID to associate this source port to a SPAN session in the SPAN_SESSION table.
|
Individual Fabric Manager Server Database Schema Tables
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:
•CARD (Deprecated)
•ENCLOSURE
•END_PORT
•EVENTS
•EVENT_FORWARD
•FABRIC
•FICON_INFO
•FMUSER
•GROUPS
•GROUP_FABRIC_INFO
•GROUP_MEMBER_INFO
•HBA
•HW_CARD
•HW_COMPONENT
•HW_POWER_SUPPLY
•ISL
•LICENSE
•NTOP
•NTOP_SPAN_INFO
•PMDATAINDEX
•PMEXTRAOID
•PMINDEXBOOKMARK
•PM_COLLECTION
•PM_OPTION
•SCSI_TARGET
•SEQUENCE
•SNMP_COMMUNITY
•SNMPUSER
•SPAN_PORT
•SPAN_SESSION
•SPAN_SOURCE_PORT
•STATISTICS
•SWITCH
•SWITCH_MGMT_ADDRESS
•SWITCH_PORT
•USERFABRIC_INFO
•VSAN
•VSAN_DOMAIN_INFO
•VSAN_ENDPORT_INFO
•VSAN_ISL_INFO
•ZONE
•ZONE_MEMBER
CARD (Deprecated)
Note The CARD Fabric Manager Server database schema table is no longer in use.
ENCLOSURE
This table describes an enclosure, which can be a physical or virtual entity. Table 1-7 describes the ENCLOSURE database schema table.
Table 1-7 ENCLOSURE Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry.
|
NAME
|
VARCHAR
|
—
|
Name of the enclosure.
|
IS_VIRTUAL
|
BOOLEAN
|
—
|
Indication of whether the enclosure is virtual.
|
ENC_TYPE
|
INTEGER
|
—
|
Type of the enclosure.
|
OS_INFO
|
VARCHAR
|
—
|
Operating system of the enclosure.
|
IP_ADDRESS
|
BINARY
|
—
|
IP address of the enclosure.
|
DM_PATH
|
VARCHAR
|
—
|
Device manager path of the enclosure.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Time when last seen, in milliseconds since 1/1/1970.
|
SAN_ID
|
BIGINT
|
—
|
Deprecated.
|
VENDOR
|
VARCHAR
|
—
|
Deprecated.
|
MODEL
|
VARCHAR
|
—
|
Deprecated.
|
VERSION
|
VARCHAR
|
—
|
Version of the enclosure.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
END_PORT
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-8 describes the END_PORT database schema table.
Table 1-8 END_PORT Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
Primary key of the entity.
|
FABRIC_ID1
|
BIGINT
|
—
|
ID of the parent fabric.
|
ENCLOSURE_ID2
|
BIGINT
|
—
|
ID of the enclosure to which the end port belongs.
|
HBA_ID
|
BIGINT
|
—
|
ID of the HBA to which the end port belongs.
|
SWITCH_PORT_ID3
|
BIGINT
|
—
|
ID of the switch port that linked to the end port.
|
WWN4
|
BINARY(8)
|
—
|
WWN of the end port.
|
NODE_WWN5
|
BINARY
|
—
|
WWN of the node.
|
FICON_PORT_ADDRESS
|
BINARY
|
—
|
FICON address of the end port.
|
FLAGS
|
INTEGER
|
—
|
Deprecated.
|
SYM_PORT_NAME
|
VARCHAR
|
—
|
Symbolic name of the end port.
|
SYM_NODE_NAME
|
VARCHAR
|
—
|
Symbolic name of the parent node.
|
PORT_IP_ADDR
|
VARCHAR
|
—
|
IP address of the parent node.
|
ALIAS
|
VARCHAR
|
—
|
Port alias.
|
IS_PRESENT
|
BOOLEAN
|
—
|
Indication of whether the end port exists in any of the VSANs.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Time when last seen, in milliseconds since 1/1/1970.
|
OPER_STATUS_CAUSE
|
INTEGER
|
—
|
If the link is down, the value represents the status. Refer to values for FcIfOperStatusReason in CISCO-FC-FE-MIB.
|
IF_NAME
|
VARCHAR
|
—
|
The interface name of the attached switch port.
|
IS_LOOP
|
BOOLEAN
|
—
|
Indication of whether the link is an arbitrated loop.
|
FC4_TYPES
|
BINARY
|
—
|
FC4 types of the end port. Refer to values for fcNameServerFC4Type in CISCO-NS-MIB.
|
FC4_FEATURES
|
INTEGER
|
—
|
FC4 features of the end port. Refer to values for fcNameServerFC4Features in CISCO-NS-MIB.
|
NAME
|
VARCHAR
|
—
|
The logical name of the end port.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
EVENTS
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-9 describes the EVENTS database schema table.
Table 1-9 EVENTS Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
EVENTID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the event.
|
TSTAMP
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
TYPE
|
INTEGER
|
—
|
Type of the event. See Table 1-10.
|
SEVERITY1
|
INTEGER
|
—
|
Severity of the event: 0 = emergency 1 = alert 2 = critical 3 = error 4 = warning 5 = notice 6 = info 7 = debug
|
SOURCE
|
VARCHAR
|
NOT NULL
|
Source fabric that generated the event.
|
DESCR
|
VARCHAR
|
NOT NULL
|
Description of the event.
|
SANID
|
BIGINT
|
—
|
ID of the SAN that generated the event.
|
FABRICID
|
BIGINT
|
—
|
ID of the fabric that generated the event.
|
SWITCHID
|
BIGINT
|
—
|
ID of the switch that generated the event.
|
SRCID
|
BIGINT
|
—
|
ID of the source port; applies to Performance Manager events only.
|
DESTID
|
BIGINT
|
—
|
ID of the destination port; applies to Performance Manager events only.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
Table 1-10 TYPE Field Description in EVENTS Table
TYPE
|
Description
|
0
|
other
|
1
|
switch discovered
|
2
|
switch rebooted
|
3
|
switch unreachable
|
4
|
switch manageable
|
5
|
switch unmanageable
|
6
|
switch IP changed
|
7
|
VSAN added
|
8
|
VSAN unreachable
|
9
|
VSAN up
|
10
|
VSAN down
|
11
|
VSAN merged
|
12
|
VSAN segmented
|
13
|
zone set changed
|
14
|
principal switch changed
|
15
|
ISL up
|
16
|
ISL unreachable
|
17
|
N_Port up
|
18
|
N_Port unreachable
|
19
|
N_Port moved
|
20
|
enclosure added
|
21
|
enclosure removed
|
22
|
binding denied
|
23
|
switch of activity
|
24
|
service or process restarted
|
25
|
fan tray changed
|
26
|
power changed
|
27
|
module changed
|
28
|
FRU inserted
|
29
|
FRU removed
|
30
|
zone merged
|
31
|
fabric changed
|
32
|
fabric opened
|
33
|
fabric closed
|
34
|
license manager
|
35
|
image upgraded
|
36
|
VRRP
|
37
|
IVR
|
38
|
FICON
|
39
|
server down
|
40
|
threshold exceeded
|
41
|
CFS
|
42
|
SAN removed
|
43
|
fabrics merged
|
44
|
fabric split
|
45
|
feature
|
46
|
FM license violation
|
47
|
fabric purged
|
48
|
RMON events
|
49
|
sensor events
|
EVENT_FORWARD
This table describes the event-forward configurations. Table 1-11 describes the EVENT_FORWARD database schema table.
Table 1-11 EVENT_FORWARD Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID1
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry.
|
TYPE
|
INTEGER
|
—
|
Type of the event forward entry: trap = 1 email = 2
|
FID
|
BIGINT
|
—
|
ID of the fabric; 0 indicates all fabrics.
|
VSAN_SCOPE
|
VARCHAR
|
—
|
VSAN scope; for example, "1, 2, 10-14", or "ALL".
|
SEVERITY
|
INTEGER
|
—
|
Severity to trigger the forward action: 0 = emergency 1 = alert 2 = critical 3 = error 4 = warning 5 = notice 6 = info 7 = debug
|
ADDRESS
|
VARCHAR
|
—
|
Address of the event forward.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
FABRIC
This table describes a SAN fabric. Table 1-12 describes the FABRIC database schema table.
Table 1-12 FABRIC Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
Primary key of the database entry.
|
SEED_SWITCH_ID1
|
BIGINT
|
—
|
ID of the switch where the fabric discovery originated.
|
IVR_SEED_SWITCH_ID2
|
BIGINT
|
—
|
ID of the switch where the IVR data originated.
|
ALIAS_SEED_SWITCH_ID
|
BIGINT
|
—
|
ID of the alias switch.
|
LICENSE_ID
|
BIGINT
|
—
|
Deprecated.
|
IVR_ENF_ZONESET_NAME
|
VARCHAR
|
—
|
Active IVR zone set name.
|
IVR_ENF_ZONESET_ACTIVATE_TIME
|
BIGINT
|
—
|
Time in milliseconds when the IVR zone set is activated.
|
IVR_ACTIVE_ZONESET_CHECKSUM
|
BINARY
|
—
|
IVR active zone set checksum.
|
POLLING_ENABLED
|
BOOLEAN
|
—
|
Indication of whether the fabric is polled regularly.
|
POLLING_INTERVAL
|
INTEGER
|
—
|
Fabric polling interval, in seconds.
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Time when last seen, in milliseconds since 1/1/1970.
|
SNMP_RETRIES
|
INTEGER
|
—
|
Number of SNMP retries.
|
SNMP_TIMEOUT
|
INTEGER
|
—
|
SNMP timeout in milliseconds.
|
FMUSER_ID
|
BIGINT
|
—
|
Deprecated.
|
NAME
|
VARCHAR
|
—
|
Fabric name.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
SAN_ID
|
BIGINT
|
—
|
ID of the parent SAN.
|
FID
|
INTEGER
|
—
|
Fabric ID.
|
IS_PERSISTENT
|
BOOLEAN
|
—
|
Indication of whether continuous monitoring is enabled.
|
ON_DEMAND_POLL_FREQ
|
INTEGER
|
—
|
On-demand polling interval for fabric discovery, in seconds.
|
IVR_TOPO_CFG_CHECKSUM
|
BINARY
|
—
|
Deprecated.
|
IVR_TOPO_ACT_CHECKSUM
|
BINARY
|
—
|
Deprecated.
|
IVR_TOPO_AFID_CFG_CHECKSUM
|
BINARY
|
—
|
Deprecated.
|
IVR_TOPO_DEF_AFID_CHECKSUM
|
BINARY
|
—
|
Deprecated.
|
IVR_TOPO_VALIDATED
|
BOOLEAN
|
—
|
Deprecated.
|
USE_GLOBAL_ALIAS
|
BOOLEAN
|
—
|
Indication of whether the fabric is set to use the global alias.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
FICON_INFO
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-13 describes the FICON_INFO database schema table.
Table 1-13 FICON_INFO Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
Interface ID.
|
VENDOR
|
VARCHAR
|
—
|
Name of the company that manufactured the peer node.
|
TYPE_NUM
|
VARCHAR
|
—
|
Type number of the peer node.
|
MODEL_NUM
|
VARCHAR
|
—
|
Model number of the peer node.
|
SERIAL_NUM
|
VARCHAR
|
—
|
Sequence number assigned to the peer node during manufacturing.
|
PORT_ID1
|
VARCHAR
|
—
|
Identifier of the port in the peer node connected to this port. If the peer node is a control unit, then this value will be 0. If the peer node is a channel, then 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, then 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
|
—
|
Time when the entry was updated.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
FMUSER
This table describes a Fabric Manager user. Table 1-14 describes the FMUSER database schema table.
Table 1-14 FMUSER Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the Fabric Manager user.
|
USER_NAME1
|
VARCHAR
|
—
|
Username encrypted for security.
|
AUTH_PASSWORD
|
VARCHAR
|
—
|
Authentication password encrypted for security.
|
ROLE_NAME
|
VARCHAR
|
—
|
User role name; can be either network administrator or operator.
|
IS_LOGGING_IN
|
BOOLEAN
|
—
|
Login status of the user.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
GROUPS
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-15 describes the GROUPS database schema table.
Table 1-15 GROUPS Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID1
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the group.
|
FABRIC_ID2
|
BIGINT
|
—
|
ID of the fabric to which the group belongs.
|
NAME2
|
VARCHAR
|
—
|
Name of the group.
|
TYPE
|
INTEGER
|
—
|
Type of the group: 1 = switch 2 = end port
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
GROUP_FABRIC_INFO
This table describes the mapping between the user-defined logical groups and fabrics. Table 1-16 describes the GROUP_FABRIC_INFO database schema table.
Table 1-16 GROUP_FABRIC_INFO Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
GROUP_ID1
|
BIGINT
|
NOT NULL
|
ID of the group.
|
FABRIC_ID2
|
BIGINT
|
NOT NULL
|
ID of the fabric to which the group belongs.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
GROUP_MEMBER_INFO
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-17 describes the GROUP_MEMBER_INFO database schema table.
Table 1-17 GROUP_MEMBER_INFO Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
GROUP_ID1
|
BIGINT
|
NOT NULL
|
ID of the group.
|
MEMBER_ID2
|
BIGINT
|
NOT NULL
|
ID of the group member, which is a switch or an end port ID.
|
TYPE
|
INTEGER
|
—
|
Type of the group member: 1 = switch 2 = end port
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
HBA
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-18 describes the HBA database schema table.
Table 1-18 HBA Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the HBA.
|
ENCLOSURE_ID1
|
BIGINT
|
—
|
ID of the parent enclosure.
|
HWWN2
|
BINARY(8)
|
—
|
HBA WWN, one of its port WWNs.
|
NWWN3
|
BINARY(8)
|
—
|
Node WWN.
|
TYPE
|
SMALLINT
|
—
|
Deprecated.
|
MANUFACTURER
|
VARCHAR
|
—
|
Manufacturer name.
|
SERIAL_NUMBER
|
VARCHAR
|
—
|
Serial number of the HBA.
|
MODEL
|
VARCHAR
|
—
|
Model of the HBA.
|
MODEL_DESCRIPTION
|
VARCHAR
|
—
|
Model description of the HBA.
|
HW_VERSION
|
VARCHAR
|
—
|
Hardware version.
|
SW_VERSION
|
VARCHAR
|
—
|
Firmware version.
|
DRIVER_VERSION
|
VARCHAR
|
—
|
Driver version.
|
OPT_ROM_VERSION
|
VARCHAR
|
—
|
Optional ROM version.
|
OS
|
VARCHAR
|
—
|
Deprecated.
|
IP_ADDRESS
|
VARCHAR
|
—
|
IP address of the HBA.
|
IS_PRESENT
|
BOOLEAN
|
—
|
Indication of whether the HBA exists.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
STATUS
|
INTEGER
|
—
|
Deprecated.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
HW_CARD
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-19 describes the HW_CARD database schema table.
Table 1-19 HW_CARD Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
HW_COMPONENT_ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry in HW_COMPONENT table.
|
MODEL_TYPE
|
INTEGER
|
—
|
Model type of the card. See Table 1-20.
|
ADMIN_STATUS
|
INTEGER
|
—
|
Administrative status of the card: 1 = enabled 2 = disabled 3 = reset 4 = out of service
|
OPER_STATUS
|
INTEGER
|
—
|
The operational status of the card. See Table 1-21.
|
RESET_REASON
|
VARCHAR
|
—
|
The reset reason for the card.
|
STATUS_LAST_CHANGE_TIME
|
BIGINT
|
—
|
Last status change time in hundredths of seconds.
|
POWER_ADMIN_STATUS
|
INTEGER
|
—
|
Administrative status of the power for the card: 1 = on 2 = off 3 = inline automatic 4 = inline on
|
POWER_OPER_STATUS
|
INTEGER
|
—
|
The operational status of the power for the card: 1 = off for environment or other reason 2 = on 3 = off for administration 4 = off denied 5 = off for environmental power 6 = off for environmental temperature 7 = off for environmental fan 8 = failed 9 = on but fan failed
|
POWER_CURRENT
|
INTEGER
|
—
|
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.
|
Table 1-20 MODEL_TYPE Field Description in HW_CARD Table
Value of MODEL_TYPE
|
Description
|
1
|
9500 supervisor
|
2
|
9500 redundant supervisor
|
3
|
9500 16x 2-Gbps FC Module
|
4
|
9500 32x 2-Gbps FC Module
|
5
|
9500 32x 2-Gbps FC Services (ILC)
|
6
|
9500 8x 1GE IP Storage Services (IPS)
|
7
|
Caching Services Module (CSM)
|
13
|
9216 16x 2-Gbps FC Module plus supervisor
|
18
|
9140 40x 2-Gbps FC Module
|
19
|
9120 20x 2-Gbps FC Module
|
20
|
Advanced Services Module (ASM)
|
21
|
MDS 9216 SAM Module
|
22
|
14 FC + 2 GE Multiprotocol Services Module
|
23
|
2x10-Gbps FC 10-Gbps FC Module
|
24
|
4x GE iSCSI/FCIP Services Module
|
27
|
9216i 14 FC + 2 IPS, plus supervisor
|
28
|
Supervisor-2, supervisor or fabric module
|
29
|
12-port FC switching module
|
30
|
24-port FC switching module
|
31
|
48-port FC switching module
|
32
|
4-port 10G FC module
|
33
|
Crossbar module on the back of 13 slot chassis
|
35
|
9124 24x 4-Gbps FC Module plus supervisor
|
254
|
9020 20-port 4-Gbps FC
|
Table 1-21 OPER_STATUS Field Description in HW_CARD Table
Value of OPER_STATUS
|
Description
|
1
|
unknown
|
2
|
OK
|
3
|
disabled
|
4
|
OK but diagnostic failed
|
5
|
boot
|
6
|
self-test
|
7
|
failed
|
8
|
missing
|
9
|
mismatched parenthesis
|
10
|
mismatched configuration
|
11
|
diagnostic failed
|
12
|
dormant
|
13
|
out of service administration
|
14
|
out of service environmental temperature
|
15
|
powered down
|
16
|
powered up
|
17
|
power denied
|
18
|
power cycled
|
19
|
OK but power over warning
|
20
|
OK but power over critical
|
21
|
sync in progress
|
HW_COMPONENT
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-22 describes the HW_COMPONENT database schema table.
Table 1-22 HW_COMPONENT Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID1
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the hardware component.
|
SWITCH_ID2
|
BIGINT
|
—
|
ID of the parent switch.
|
NAME
|
VARCHAR
|
—
|
Name of the hardware component.
|
PHYSICAL_INDEX
|
INTEGER
|
—
|
Value that when combined with the switch card offset, yields the relative slot number.
|
RELATIVE_POSITION
|
INTEGER
|
—
|
Relative position of the hardware component; for a card, it is the slot number.
|
HW_TYPE
|
INTEGER
|
—
|
Type of the hardware component: 1 = other 2 = unknown 3 = chassis 4 = backplane 5 = container 6 = power supply 7 = fan 8 = sensor 9 = module 10 = port 11 = stack
|
VENDOR_TYPE
|
OBJECT
|
—
|
Vendor type of the hardware component.
|
HW_REVISION
|
VARCHAR
|
—
|
Hardware revision of the hardware component.
|
FW_REVISION
|
VARCHAR
|
—
|
Firmware revision of the hardware component.
|
SW_REVISION
|
VARCHAR
|
—
|
Software revision of the hardware component.
|
SERIAL_NUMBER
|
VARCHAR
|
—
|
Serial number of the hardware component.
|
MANUFACTURER
|
VARCHAR
|
—
|
Manufacturer of the hardware component.
|
MODEL_NAME
|
VARCHAR
|
—
|
Model name of the hardware component.
|
ASSET_ID
|
VARCHAR
|
—
|
Asset ID of the hardware component.
|
STATUS_DESCRIPTION
|
VARCHAR
|
—
|
Status description of the hardware component.
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Time when last seen, in milliseconds since 1/1/1970.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
HW_POWER_SUPPLY
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-23 describes the HW_POWER_SUPPLY database schema table.
Table 1-23 HW_POWER_SUPPLY Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
HW_COMPONENT_ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry in the HW_COMPONENT table.
|
REDUNDANCY_MODE
|
INTEGER
|
—
|
Redundancy mode: 1 = not supported 2 = redundant 3 = combined Refer to CISCO-ENTITY-FRU-CONTROL-MIB for more information.
|
TOTAL_DRAWN_CURRENT
|
INTEGER
|
—
|
Total current drawn by the power supply.
|
TOTAL_AVAILABLE_CURRENT
|
INTEGER
|
—
|
Total current available for the power supply.
|
POWER_UNITS
|
VARCHAR
|
—
|
Units of the power supply.
|
ISL
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-24 describes the ISL database schema table.
Table 1-24 ISL Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the ISL entry in the table.
|
PORT1_ID1
|
BIGINT
|
—
|
ID of port1 (the port with smaller WWN).
|
PORT2_ID2
|
BIGINT
|
—
|
ID of port2.
|
OPER_MODE
|
SMALLINT
|
—
|
Operational mode of the link by port type: 1 = auto 2 = F 3 = FL 4 = E 5 = B 6 = FX 7 = SD 8 = TL 9 = N 10 = NL 11 = NX 12 = TE 13 = FV 14 = down 15 = ST
|
IS_PRESENT
|
BOOLEAN
|
—
|
Indication of whether the ISL is present in the current fabric.
|
STATUS
|
SMALLINT
|
—
|
Deprecated.
|
OPER_STATUS_CAUSE
|
INTEGER
|
—
|
If OPER_MODE is MODE_DOWN, the value is the down status.
|
OPER_STATUS_DESCRIPTION
|
VARCHAR
|
—
|
If OPER_MODE is MODE_DOWN, the value is the down status description.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Time when last seen, in milliseconds since 1/1/1970.
|
CHANNEL_CONFIG_CHILD_COUNT
|
INTEGER
|
—
|
Configured PortChannel member count.
|
CHANNEL_CURRENT_CHILD_COUNT
|
INTEGER
|
—
|
PortChannel member count.
|
AUTO_CREATED
|
BOOLEAN
|
—
|
Indication of whether the entry was automatically created.
|
IS_CHANNELMEMBER3
|
BOOLEAN
|
—
|
Indication of whether the ISL is a PortChannel member.
|
CHANNEL_ID
|
BIGINT
|
—
|
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
|
—
|
FICON address of the switch port at one end.
|
FICON_ADDRESS_2
|
INTEGER
|
—
|
FICON address of the switch port at the other end.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
LICENSE
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-25 describes the LICENSE database schema table.
Table 1-25 LICENSE Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the license.
|
SWITCH_ID1
|
BIGINT
|
—
|
ID of the switch where the license was installed.
|
FEATURE_NAME
|
VARCHAR
|
—
|
Name of the license.
|
TYPE
|
INTEGER
|
—
|
Deprecated.
|
LICENSE_FLAG
|
BINARY
|
—
|
License flag that indicates the type of the license: 0 = demo 1 = permanent 2 = counted 3 = unlicensed 4 = in grace period
|
MAX_LICENSE
|
INTEGER
|
—
|
Maximum number of licenses.
|
MISSING_LICENSE
|
INTEGER
|
—
|
Number of missing licenses.
|
CURRENT_LICENSE
|
INTEGER
|
—
|
Number of current licenses.
|
EXPIRE
|
BIGINT
|
—
|
Expiration time of the license, in milliseconds.
|
GRACE_PERIOD
|
INTEGER
|
—
|
Grace period of the license, in seconds.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
NTOP
This table describes a configured NTOP enity. Table 1-26 describes the NTOP database schema table.
Table 1-26 NTOP Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry.
|
IP_ADDR1
|
VARCHAR
|
—
|
Switch IP address.
|
PORT_NUMBER2
|
INTEGER
|
—
|
Switch port number.
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Time when last seen, in milliseconds since 1/1/1970.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
NTOP_SPAN_INFO
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-27 describes the NTOP_SPAN_INFO database schema table.
Table 1-27 NTOP_SPAN_INFO Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry.
|
NTOP_ID1
|
BIGINT
|
—
|
Foreign key to the NTOP table.
|
SPAN_PORT_ID2
|
BIGINT
|
—
|
Foreign key to the SPAN_PORT table.
|
ETH_NAME
|
VARCHAR
|
—
|
NTOP Ethernet port name.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
PMDATAINDEX
This table maintains the logical-to-physical mapping of RRD files. Table 1-28 describes the PMDATAINDEX database schema table.
Table 1-28 PMDATAINDEX Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
—
|
ID of the entry.
|
LOGICALFILENAME1
|
VARCHAR
|
—
|
Logical RRD filename.
|
FILETYPE
|
INT
|
—
|
File type has one of the following values: 0 = unknown 1 = ISL 2 = flow 3 = initiator 4 = target 5 = other 6 = gigabit Ethernet
|
DATAINDEX
|
INT
|
—
|
RRD data source index.
|
PHYSICLFILEINDEX
|
INT
|
—
|
Physical file index.
|
PMEXTRAOID
This table defines object IDs and switch IPs for the Performance Manager data collection. Table 1-29 describes the PMEXTRAOID database schema table.
Table 1-29 PMEXTRAOID Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
Record ID.
|
FID1
|
BIGINT
|
—
|
Fabric ID.
|
NAME
|
VARCHAR
|
—
|
Performance Manager object ID.
|
DISPLAYNAME
|
VARCHAR
|
—
|
Display name used in web client.
|
SWITCHIP
|
VARCHAR
|
—
|
IP address of the switch.
|
TYPE
|
VARCHAR
|
—
|
RRD data source type has one of the following character values: COUNT ABSOLUTE GAUGE
|
PMINDEXBOOKMARK
This table maintains the current bookmark index of the RRD files. Table 1-30 describes the PMINDEXBOOKMARK database schema table.
Table 1-30 PMINDEXBOOKMARK Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
BOOKMARKINDEX
|
BIGINT
|
—
|
Current RRD file book mark index.
|
TYPE1
|
INT
|
—
|
File type has one of the following values: 0 = unknown 1 = ISL 2 = flow 3 = initiator 4 = target 5 = other 6 = gigabit Ethernet
|
BOOKMARKCOUNT
|
INT
|
—
|
Number of bookmarks.
|
PM_COLLECTION
This table describes a Performance Manager collection. Use the FABRIC_ID to associate this collection to a fabric in the FABRIC table. Table 1-31 describes the PM_COLLECTION database schema table.
Table 1-31 PM_COLLECTION Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of entry.
|
FABRIC_ID1
|
BIGINT
|
—
|
Fabric ID; foreign key to a fabric table.
|
VSAN_LIST
|
VARCHAR
|
—
|
List of VSANs; for example, "1,5,6,4001".
|
MONITOR_ISL
|
BOOLEAN
|
—
|
Indication of whether to collect ISL PM for the fabric.
|
MONITOR_HOST
|
BOOLEAN
|
—
|
Indication of whether to collect host PM for the fabric.
|
MONITOR_STORAGE
|
BOOLEAN
|
—
|
Indication of whether to collect storage PM for the fabric.
|
MONITOR_FLOW
|
BOOLEAN
|
—
|
Indication of whether to collect flow PM for the fabric.
|
MONITOR_GIGE
|
BOOLEAN
|
—
|
Indication of whether to collect gigabit Ethernet port PM for the fabric.
|
MONITOR_OTHER
|
BOOLEAN
|
—
|
Indication of whether to collect other customized PM for the fabric.
|
TRAFFIC_THRESHOLD_ENABLE
|
BOOLEAN
|
—
|
Indication of whether threshold checking on traffic is enabled.
|
EVENT_THRESHOLD
|
BOOLEAN
|
—
|
Indication of whether threshold checking on event is enabled.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
PM_OPTION
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-32 describes the PM_OPTION database schema table.
Table 1-32 PM_OPTION Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of entry.
|
AUTO_COLLECT_NEW_DEVICE
|
BOOLEAN
|
—
|
Indication of whether to automatically collect new device PM.
|
INTERPOLATION
|
BOOLEAN
|
—
|
When TRUE, interpolate missing gap in data collection.
|
THRESHOLD_TYPE
|
INTEGER
|
—
|
Threshold type: 0 = no threshold checking 1 = static threshold checking Any other value will cause threshold checking using a baseline from historic data.
|
CRITICAL_WATERMARK
|
INTEGER
|
—
|
Critical watermark. If traffic exceeds this percentage of the capacity or average traffic, a critical event is triggered. If the BASELINE_PERIOD is 0, then the percentage value relates to the capacity. If the BASELINE_PERIOD is nonzero, then the percentage value relates to the average for the baseline period. For example, if the BASELINE_PERIOD is 0, then 80 means that if traffic exceeds 80% of the capacity, then a critical event is triggered.
|
WARNING_WATERMARK
|
INTEGER
|
—
|
Warning watermark. If traffic exceeds this percentage of the capacity or average traffic, a warning event is triggered. If the BASELINE_PERIOD is 0, then the percentage value relates to the capacity. If the BASELINE_PERIOD is nonzero, then the percentage value relates to the average for the baseline period. For example, if the BASELINE_PERIOD is 3, then 150 means that if traffic exceeds 150% of the average for 3 days, then a warning event is triggered.
|
BASELINE_PERIOD
|
INTEGER
|
—
|
Baseline period used in threshold checking. If the BASELINE_PERIOD is 0, use static threshold checking that is based on the capacity of the link. Otherwise, use the history specified in days. For example, 7 uses the last 7 days of data history.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
FIVE_MIN_SAMPLE_DAYS
|
INTEGER
|
DEFAULT 600
|
Number of days to collect samples at 5-minute intervals.
|
THIRTY_MIN_SAMPLE_DAYS
|
INTEGER
|
DEFAULT 700
|
Number of days to collect samples at 30-minute intervals.
|
TWO_HOUR_SAMPLE_DAYS
|
INTEGER
|
DEFAULT 775
|
Number of days to collect samples at 2-hour intervals.
|
DAILY_SAMPLE_DAYS
|
INTEGER
|
DEFAULT 300
|
Number of days to collect samples at daily intervals.
|
ISL_INTERVAL
|
INTEGER
|
DEFAULT 300
|
Collection interval in seconds for ISL objects: 30, 60, 90, up to 300
|
SCSI_TARGET
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-33 describes the SCSI_TARGET database schema table.
Table 1-33 SCSI_TARGET Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the SCSI target.
|
WWN
|
BINARY(8)
|
—
|
WWN of the SCSI target.
|
ENCLOSURE_ID
|
BIGINT
|
—
|
ID of the enclosure containing the target.
|
DEV_TYPE
|
INTEGER
|
—
|
Device type of the SCSI target: 0 = disk 1 = sequential 2 = printer 3 = processor 4 = WORM 5 = CDROM 6 = scanner 7 = optical 8 = changer 9 = SCSI network 10 = SCSI ASCIT8 11 = SCSI ASCIT8 12 = SCSI array 13 = SCSI enclosure 14 = SCSI RBC
|
VENDOR_ID
|
VARCHAR
|
—
|
Vendor ID of the SCSI target.
|
PRODUCT_ID
|
VARCHAR
|
—
|
Product ID of the SCSI target.
|
REV_LEVEL
|
VARCHAR
|
—
|
Product revision level of the SCSI target.
|
OTHER_INFO
|
BINARY
|
—
|
Bytes from 0 to 7 in the INQUIRY command response data.
|
IS_PRESENT
|
BOOLEAN
|
—
|
Indication of whether the SCSI target exists.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
STATUS
|
INTEGER
|
—
|
Deprecated.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
SEQUENCE
This table describes the current long values for automatically generated IDs. Table 1-34 describes the SEQUENCE database schema table.
Table 1-34 SEQUENCE Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
SMALLINT
|
NOT NULL PRIMARY KEY
|
Catalog of IDs.
|
VALUE
|
BIGINT
|
—
|
Starting value of database IDs.
|
SNMP_COMMUNITY
This table describes an SNMP community. Table 1-35 describes the SNMP_COMMUNITY database schema table.
Table 1-35 SNMP_COMMUNITY Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the SNMP community.
|
IP_ADDRESS
|
VARCHAR
|
NOT NULL
|
IP address of the community string.
|
READ
|
VARCHAR
|
—
|
Read community string.
|
WRITE
|
VARCHAR
|
—
|
Write community string.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
SNMPUSER
This table describes an SNMP user. Table 1-36 describes the SNMPUSER database schema table.
Table 1-36 SNMPUSER Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the SNMP user.
|
VERSION
|
INTEGER
|
—
|
Version of the SNMP user: 1 = SNMPv1 2 = SNMPv2 3 = SNMPv3
|
USER_NAME1
|
VARCHAR
|
—
|
For SNMPv3, the name of the SNMP user. For SNMPv1 or SNMPv2, the community string.
|
AUTH_PASSWORD
|
VARCHAR
|
—
|
Password of the SNMP user; applies to SNMPv3 only.
|
PRIV_PASSWORD
|
VARCHAR
|
—
|
Deprecated.
|
AUTH_PROTOCOL
|
INTEGER
|
—
|
Deprecated.
|
PRIV_PROTOCOL
|
INTEGER
|
—
|
Deprecated.
|
SECURITY_NAME
|
VARCHAR
|
—
|
Security name of the SNMP user.
|
ROLE_NAME
|
VARCHAR
|
—
|
Role of the SNMP user.
|
IS_LOGGING_IN
|
BOOLEAN
|
—
|
Deprecated.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
SPAN_PORT
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-37 describes the SPAN_PORT database schema table.
Table 1-37 SPAN_PORT Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry.
|
IF_INDEX1
|
INTEGER
|
—
|
IF index value of the port.
|
SWITCH_ID2
|
BIGINT
|
—
|
ID of the parent switch.
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Deprecated.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
SPAN_SESSION
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-38 describes the SPAN_SESSION database schema table.
Table 1-38 SPAN_SESSION Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry.
|
SESSION_ID1
|
INTEGER
|
—
|
ID of session.
|
SPAN_PORT_ID2
|
BIGINT
|
—
|
Foreign key to the SPAN_PORT.
|
OPER_STATUS
|
INTEGER
|
—
|
Operation status: 1 = active 2 = inactive
|
VSAN_FILTER
|
VARCHAR
|
—
|
List of VSAN filters, for example, "1,3,5".
|
VSAN_SOURCE
|
VARCHAR
|
—
|
List of VSAN sources, for example, "1,3,5".
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Deprecated.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
SPAN_SOURCE_PORT
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-39 describes the SPAN_SOURCE_PORT database schema table.
Table 1-39 SPAN_SOURCE_PORT Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry.
|
IF_INDEX1
|
INTEGER
|
—
|
Interface index of the port.
|
DIRECTION
|
INTEGER
|
—
|
Direction: receive = 1 transmit = 2
|
SESSION_ID2
|
BIGINT
|
—
|
Session ID; foreign key to the SPAN_SESSION.
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Time when last seen, in milliseconds since 1/1/1970.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
STATISTICS
This table provides statistics gathered for a Performance Manager collection. Table 1-40 describes the STATISTICS database schema table.
Table 1-40 STATISTICS Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
SRC_ID
|
BIGINT
|
NOT NULL
|
ID of the source port entry in the SWITCH_PORT table or the END_PORT table.
|
DEST_ID1
|
BIGINT
|
NOT NULL
|
ID of the destination port entry in SWITCH_PORT or END_PORT table.
|
TYPE
|
SMALLINT
|
—
|
Type of the statistic: 0 = unknown 1 = ISL 2 = flow 3 = initiator 4 = target 5 = other 6 = gigabit Ethernet
|
RRD_FILE
|
VARCHAR
|
—
|
RRD filename for the entity.
|
XML_FILE
|
VARCHAR
|
—
|
XML filename for the entity.
|
CAPACITY
|
BIGINT
|
—
|
Interface speed of the entity in bytes per second.
|
AVG_RX
|
REAL
|
—
|
Average number of bytes received per second for the last day.
|
AVG_TX
|
REAL
|
—
|
Average number of bytes transmitted per second for the last day.
|
TOTAL_RXTX
|
REAL
|
—
|
Total number of bytes received and transmitted for the last day.
|
MAX_RX
|
REAL
|
—
|
Peak number of bytes received for the last day.
|
MAX_TX
|
REAL
|
—
|
Peak number of bytes transmitted for the last day.
|
TOTAL_ERR
|
REAL
|
—
|
Total number of errors for the last day.
|
TOTAL_DISCARD
|
REAL
|
—
|
Total number of discards for the last day.
|
LAST_WEEK_AVG_RX
|
REAL
|
—
|
Average number of bytes received per second for the last week.
|
LAST_WEEK_AVG_TX
|
REAL
|
—
|
Average number of bytes transmitted per second for the last week.
|
LAST_WEEK_TOTAL_RXTX
|
REAL
|
—
|
Total number of bytes received and transmitted for the last week.
|
LAST_WEEK_MAX_RX
|
REAL
|
—
|
Peak number of bytes received for the last week.
|
LAST_WEEK_MAX_TX
|
REAL
|
—
|
Peak number of bytes transmitted for the last week.
|
LAST_WEEK_TOTAL_ERR
|
REAL
|
—
|
Total number of errors for the last week.
|
LAST_WEEK_TOTAL_DISCARD
|
REAL
|
—
|
Total number of discards for the last week.
|
LAST_MONTH_AVG_RX
|
REAL
|
—
|
Average number of bytes received per second for the last month.
|
LAST_MONTH_AVG_TX
|
REAL
|
—
|
Average number of bytes transmitted per second for the last month.
|
LAST_MONTH_TOTAL_RXTX
|
REAL
|
—
|
Total number of bytes received and transmitted for the last month.
|
LAST_MONTH_MAX_RX
|
REAL
|
—
|
Peak number of bytes received for the last month.
|
LAST_MONTH_MAX_TX
|
REAL
|
—
|
Peak number of bytes transmitted for the last month.
|
LAST_MONTH_TOTAL_ERR
|
REAL
|
—
|
Total number of errors for the last month.
|
LAST_MONTH_TOTAL_DISCARD
|
REAL
|
—
|
Total number of discards for the last month.
|
LAST_YEAR_AVG_RX
|
REAL
|
—
|
Average number of bytes received per second for the last year.
|
LAST_YEAR_AVG_TX
|
REAL
|
—
|
Average number of bytes transmitted per second for the last year.
|
LAST_YEAR_TOTAL_RXTX
|
REAL
|
—
|
Total number of bytes received and transmitted for the last year.
|
LAST_YEAR_MAX_RX
|
REAL
|
—
|
Peak number of bytes received for the last year.
|
LAST_YEAR_MAX_TX
|
REAL
|
—
|
Peak number of bytes transmitted for the last year.
|
LAST_YEAR_TOTAL_ERR
|
REAL
|
—
|
Total number of errors for the last year.
|
LAST_YEAR_TOTAL_DISCARD
|
REAL
|
—
|
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
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
SWITCH
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-41 describes the SWITCH database schema table.
Table 1-41 SWITCH Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the switch entry in the switch table.
|
FABRIC_ID1
|
BIGINT
|
—
|
ID of the parent fabric entry in fabric table.
|
LICENSE_ID
|
BIGINT
|
—
|
Deprecated.
|
WWN2
|
BINARY(8)
|
—
|
WWN of the switch.
|
IP_ADDRESS3
|
BINARY
|
—
|
IP address of the switch.
|
IS_MDS
|
BOOLEAN
|
—
|
Indication of whether the switch is an MDS switch.
|
TYPE
|
INTEGER
|
—
|
Model type of the switch; applies to MDS switches only. See Table 1-42.
|
IS_MANAGABLE
|
BOOLEAN
|
—
|
Indication of whether the switch is manageable.
|
UNMANAGABLE_CAUSE
|
VARCHAR
|
—
|
Reason why the switch is unmanageable.
|
NON_MDS_MODEL
|
VARCHAR
|
—
|
Model name for a non-MDS switch.
|
SYS_NAME
|
VARCHAR
|
—
|
System name.
|
SYS_CONTACT
|
VARCHAR
|
—
|
System contact information.
|
SYS_LOCATION
|
VARCHAR
|
—
|
System location information.
|
SYS_UPTIME
|
BIGINT
|
—
|
System up-time in hundredths of seconds. 0 indicates system down.
|
ACTIVE_SUP_SLOT
|
INTEGER
|
—
|
Active supervisor slot number.
|
STANDBY_SUP_STATE
|
INTEGER
|
—
|
Status of the standby supervisor: 1 = unknown 2 = disabled 3 = initialization 4 = negotiation 5 = standby cold 6 = standby cold configuration 7 = standby cold file system 8 = standby cold bulk 9 = standby hot 10 = active fast 11 = active drain 12 = active preconfiguration 13 = active post-configuration 14 = active 15 = active extra load 16 = active handback
|
CONN_UNIT_STATUS
|
INTEGER
|
—
|
Connection unit status: 0 = unknown 1 = unused 2 = OK 3 = warning: needs attention 4 = failed
|
FEATURE_FLAG
|
INTEGER
|
—
|
Licensed features. Refer to CISCO-FEATURE-CONTROL-MIB for details.
|
IS_LICENSE_VIOLATION
|
BOOLEAN
|
—
|
Indication of whether the switch has a license violation.
|
VERSION
|
VARCHAR
|
—
|
Version of the switch.
|
IS_PRESENT
|
BOOLEAN
|
—
|
Indication of whether the switch is present.
|
SERIAL_NUMBER
|
VARCHAR
|
—
|
Serial number of the switch.
|
NUM_PORTS
|
INTEGER
|
—
|
Number of FC ports in the switch.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
LAST_SCAN_TIME
|
BIGINT
|
—
|
Time when last seen, in milliseconds since 1/1/1970.
|
IS_TRAP_REGISTERED
|
BOOLEAN
|
—
|
Indication of whether the trap receiver is registered in the switch.
|
IS_SYSLOG_REGISTERED
|
BOOLEAN
|
—
|
Indicate whether the syslog receiver is registered in the switch.
|
SYS_DESCRIPTION
|
VARCHAR
|
—
|
Deprecated.
|
VENDOR
|
VARCHAR
|
—
|
Deprecated.
|
FCFE_MODULE_ID
|
INTEGER
|
—
|
Deprecated.
|
STANDBY_SUP_SLOT
|
INTEGER
|
—
|
Slot number of the standby supervisor card.
|
MODULE_INDEX_OFFSET
|
INTEGER
|
—
|
Module index offset.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
Table 1-42 TYPE Field Description in SWITCH Table
TYPE Field Value
|
Description
|
375
|
Cisco MDS 9506 chassis
|
376
|
Cisco MDS 9509 chassis
|
377
|
Cisco MDS 9513 chassis
|
380
|
Cisco MDS 9216 chassis
|
411
|
Cisco MDS 9140, 40-port fixed configuration fabric switch chassis
|
414
|
Cisco MDS 9120, 20-port fixed configuration fabric switch chassis
|
442
|
Cisco MDS 9216A chassis
|
472
|
Cisco 2-Slot MDS fabric switch chassis
|
475
|
Cisco SN 5428
|
514
|
Cisco MDS 9020-20K9, 20-port 4 Gbps FC fabric switch
|
529
|
Cisco SN 5428-2
|
587
|
Cisco MDS 9124
|
601
|
Cisco IBM_BLADE_SERVER
|
606
|
Cisco HP_BLADE_SERVER
|
SWITCH_MGMT_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-43 describes the SWITCH_MGMT_ADDRESS database schema table.
Table 1-43 SWITCH_MGMT_ADDRESS Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
SWITCH_ID
|
BIGINT
|
NOT NULL
|
ID of the switch.
|
MGMT_ADDRESS
|
BINARY
|
—
|
Management IP address.
|
MGMT_TYPE
|
TINYINT
|
—
|
Deprecated.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
SWITCH_PORT
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-44 describes the SWITCH_PORT database schema table.
Table 1-44 SWITCH_PORT Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
Primary key of the database entry.
|
IF_INDEX
|
INTEGER
|
—
|
Interface index of the port.
|
SWITCH_ID1
|
BIGINT
|
—
|
ID of the parent switch.
|
WWN
|
BINARY(8)
|
—
|
WWN of the port.
|
FICON_PORT_ADDRESS
|
BINARY
|
—
|
FICON address.
|
IS_HUB
|
BOOLEAN
|
—
|
Indication of whether the port is a hub.
|
IS_CHANNEL
|
BOOLEAN
|
—
|
Indication of whether the port belongs to a PortChannel.
|
CHANNEL_ID2
|
BIGINT
|
—
|
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
|
BOOLEAN
|
—
|
Deprecated.
|
PORT_GROUP
|
INTEGER
|
—
|
Port group calculated from the port index; applies only to a 32-port card.
|
IF_SPEED
|
BIGINT
|
—
|
Port speed in bits per second.
|
IF_NAME
|
VARCHAR
|
—
|
Port interface name.
|
IF_TYPE
|
INTEGER
|
—
|
Port interface type. Refer to values for IANAifType in IANAifType-MIB.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
USERFABRIC_INFO
This table describes the user of a fabric. Table 1-45 describes the USERFABRIC_INFO database schema table.
Table 1-45 USERFABRIC_INFO Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
FMUSER_ID1
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the Fabric Manager user.
|
FABRIC_ID1
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the fabric.
|
SNMPUSER_ID
|
BIGINT
|
—
|
ID of the SNMP user.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
VSAN
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-46 describes the VSAN database schema table.
Table 1-46 VSAN Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry in the table.
|
NAME
|
VARCHAR
|
—
|
Name of the VSAN.
|
IS_UP
|
BOOLEAN
|
—
|
Indication of whether the VSAN is up.
|
IS_DISJOINT
|
BOOLEAN
|
—
|
Indication of whether the VSAN is segmented.
|
SEED_SWITCH_ID
|
BIGINT
|
—
|
ID of the seed switch.
|
ENF_ZONESET_NAME
|
VARCHAR
|
—
|
Active zone set name.
|
ENF_ZONESET_ACTIVATE_TIME
|
BIGINT
|
—
|
Time in milliseconds when the zone set is activated.
|
FABRIC_ID1
|
BIGINT
|
—
|
Parent fabric ID.
|
VSAN_ID1, 2
|
INTEGER
|
—
|
VSAN ID.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
PRINCIPAL_SWWN
|
BINARY
|
—
|
WWN of the principle switch.
|
FICON_STATE
|
INTEGER
|
—
|
FICON state: 0 = non-FICON 1 = offline 2 = online
|
INTER_OPER_MODE
|
INTEGER
|
—
|
Interoperation mode of the VSAN: 0 = disabled 1 to 4 = enabled
|
PRINCIPAL_SW_ID
|
BIGINT
|
—
|
ID of the principal switch.
|
ADMIN_STATE
|
TINYINT
|
—
|
Administrative state of the VSAN: 1 = active 2 = suspended
|
MTU
|
INTEGER
|
—
|
MTU of the VSAN.
|
LOAD_BALANCING_TYPE
|
TINYINT
|
—
|
Type of load balancing used by the VSAN: 1 = source and destination IDs only 2 = source, destination, and originator exchange IDs
|
INORDER_DELIVERY
|
BOOLEAN
|
—
|
Indication of whether in-order delivery is guaranteed.
|
NETWORK_DROP_LATENCY
|
INTEGER
|
—
|
The network drop latency in milliseconds.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
VSAN_DOMAIN_INFO
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-47 describes the VSAN_DOMAIN_INFO database schema table.
Table 1-47 VSAN_DOMAIN_INFO Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
VSAN_ID1
|
BIGINT
|
NOT NULL
|
ID of the VSAN.
|
SWITCH_ID2
|
BIGINT
|
NOT NULL
|
ID of the switch.
|
DOMAIN_ID
|
SMALLINT
|
—
|
Domain of the switch in the VSAN.
|
WWN
|
BINARY
|
—
|
WWN of the switch in the VSAN.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
VSAN_ENDPORT_INFO
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-48 describes the VSAN_ENDPORT_INFO database schema table.
Table 1-48 VSAN_ENDPORT_INFO Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
VSAN_ID1
|
BIGINT
|
NOT NULL
|
ID of the VSAN.
|
ENDPORT_ID2
|
BIGINT
|
NOT NULL
|
ID of the end port.
|
FCID
|
INTEGER
|
—
|
FC ID of the end port in the VSAN.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
VSAN_ISL_INFO
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-49 describes the VSAN_ISL_INFO database schema table.
Table 1-49 VSAN_ISL_INFO Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
VSAN_ID1
|
BIGINT
|
NOT NULL
|
ID of the VSAN.
|
ISL_ID2
|
BIGINT
|
NOT NULL
|
ID of the ISL.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
ZONE
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-50 describes the ZONE database schema table.
Table 1-50 ZONE Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry in the table.
|
PARENT_ID1
|
BIGINT
|
—
|
T ID of the parent. Parent could be either a fabric (IVR zone) or VSAN.
|
IS_IVR
|
BOOLEAN
|
—
|
Indication of whether the zone is an IVR zone.
|
ZONE_INDEX
|
INTEGER
|
—
|
Index of the zone.
|
NAME
|
VARCHAR
|
—
|
Name of the zone.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
READ_ONLY
|
BOOLEAN
|
—
|
Indication of whether the zone can be modified.
|
QOS
|
BOOLEAN
|
—
|
Indication of whether QoS is supported by the zone.
|
QOS_PRIORITY
|
INTEGER
|
—
|
Priority of the LUN: 1 = none 2 = low 3 = medium 4 = high
|
BROADCAST
|
BOOLEAN
|
—
|
Indication of whether the zone supports broadcast.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|
ZONE_MEMBER
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-51 describes the ZONE_MEMBER database schema table.
Table 1-51 ZONE_MEMBER Fabric Manager Server Database Schema Table
Column Name
|
Data Type
|
Constraints
|
Description
|
ID
|
BIGINT
|
NOT NULL PRIMARY KEY
|
ID of the entry in the table.
|
ZONE_ID1
|
BIGINT
|
—
|
ID of the parent zone.
|
TYPE
|
INTEGER
|
—
|
Type of the member: 1 = zone 2 = alias
|
MEMBER_ID2
|
BINARY
|
—
|
ID of the zone member.
|
LUN_ID3
|
OBJECT
|
—
|
ID of LUNs.
|
LAST_UPDATE_TIME
|
TIMESTAMP
|
—
|
Time when the entry was updated.
|
IVR_VSAN_ID
|
BIGINT
|
—
|
VSAN ID for the IVR zone member.
|
PORT_STATUS
|
BINARY
|
—
|
Deprecated.
|
AFID
|
INTEGER
|
—
|
AFID of the IVR zone member.
|
RESERVE_COL1
|
VARCHAR
|
—
|
Deprecated.
|
RESERVE_COL2
|
VARCHAR
|
—
|
Deprecated.
|