Document Outline

• HP 3PAR System Reporter 3.1 Software
• Contents
• 1 Overview and Features
  • User Interfaces
  • About System Reporter
  • Configuring System Reporter Policy Settings
  • Choosing a Method for Accessing Reports
  • Creating Customized Reports
  • Formatting Reports for Presentation
  • Customizing the Reporting Format
  • Generating Email Alerts
  • Accessing Report Data using Web Queries
  • Using the Database Schema to Build Custom Reports
  • Analyzing and Optimizing Storage Utilization
• 2 Installation, Configuration, Update, and Removal
  • Before You Begin
  • System Reporter CD Contents
  • System Requirements
  • Using the System Reporter Sizing Spreadsheet
  • System Reporter Components
  • Installing the System Reporter Components
    • Required Components
    • Optional Components
  • Installing the Web Server
  • Installing the Database Server
    • Choosing the Appropriate Database
      • SQLite
      • Microsoft SQL
      • MySQL
      • Oracle
    • Installing and Setting Up the Microsoft SQL Server Database (Optional)
      • System Reporter Host Configuration
    • Installing and Setting Up the MySQL Database (Optional)
      • Installing MySQL Server
      • Configuring the MySQL Database
      • Setting the max_allowed_packet parameter
      • Creating MySQL Users and Schema
    • Setting Up the Oracle Database (Optional)
      • Creating an Oracle database
      • Creating the Oracle Users for System Reporter
      • Creating the Oracle Net Service
  • Installing or Upgrading the System Reporter Tools
    • Installing or Upgrading System Reporter Tools on Windows
    • Installing System Reporter Tools on Linux
    • Adding Storage Systems
      • Setting File Permissions (Optional)
      • Verifying Installation
  • Installing the Excel Client (Optional)
  • About Apache HTTP Server Authorization and Access Control
  • Removing the System Reporter Components
    • Removing the System Reporter Tools on Windows
    • Removing the System Reporter Tools on Linux
    • Removing the MySQL Database (Optional)
• 3 Getting Started
  • Accessing the Main System Reporter Interface
  • System Reporter Main Menu Window
  • Getting Help
  • Using the Object Selection Controls
    • Simple Selection List
    • Filtered Multi-Selection Control
  • Accessing the Optional Excel Client
    • Starting the System Reporter Excel Client
    • Setting the Security Level for Excel
      • Setting the Security for Excel 2003
      • Setting the Security Level for Excel 2007
    • Connecting to the Web Server from the Excel Client
  • Changing the Excel Client Server and Resetting the Workbook
    • Changing the Web Server
    • Resetting the Workbook
  • Accessing the Excel Client Query Log
  • Deleting Excel Sheets
    • Deleting Menu Sheets
    • Deleting Data Sheets
    • Deleting the Query Log
    • Saving and Exiting the Excel Client
• 4 Accessing and Creating Reports
  • Accessing Quick Reports
  • Accessing Scheduled Reports
  • Creating Custom Reports
    • Building the Report Menu
      • Sample Resolution
      • Report
      • Select Systems
      • Select Domains
    • Generating the Report
    • Controls Available by Report
    • Report Selection
      • Standard Report Types
      • Select Summary Columns
      • Compare
      • Max. Number
      • Select Peak
      • Group By
      • Order By
      • Low Bucket
      • High Bucket
      • Sum End Buckets
    • Time Selection
      • Reload After (mins)
      • Begin/At Time
      • End Time
      • Count
    • Object Selection
      • Select PDIDs
      • Include Chunklets
      • Select Cage IDs
      • Select Disk Types
      • Select Disk Speed
      • Include PDs in States
      • Select Usr CPGs
      • Select Snp CPGs
      • Select CPGs
      • Select LDs
      • Select RAID Types
      • Select LD Usage
      • Select LUN
      • Select VVs
      • Select Prov Types
      • Select VV Types
      • Select Port Types
      • Select Port Rates
      • Select Ports (n:s:p)
      • Select Hosts
      • Select Nodes
      • Select To Nodes
      • Select Queues
    • Format Selection (Web interface only)
      • Report Information
      • Chart Lib
      • Chart Types
      • Chart X Pixels
      • Chart Y Pixels
      • Time Labels
      • Legend Position
      • Time Format
      • Select Space Unit
  • Working with Excel Charts
    • Choosing a Chart Type
    • Refreshing Charts
    • Retaining Charts
    • Exporting Executable Reports
    • Customizing Excel Reports
      • Adding Custom Columns to a Data Sheet
      • Creating a Custom Chart
      • Saving Customized Settings
