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.

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.

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.

1 EVENTS_SEVERITY_INDEX is an index based on the column SEVERITY.

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.

1 EVENT_FORWARD_ID_INDEX is an index based on the column ID.

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.

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.

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.

1 FICON_PORT_ID_INDEX is an index based on the column PORT_ID.

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.

1 FMUSER_USERNAME_INDEX is an index based on the column USER_NAME.

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.

1 GROUP_ID_INDEX is an index based on the column ID. 2 GROUP_FABRICID_NAME_INDEX is an index based on the columns FABRIC_ID and NAME.

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.

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.

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.

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.

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.

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.

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.

1 HW_COMPONENT_ID_INDEX is an index based on the column ID. 2 HW_COMPONENT_SWITCH_ID is an index based on the column SWITCH_ID.

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.

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.

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.

1 LICENSE_SWITCH_ID_INDEX is an index based on the column SWITCH_ID.

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.

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.

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.

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.

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.

1 PMDATAINDEX_LOGICALFILE_INDEX is an index based on the column LOGICALFILENAME.

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

1 PMEXTRAOID_FABRIC_ID_INDEX is an index based on the column FID.

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.

1 PMINDEXBOOKMARK_INDEX is an index based on the column TYPE.

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.

1 PM_POLICY_FABRIC_ID_INDEX is an index based on the column FABRIC_ID.

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.

1 SNMPUSER_USERNAME_INDEX is an index based on the column USER_NAME.

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.

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.

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.

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.

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.

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.

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.

1 STATISTICS_DEST_ID is an index based on the column DEST_ID.

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.

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.

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.

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.

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.

1 USERFABRIC_INDEX is an index based on the columns FMUSER_ID and FABRIC_ID.

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.

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.

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.

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.

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.

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.

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.

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.

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.

1 ZONE_VSAN_INDEX is an index based on the column PARENT_ID.

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.

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.