Document Outline

• Table of Contents
  • 1 Introduction
  • 2 Overview and Features
  • 3 Installation, Configuration, Update, and Removal
  • 4 Getting Started
  • 5 Accessing and Creating Reports
  • 6 Interpreting Report Metrics
  • 7 Configuring the System Reporter Policy Settings
  • 8 Web Queries
  • 9 Using Adaptive Optimization
  • 10 Database Schema
  • 11 Troubleshooting
  • IX Index
  • RH Revision History
• Introduction
  • 1.1 Audience
  • 1.2 User Interfaces
  • 1.3 Related Documentation
  • 1.4 Organization
  • 1.5 Typographical Conventions
  • 1.6 Advisories
• Overview and Features
  • 2.1 About 3PAR System Reporter
  • 2.2 Configuring System Reporter Policy Settings
  • 2.3 Choosing a Method for Accessing Reports
  • 2.4 Creating Customized Reports
  • 2.5 Formatting Reports for Presentation
  • 2.6 Customizing the Reporting Format
  • 2.7 Generating Email Alerts
  • 2.8 Accessing Report Data using Web Queries
  • 2.9 Using the Database Schema to Build Custom Reports
  • 2.10 Analyzing and Optimizing Storage Utilization
• Installation, Configuration, Update, and Removal
  • 3.1 Before You Begin
  • 3.2 System Reporter CD Contents
  • 3.3 System Requirements
  • 3.4 Using the System Reporter Sizing Spreadsheet
  • 3.5 System Reporter Components
  • 3.6 Installing the System Reporter Components
  • 3.7 Installing the Web Server
  • 3.8 Installing the Database Server
    • 3.8.1 Choosing the Appropriate Database
      • 3.8.1.1 SQLite
      • 3.8.1.2 MySQL
      • 3.8.1.3 Oracle
    • 3.8.2 Installing and Setting Up the MySQL Database (Optional)
      • 3.8.2.1 Installing MySQL Server
      • 3.8.2.2 Configuring the MySQL Database
      • 3.8.2.3 Setting the max_allowed_packet parameter
      • 3.8.2.4 Creating MySQL Users and Schema
    • 3.8.3 Setting Up the Oracle Database (Optional)
      • 3.8.3.1 Creating an Oracle database
      • 3.8.3.2 Creating the Oracle Users for System Reporter
      • 3.8.3.3 Creating the Oracle Net Service
  • 3.9 Installing or Upgrading the System Reporter Tools
    • 3.9.0.1 Installing or Upgrading System Reporter Tools on Windows
    • 3.9.0.2 Installing System Reporter Tools on Linux
    • 3.9.1 Adding InServ Systems
      • 3.9.1.1 Setting File Permissions (Optional)
      • 3.9.1.2 Verifying Installation
  • 3.10 Installing the Excel Client (Optional)
  • 3.11 About Apache HTTP Server Authorization and Access Control
  • 3.12 Removing the System Reporter Components
    • 3.12.1 Removing the System Reporter Tools on Windows
    • 3.12.2 Removing the System Reporter Tools on Linux
    • 3.12.3 Removing the MySQL Database (Optional)
• Getting Started
  • 4.1 Accessing the Main System Reporter Interface
  • 4.2 System Reporter Main Menu Window
  • 4.3 Getting Help
  • 4.4 Using the Object Selection Controls
    • 4.4.1 Simple Selection List
    • 4.4.2 Filtered Multi-Selection Control
  • 4.5 Accessing the Optional Excel Client
    • 4.5.1 Starting the System Reporter Excel Client
    • 4.5.2 Setting the Security Level for Excel
      • 4.5.2.1 Setting the Security for Excel 2003
      • 4.5.2.2 Setting the Security Level for Excel 2007
    • 4.5.3 Connecting to the Web Server from the Excel Client
  • 4.6 Changing the Excel Client Server and Resetting the Workbook
    • 4.6.1 Changing the Web Server
    • 4.6.2 Resetting the Workbook
  • 4.7 Accessing the Excel Client Query Log
  • 4.8 Deleting Excel Sheets
    • 4.8.1 Deleting Menu Sheets
    • 4.8.2 Deleting Data Sheets
    • 4.8.3 Deleting the Query Log
  • 4.9 Saving and Exiting the Excel Client