• 5 Interpreting Report Metrics
  • Summary Report
  • Space Reports
    • PD Space Reports
    • CPG Space Reports
    • LD Space Reports
    • VV Space Reports
  • Performance Reports
    • Common Performance Metrics
    • VV Cache Performance Reports
    • Node Cache Performance Reports
    • CPU Performance Reports
    • Link Performance Reports
  • Adaptive Optimization Reports
• 6 Configuring the System Reporter Policy Settings
  • Accessing the System Reporter Policies
  • Configuring Sampling Policies
    • Compacting Databases
    • Editing Sampling Policies
  • Adding, Removing and Re-Configuring HP 3PAR StoreServ Storage Systems
    • Adding a Storage System
    • Verifying Addition of a Storage System
    • Removing a Storage Server
    • Re-Configuring a Storage Server Sampling
  • Configuring Rules for Email Alerts
    • Adding an Alert Rule
    • Changing an Alert Rule
    • Removing an Alert Rule
    • Alert Rule Parameters
      • Data Table
      • Resolution
      • System
      • Metric
      • Direction
      • Limit Value
      • Limit Count
      • Condition
      • Condition Value
      • Recipient
    • Example of an Alert Rule
  • Scheduling Reports
    • Adding a Scheduled Report
    • Changing a Scheduled Report
    • Removing a Scheduled Report
  • Configuring Adaptive Optimization
  • About File Permissions
  • Modifying the Apache HTTP Server Configuration Files
• 7 Web Queries
  • About Web Queries
  • Data Format Version Report
  • About Reports and Options
  • Report Options
    • category
      • example:
    • compare
      • values:
      • example:
    • comparesel
      • values:
    • table
      • values:
      • example:
    • refresh
      • values:
      • example:
    • charttab
      • values:
      • example:
    • charttype
      • values:
      • example:
    • graphx
      • value:
      • example:
    • graphy
      • value:
      • example:
    • graphlegpos
      • value:
      • example:
    • tableformat
      • value:
      • example:
    • alllabels
      • values:
      • example:
    • timeform
      • values:
      • example:
    • begintsecs
      • value:
      • example:
    • endtsecs
      • value:
      • example:
    • groupby
      • values:
      • example:
    • orderby
      • values:
      • example:
    • histbegin
      • values:
      • example:
    • ldspaceunit
      • values:
      • examples:
    • pdspaceunit
      • values:
      • examples:
    • vvspaceunit
      • values:
      • examples:
    • selcageid
      • value:
      • examples:
    • selchunks
      • values:
      • example:
    • selcpg
      • value:
      • example:
    • selusrcpg
    • selsnpcpg
    • seldisktype
      • value:
      • example:
    • seldiskspeed
      • value:
      • example:
    • seldomain
      • value:
      • example:
    • selhost
      • value:
      • example:
    • selld
      • value:
      • example:
    • sellduse
      • values:
      • example:
    • selnode
      • value:
      • example:
    • selnsp
      • value:
      • example:
    • selpdid
      • value:
      • example:
    • selpdstate
      • values:
      • example:
    • selporttype
      • values:
      • example:
    • selraidtype
      • values:
      • example:
    • selsys
      • values:
      • example:
    • selvv
      • values:
      • example:
    • selvvtype
      • values:
    • selprovtype
      • values:
    • Chartlib
    • Maxgraph
  • Report Types
  • Summary Report
    • summary
      • example:
  • Space Reports
    • pd_space_time
      • example:
    • pd_space_group
      • example:
    • ld_space_time
      • example:
    • ld_space_group
      • example:
    • vv_space_time
      • example:
    • vv_space_group
      • example:
    • vv_space_time
      • example:
    • vv_space_group
      • example:
  • Performance Reports
    • pd_perf_time
      • example:
    • pd_perf_group
      • example:
    • pd_svt_hist
      • example:
    • pd_svt_histvstime
      • example:
    • port_perf_time
      • example:
    • port_perf_group
      • example:
    • port_svt_hist
      • example:
    • port_svt_histvstime
      • example:
    • ld_perf_time
      • example:
    • ld_perf_group
      • example:
    • ld_svt_hist
      • example:
    • ld_svt_histvstime
      • example:
    • vlun_perf_time
      • example:
    • vlun_perf_group
      • example:
    • vlun_svt_hist
      • example:
    • vlun_svt_histvstime
      • example:
    • vv_cmp_time
      • example:
    • vv_cmp_group
      • example:
    • cpu_perf_time
      • example:
    • cpu_perf_group
      • example:
  • Adaptive Optimization Reports
    • regiodensity
      • regiondensity example
    • regmoves
      • regmoves example
    • vvtier
      • vvtier example
  • Options Available by Report
  • Objects Present Reports
    • objectpres= cageid
      • example:
        • output:
    • objectpres= cpg_name
      • example:
      • output:
    • objectpres= diskspeed
      • example:
      • output:
    • objectpres= disktype
      • example:
      • output:
    • objectpres= domain_name
      • example:
      • output:
    • objectpres= host_name
      • example:
      • output:
    • objectpres= ld_name
      • example:
      • output:
    • objectpres=node
      • example:
      • output:
    • objectpres=pdid
      • example:
      • output:
    • objectpres=port
      • example:
      • output:
    • objectpres= system
      • example:
      • output:
    • objectpres= vv_name
      • example:
      • output:
    • objectpres= vv_name_nosnap
      • example:
      • output:
    • objecctpres= porttype
      • example:
      • output:
    • sample_times
      • example:
      • output:
