Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1139)

Brocade Network Advisor SAN User Manual 1087
53-1003154-01
SAN historical performance data
28
Performance database views
The following view names are used to extract data similar to the 11.3.0 database schema from the
server with the version greater than or equal to 12.0.2.
NOTE
The FC_PORT_STATS and FCIP_STATS views definition are available under the tree view of databases
>dcmdb>Schemas>dcm>Views node hierarchy and can be extracted from the 12.0.2 database
schema from the server by the following ways:
- Search for the view definitions with the view names at install-home>\conf\schema\dcm-postgres-schema.sql location
- Open the PostgreSQL user interface by double clicking on install-home>\bin\dbadmin.
• FC_PORT_STATS_5MIN_INFO
• FC_PORT_STATS_30MIN_INFO
• FC_PORT_STATS_2HOUR_INFO
• FC_PORT_STATS_1DAY_INFO
• FCIP_STATS_5MIN_INFO
• FCIP_STATS_30MIN_INFO
• FCIP_STATS_2HOUR_INFO
• FCIP_STATS_1DAY_INFO
The following EE_MONITOR_STATS and TE_PORT_STATS view names are used to extract data
similar to the 11.3.0 database schema from the server with the version greater than or equal to
12.0.0. Refer to
Appendix H, “Database Fields” for view definitions.
How to extract performance statistics data from the database
Following are the steps used to extract any PM data from the database:
• Check PM_DATA_COLLECTOR table, to identify the collector database ID
• Check PM_COLLECTOR_TIME_SERIES_MAPPING table, to find the mapping table that contains
the required data
• Construct the select query using the mapping table
Execute the following query to extract the FCIP tunnel statistics for last 1 day
Select * from TIME_SERIES_DATA_2 where COLLECTOR_ID = 13;
Execute the following query to extract the FC port statistics for last 3 days
Select * from TIME_SERIES_DATA_1_30MIN where COLLECTOR_ID = 11;
Execute the following query to extract the TE port statistics for last 30 days
Select * from TIME_SERIES_DATA_1_2HOUR where COLLECTOR_ID = 12;
Execute the following query to extract all SAN product statistics for last 730 days
select * from TIME_SERIES_DATA_2_1DAY where COLLECTOR_ID = 15;