• Accessing and Creating Reports
  • 5.1 Accessing Quick Reports
  • 5.2 Accessing Scheduled Reports
  • 5.3 Creating Custom Reports
    • 5.3.1 Building the Report Menu
      • 5.3.1.1 Sample Resolution
      • 5.3.1.2 Report
      • 5.3.1.3 Select Systems
      • 5.3.1.4 Select Domains
    • 5.3.2 Generating the Report
    • 5.3.3 Controls Available by Report
    • 5.3.4 Report Selection
      • 5.3.4.1 Standard Report Types
      • 5.3.4.2 Select Summary Columns
      • 5.3.4.3 Compare
      • 5.3.4.4 Select Peak
      • 5.3.4.5 Group By
      • 5.3.4.6 Order By
      • 5.3.4.7 Low Bucket
      • 5.3.4.8 High Bucket
      • 5.3.4.9 Sum End Buckets
    • 5.3.5 Time Selection
      • 5.3.5.1 Reload After (mins)
      • 5.3.5.2 Begin/At Time
      • 5.3.5.3 End Time
      • 5.3.5.4 Count
    • 5.3.6 Object Selection
      • 5.3.6.1 Select PDIDs
      • 5.3.6.2 Include Chunklets
      • 5.3.6.3 Select Cage IDs
      • 5.3.6.4 Select Disk Types
      • 5.3.6.5 Select Disk Speed
      • 5.3.6.6 Include PDs in States
      • 5.3.6.7 Select Usr CPGs
      • 5.3.6.8 Select Snp CPGs
      • 5.3.6.9 Select CPGs
      • 5.3.6.10 Select LDs
      • 5.3.6.11 Select RAID Types
      • 5.3.6.12 Select LD Usage
      • 5.3.6.13 Select VVs
      • 5.3.6.14 Select Prov Types
      • 5.3.6.15 Select VV Types
      • 5.3.6.16 Select Ports (n:s:p)
      • 5.3.6.17 Select Port Types
      • 5.3.6.18 Select Hosts
      • 5.3.6.19 Select Nodes
      • 5.3.6.20 Select To Nodes
      • 5.3.6.21 Select Queues
    • 5.3.7 Format Selection (Web interface only)
      • 5.3.7.1 Report Information
      • 5.3.7.2 Chart Types
      • 5.3.7.3 Chart X Pixels
      • 5.3.7.4 Chart Y Pixels
      • 5.3.7.5 Time Labels
      • 5.3.7.6 Legend Position
      • 5.3.7.7 Time Format
      • 5.3.7.8 Select Space Unit
  • 5.4 Working with Excel Charts
    • 5.4.1 Choosing a Chart Type
    • 5.4.2 Refreshing Charts
    • 5.4.3 Retaining Charts
    • 5.4.4 Exporting Executable Reports
    • 5.4.5 Customizing Excel Reports
      • 5.4.5.1 Adding Custom Columns to a Data Sheet
      • 5.4.5.2 Creating a Custom Chart
      • 5.4.5.3 Saving Customized Settings
• Interpreting Report Metrics
  • 6.1 Summary Report
  • 6.2 Space Reports
    • 6.2.1 PD Space Reports
    • 6.2.2 LD Space Reports
    • 6.2.3 VV Space Reports
  • 6.3 Performance Reports
    • 6.3.1 Common Performance Metrics
    • 6.3.2 VV Cache Performance Reports
    • 6.3.3 Node Cache Performance Reports
    • 6.3.4 CPU Performance Reports
    • 6.3.5 Link Performance Reports
  • 6.4 Adaptive Optimization Reports
• Configuring the System Reporter Policy Settings
  • 7.1 Accessing the System Reporter Policies
  • 7.2 Configuring Sampling Policies
    • 7.2.1 Compacting Databases
    • 7.2.2 Editing Sampling Policies
  • 7.3 Adding, Removing and Re-Configuring InServ Storage Systems
    • 7.3.1 Adding a Storage Server
    • 7.3.2 Verifying Addition of a Storage Server
    • 7.3.3 Removing a Storage Server
    • 7.3.4 Re-Configuring a Storage Server Sampling
  • 7.4 Configuring Rules for Email Alerts
    • 7.4.1 Adding an Alert Rule
    • 7.4.2 Changing an Alert Rule
    • 7.4.3 Removing an Alert Rule
    • 7.4.4 Alert Rule Parameters
      • 7.4.4.1 Data Table
      • 7.4.4.2 Resolution
      • 7.4.4.3 System
      • 7.4.4.4 Metric
      • 7.4.4.5 Direction
      • 7.4.4.6 Limit Value
      • 7.4.4.7 Limit Count
      • 7.4.4.8 Condition
      • 7.4.4.9 Condition Value
      • 7.4.4.10 Recipient
    • 7.4.5 Example of an Alert Rule
  • 7.5 Scheduling Reports
    • 7.5.1 Adding a Scheduled Report
    • 7.5.2 Changing a Scheduled Report
    • 7.5.3 Removing a Scheduled Report
  • 7.6 Configuring Adaptive Optimization
  • 7.7 About File Permissions
  • 7.8 Modifying the Apache HTTP Server Configuration Files