• 8 Using Adaptive Optimization
  • Overview
  • Selecting an HP 3PAR StoreServ Storage for Adaptive Optimization
  • Configuring Adaptive Optimization
    • Tier Definition (CPG Name and GiB)
    • Schedule
    • Measurement Hours
    • Adaptive Optimization Mode
    • Adaptive Optimization Active
    • Adding an Adaptive Optimization Configuration
    • Changing an Adaptive Optimization Configuration
    • Removing an Adaptive Optimization Configuration
  • Adaptive Optimization Reports
    • Region IO Density Report
    • VV Tiers Report
    • Adaptive Optimization Space Moved Report
  • The showvvcpg CLI extension
• 9 Database Schema
  • Using The Database Schema
  • Table Versions and Naming Conventions
  • Administrative Tables
    • The policy Table
    • The sampleinserv Table
    • The system Table
    • The alertconfig Table
    • The scheduled_report Table
    • The scheduled_report_log Table
    • The adprovconfig Table
    • The adprov_log Table
    • The ldrgmoves Table
    • The recentsample Table
  • The Sample Data and Inventory Tables
    • The pdspace Table
    • The pdspaceinv Table
    • The ldspace Table
    • The ldspaceinv Table
    • The vvspace Table
    • The vvspaceinv Table
    • The cpgspace Table
    • The cpgspaceinv Table
    • Common Performance Table Columns
      • Calculating Common Performance Metrics
      • Service Time Histogram Buckets
      • IO Size Histogram Buckets
    • The statpd Table
    • The statpdinv Table
    • The statld Table
    • The statldinv Table
    • The statport Table
    • The statportinv Table
    • The statvlun Table
    • The statvluninv Table
    • The statvvcmp Table
    • The statvvcmpinv Table
    • The statcpu Table
    • The statcpuinv Table
    • The statlink Table
    • The statlinkinv Table
    • The statldrg Table
    • The statldrg_timeinv Table
    • The perf_timeinv Table
    • The space_timeinv Table
• 10 Troubleshooting System Reporter
  • Troubleshooting Overview
  • Troubleshooting the Sampling Components
    • Sampling Component Log Files
    • Installation Configuration
    • Sampling Errors
      • Errors incurred by the inservsample process
      • Errors incurred by the CLI sampler process.
    • Sampler Service/Daemon Errors
  • Troubleshooting Adaptive Optimization Components
  • Troubleshooting the Web Server Components
  • Troubleshooting the Excel Client
  • Extracting Data from the Database with sysbck
    • Examples of Using sysbck for Various Databases
  • Dumping the Entire Database
    • Dumping the Entire SQLite Database
    • Dumping the Entire MySQL Database
• 11 Support and Other Resources
  • Contacting HP
  • HP 3PAR documentation
  • Typographic conventions
  • HP 3PAR branding information
• 12 Documentation feedback
• Index