• Web Queries
  • 8.1 About Web Queries
  • 8.2 Data Format Version Report
  • 8.3 About Reports and Options
  • 8.4 Report Options
    • 8.4.1 category
    • 8.4.2 compare
    • 8.4.3 comparesel
    • 8.4.4 table
    • 8.4.5 refresh
    • 8.4.6 charttab
    • 8.4.7 charttype
    • 8.4.8 graphx
    • 8.4.9 graphy
    • 8.4.10 graphlegpos
    • 8.4.11 tableformat
    • 8.4.12 alllabels
    • 8.4.13 timeform
    • 8.4.14 begintsecs
    • 8.4.15 endtsecs
    • 8.4.16 groupby
    • 8.4.17 orderby
    • 8.4.18 histbegin
    • 8.4.19 ldspaceunit
    • 8.4.20 pdspaceunit
    • 8.4.21 vvspaceunit
    • 8.4.22 selcageid
    • 8.4.23 selchunks
    • 8.4.24 selcpg
    • 8.4.25 selusrcpg
    • 8.4.26 selsnpcpg
    • 8.4.27 seldisktype
    • 8.4.28 seldiskspeed
    • 8.4.29 seldomain
    • 8.4.30 selhost
    • 8.4.31 selld
    • 8.4.32 sellduse
    • 8.4.33 selnode
    • 8.4.34 selnsp
    • 8.4.35 selpdid
    • 8.4.36 selpdstate
    • 8.4.37 selporttype
    • 8.4.38 selraidtype
    • 8.4.39 selsys
    • 8.4.40 selvv
    • 8.4.41 selvvtype
    • 8.4.42 selprovtype
  • 8.5 Report Types
  • 8.6 Summary Report
    • 8.6.1 summary
  • 8.7 Space Reports
    • 8.7.1 pd_space_time
    • 8.7.2 pd_space_group
    • 8.7.3 ld_space_time
    • 8.7.4 ld_space_group
    • 8.7.5 vv_space_time
    • 8.7.6 vv_space_group
  • 8.8 Performance Reports
    • 8.8.1 pd_perf_time
    • 8.8.2 pd_perf_group
    • 8.8.3 pd_svt_hist
    • 8.8.4 pd_svt_histvstime
    • 8.8.5 port_perf_time
    • 8.8.6 port_perf_group
    • 8.8.7 port_svt_hist
    • 8.8.8 port_svt_histvstime
    • 8.8.9 ld_perf_time
    • 8.8.10 ld_perf_group
    • 8.8.11 ld_svt_hist
    • 8.8.12 ld_svt_histvstime
    • 8.8.13 vlun_perf_time
    • 8.8.14 vlun_perf_group
    • 8.8.15 vlun_svt_hist
    • 8.8.16 vlun_svt_histvstime
    • 8.8.17 vv_cmp_time
    • 8.8.18 vv_cmp_group
    • 8.8.19 cpu_perf_time
    • 8.8.20 cpu_perf_group
  • 8.9 Adaptive Optimization Reports
    • 8.9.1 regiodensity
      • 8.9.1.1 regiondensity example
    • 8.9.2 regmoves
      • 8.9.2.1 regmoves example
    • 8.9.3 vvtier
      • 8.9.3.1 vvtier example
  • 8.10 Options Available by Report
  • 8.11 Objects Present Reports
    • 8.11.1 objectpres= cageid
    • 8.11.2 objectpres= cpg_name
    • 8.11.3 objectpres= diskspeed
    • 8.11.4 objectpres= disktype
    • 8.11.5 objectpres= domain_name
    • 8.11.6 objectpres= host_name
    • 8.11.7 objectpres= ld_name
    • 8.11.8 objectpres=node
    • 8.11.9 objectpres=pdid
    • 8.11.10 objectpres=port
    • 8.11.11 objectpres= system
    • 8.11.12 objectpres= vv_name
    • 8.11.13 objectpres= vv_name_nosnap
    • 8.11.14 objecctpres= porttype
    • 8.11.15 sample_times
• Using Adaptive Optimization
  • 9.1 Overview
  • 9.2 Selecting an InServ for Adaptive Optimization
  • 9.3 Configuring Adaptive Optimization
    • 9.3.1 Tier Definition (CPG Name and GiB)
    • 9.3.2 Schedule
    • 9.3.3 Measurement Hours
    • 9.3.4 Adaptive Optimization Mode
    • 9.3.5 Adaptive Optimization Active
    • 9.3.6 Adding an Adaptive Optimization Configuration
    • 9.3.7 Changing an Adaptive Optimization Configuration
    • 9.3.8 Removing an Adaptive Optimization Configuration
  • 9.4 Adaptive Optimization Reports
    • 9.4.1 Region IO Density Report
    • 9.4.2 VV Tiers Report
    • 9.4.3 Adaptive Optimization Space Moved Report
  • 9.5 The showvvcpg CLI extension
• Database Schema
  • 10.1 Using The Database Schema
  • 10.2 Table Versions and Naming Conventions
  • 10.3 Administrative Tables
    • 10.3.1 The policy Table
    • 10.3.2 The sampleinserv Table
    • 10.3.3 The system Table
    • 10.3.4 The alertconfig Table
    • 10.3.5 The scheduled_report Table
    • 10.3.6 The scheduled_report_log Table
    • 10.3.7 The adprovconfig Table
    • 10.3.8 The adprov_log Table
    • 10.3.9 The ldrgmoves Table
    • 10.3.10 The recentsample Table
  • 10.4 The Sample Data and Inventory Tables
    • 10.4.1 The pdspace Table
    • 10.4.2 The pdspaceinv Table
    • 10.4.3 The ldspace Table
    • 10.4.4 The ldspaceinv Table
    • 10.4.5 The vvspace Table
    • 10.4.6 The vvspaceinv Table
    • 10.4.7 The cpgspace Table
    • 10.4.8 The cpgspaceinv Table
    • 10.4.9 Common Performance Table Columns
      • 10.4.9.1 Calculating Common Performance Metrics
      • 10.4.9.2 Service Time Histogram Buckets
      • 10.4.9.3 IO Size Histogram Buckets
    • 10.4.10 The statpd Table
    • 10.4.11 The statpdinv Table
    • 10.4.12 The statld Table
    • 10.4.13 The statldinv Table
    • 10.4.14 The statport Table
    • 10.4.15 The statportinv Table
    • 10.4.16 The statvlun Table
    • 10.4.17 The statvluninv Table
    • 10.4.18 The statvvcmp Table
    • 10.4.19 The statvvcmpinv Table
    • 10.4.20 The statcpu Table
    • 10.4.21 The statcpuinv Table
    • 10.4.22 The statlink Table
    • 10.4.23 The statlinkinv Table
    • 10.4.24 The statldrg Table
    • 10.4.25 The statldrg_timeinv Table
    • 10.4.26 The perf_timeinv Table
    • 10.4.27 The space_timeinv Table
• Troubleshooting
  • 11.1 Troubleshooting Overview
  • 11.2 Troubleshooting the Sampling Components
    • 11.2.1 Sampling Component Log Files
    • 11.2.2 Installation Configuration
    • 11.2.3 InServ Sampling Errors
      • 11.2.3.1 Errors incurred by the inservsample process
      • 11.2.3.2 Errors incurred by the CLI sampler process.
    • 11.2.4 Sampler Service/Daemon Errors
  • 11.3 Troubleshooting Adaptive Optimization Components
  • 11.4 Troubleshooting the Web Server Components
  • 11.5 Troubleshooting the Excel Client
  • 11.6 Extracting Data from the Database with sysbck
    • 11.6.1 Examples of Using sysbck for Various Databases
  • 11.7 Dumping the Entire Database
    • 11.7.1 Dumping the Entire SQLite Database
    • 11.7.2 Dumping the Entire MySQL Database
• Index
  • A
  • B
  • C
  • D
  • E
  • G
  • H
  • I
  • L
  • M
  • N
  • O
  • P
  • R
  • S
  • T
  • U
  • V
  • W
• Revision History