Manuals
/
Brands
/
Computer Equipment
/
Software
/
HP
/
Computer Equipment
/
Software
HP
3PAR System Reporter E-Media Kit, System Reporter Media Kit manual
1
1
378
378
Download
378 pages, 2.5 Mb
3PAR
®
System Reporter 2.8 User’s Guide
3PAR, Inc.
4209 Technology Drive
Fremont, CA 94538 USA
Part No.
320-200257
Rev A
November 2010
Contents
3PAR® System Reporter 2.8 User’s Guide
Page
Page
Page
Page
Page
Page
Page
Page
Page
Table of Contents
1 Introduction
2 Overview and Features
3 Installation, Configuration, Update, and Removal
4 Getting Started
5 Accessing and Creating Reports
Page
Page
6 Interpreting Report Metrics
7 Configuring the System Reporter Policy Settings
8 Web Queries
Page
Page
9Using Adaptive Optimization
10 Database Schema
11 Troubleshooting
IX Index
RH Revision History
Page
1 Introduction
1.1 Audience
1.2 User Interfaces
1.3Related Documentation
1.4 Organization
1.5 Typographical Conventions
1.6 Advisories
Overview and Features
2.1 About 3PAR System Reporter
2.2Configuring System Reporter Policy Settings
2.3 Choosing a Method for Accessing Reports
2.4 Creating Customized Reports
Page
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
Page
3.3 System Requirements
Page
3.4 Using the System Reporter Sizing Spreadsheet
Page
Page
3.5 System Reporter Components
Page
3.6 Installing the System Reporter Components
Page
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
Page
Page
Page
3.9.0.2 Installing System Reporter Tools on Linux
Page
Page
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
Page
3.12 Removing the System Reporter Components
3.12.1 Removing the System Reporter Tools on Windows
3.12.2Removing the System Reporter Tools on Linux
3.12.3Removing the MySQL Database (Optional)
Page
Getting Started
4.1 Accessing the Main System Reporter Interface
Page
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-SelectionControl
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
Page
Page
4.5.2.2 Setting the Security Level for Excel
Page
4.5.3 Connecting to the Web Server from the Excel Client
Page
4.6 Changing the Excel Client Server and Resetting the Workbook
4.6.1 Changing the Web Server
4.6.2Resetting the Workbook
4.7Accessing the Excel Client Query Log
4.8 Deleting Excel Sheets
4.8.1 Deleting Menu Sheets
4.8.2Deleting Data Sheets
4.8.3Deleting the Query Log
4.9Saving and Exiting the Excel Client
Page
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
Page
5.3.1.3 Select Systems
5.3.1.4 Select Domains
5.3.2 Generating the Report
Page
Page
Page
5.3.3 Controls Available by Report
Page
Page
5.3.4 Report Selection
5.3.4.1 Standard Report Types
Page
Page
Page
Page
Page
5.3.4.2 Select Summary Columns
5.3.4.3 Compare
5.3.4.4 Select Peak
5.3.4.5 Group By
Page
Page
5.3.4.6 Order By
Page
5.3.4.7 Low Bucket
5.3.4.8 High Bucket
5.3.4.9 Sum End Buckets
5.3.5Time Selection
5.3.5.1Reload 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.6Include 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.16Select 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
Page
Page
Page
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
Page
5.4.3Retaining Charts
5.4.4Exporting Executable Reports
5.4.5Customizing Excel Reports
5.4.5.1 Adding Custom Columns to a Data Sheet
5.4.5.2 Creating a Custom Chart
Page
5.4.5.3 Saving Customized Settings
Interpreting Report Metrics
6.1 Summary Report
Page
Page
Page
Page
6.2 Space Reports
6.2.1 PD Space Reports
6.2.2 LD Space Reports
6.2.3 VV Space Reports
Page
Page
6.3 Performance Reports
6.3.1 Common Performance Metrics
Page
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
7.1 Accessing the System Reporter Policies
7.2 Configuring Sampling Policies
7.2.1 Compacting Databases
7.2.2 Editing Sampling Policies
Page
7.3Adding, Removing and Re-ConfiguringInServ Storage Systems
7.3.1Adding a Storage Server
7.3.2 Verifying Addition of a Storage Server
7.3.3 Removing a Storage Server
7.3.4 Re-Configuringa Storage Server Sampling
7.4 Configuring Rules for Email Alerts
7.4.1 Adding an Alert Rule
7.4.2Changing an Alert Rule
7.4.3Removing an Alert Rule
7.4.4Alert Rule Parameters
7.4.4.1 Data Table
7.4.4.2 Resolution
7.4.4.3 System
7.4.4.4 Metric
Page
Page
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.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
Page
Web Queries
8.1 About Web Queries
8.2 Data Format Version Report
Page
8.3 About Reports and Options
8.4 Report Options
8.4.1 category
8.4.1.1 example:
8.4.2 compare
8.4.2.1 values:
Page
8.4.2.2 example:
8.4.3 comparesel
8.4.3.1 values:
8.4.4 table
8.4.4.1 values:
8.4.4.2 example:
8.4.5 refresh
8.4.5.1 values:
8.4.5.2 example:
8.4.6 charttab
8.4.6.1 values:
8.4.7 charttype
8.4.7.1 values:
8.4.7.2 example:
8.4.8 graphx
8.4.8.1 value:
8.4.8.2 example:
8.4.9 graphy
8.4.9.1 value:
8.4.10 graphlegpos
8.4.10.1 value:
8.4.10.2 example:
8.4.11 tableformat
8.4.11.1 value:
8.4.12 alllabels
8.4.12.1 values:
8.4.12.2 example:
8.4.13 timeform
8.4.13.1 values:
8.4.13.2 example:
8.4.14 begintsecs
8.4.14.1 value:
8.4.15 endtsecs
8.4.15.1 value:
8.4.15.2 example:
8.4.16 groupby
8.4.16.1 values:
Page
8.4.16.2 example:
8.4.17 orderby
8.4.17.1 values:
Page
Page
Page
8.4.17.2 example:
8.4.18 histbegin
8.4.18.1 values:
8.4.18.2 example:
8.4.19 ldspaceunit
8.4.19.1 values:
8.4.20 pdspaceunit
8.4.20.1 values:
8.4.20.2 examples:
8.4.21 vvspaceunit
8.4.21.1 values:
8.4.21.2 examples:
8.4.22 selcageid
8.4.22.1 value:
8.4.22.2 examples:
8.4.23 selchunks
8.4.23.1 values:
8.4.23.2 example:
8.4.24 selcpg
8.4.24.1 value:
8.4.24.2 example:
8.4.25 selusrcpg
8.4.26 selsnpcpg
8.4.28 seldiskspeed
8.4.28.1 value:
8.4.28.2 example:
8.4.29 seldomain
8.4.29.1 value:
8.4.29.2 example:
8.4.30 selhost
8.4.30.1 value:
8.4.30.2 example:
8.4.31 selld
8.4.31.1 value:
8.4.31.2 example:
8.4.32 sellduse
8.4.32.1 values:
8.4.33 selnode
8.4.33.1 value:
8.4.33.2 example:
8.4.34 selnsp
8.4.34.1 value:
8.4.34.2 example:
8.4.35 selpdid
8.4.35.1 value:
8.4.35.2 example:
8.4.36 selpdstate
8.4.36.1 values:
8.4.36.2 example:
8.4.37 selporttype
8.4.37.1 values:
8.4.38 selraidtype
8.4.38.1 values:
8.4.38.2 example:
8.4.39 selsys
8.4.39.1 values:
8.4.39.2 example:
8.4.40 selvv
8.4.40.1 values:
8.4.40.2 example:
8.4.41 selvvtype
8.4.41.1 values:
8.4.42 selprovtype
8.4.42.1 values:
8.5 Report Types
8.6Summary Report
8.6.1 summary
8.6.1.1 example:
8.7 Space Reports
8.7.1 pd_space_time
8.7.3 ld_space_time
8.7.3.1 example:
8.7.4 ld_space_group
8.7.4.1 example:
8.7.5 vv_space_time
8.8 Performance Reports
8.8.1pd_perf_time
8.8.1.1 example:
8.8.2 pd_perf_group
8.8.2.1 example:
8.8.3 pd_svt_hist
8.8.3.1 example:
8.8.4 pd_svt_histvstime
8.8.4.1 example:
8.8.5 port_perf_time
8.8.5.1 example:
8.8.6 port_perf_group
8.8.7 port_svt_hist
8.8.7.1 example:
8.8.8 port_svt_histvstime
8.8.8.1 example:
8.8.9 ld_perf_time
8.8.10 ld_perf_group
8.8.10.1 example:
8.8.11 ld_svt_hist
8.8.11.1 example:
8.8.12 ld_svt_histvstime
8.8.13 vlun_perf_time
8.8.13.1 example:
8.8.14 vlun_perf_group
8.8.14.1 example:
8.8.15 vlun_svt_hist
8.8.16 vlun_svt_histvstime
8.8.16.1 example:
8.8.17 vv_cmp_time
8.8.17.1 example:
8.8.18 vv_cmp_group
8.8.19 cpu_perf_time
8.8.19.1 example:
8.8.20 cpu_perf_group
8.8.20.1 example:
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.10 Options Available by Report
Page
Page
Page
Page
8.11 Objects Present Reports
Page
Page
Page
8.11.1 objectpres= cageid
8.11.1.1 example:
8.11.1.2 output:
8.11.2 objectpres= cpg_name
8.11.2.1 example:
8.11.2.2 output:
8.11.3 objectpres= diskspeed
8.11.3.1 example:
8.11.3.2 output:
8.11.4objectpres= disktype
8.11.4.1 example:
8.11.4.2 output:
8.11.5 objectpres= domain_name
8.11.5.1 example:
8.11.5.2 output:
8.11.6objectpres= host_name
8.11.6.1 example:
8.11.7 objectpres= ld_name
8.11.7.1 example:
8.11.7.2 output:
8.11.8 objectpres=node
8.11.8.1 example:
8.11.8.2 output:
8.11.9 objectpres=pdid
8.11.9.1 example:
8.11.9.2 output:
8.11.10 objectpres=port
8.11.10.1 example:
8.11.10.2 output:
8.11.11 objectpres= system
8.11.11.1 example:
8.11.11.2 output:
8.11.12 objectpres= vv_name
8.11.12.1 example:
8.11.12.2 output:
8.11.13 objectpres= vv_name_nosnap
8.11.13.1 example:
8.11.13.2 output:
8.11.14 objecctpres= porttype
8.11.14.1 example:
8.11.14.2 output:
8.11.15 sample_times
8.11.15.1 example:
8.11.15.2 output:
Page
Page
Using Adaptive Optimization
9.1 Overview
Page
9.2 Selecting an InServ for Adaptive Optimization
9.3 Configuring Adaptive Optimization
Page
9.3.1Tier Definition (CPG Name and GiB)
Page
Page
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
Page
Page
9.4.2 VV Tiers Report
9.4.3 Adaptive Optimization Space Moved Report
9.5 The showvvcpg CLI extension
Page
Page
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
Page
10.3.5 The scheduled_report Table
Page
10.3.6 The scheduled_report_log Table
10.3.7 The adprovconfig Table
Page
10.3.8 The adprov_log Table
10.3.9 The ldrgmoves Table
Page
10.3.10 The recentsample Table
10.4 The Sample Data and Inventory Tables
10.4.1 The pdspace Table
Page
Page
10.4.2 The pdspaceinv Table
10.4.3 The ldspace Table
Page
10.4.4 The ldspaceinv Table
10.4.5 The vvspace Table
Page
Page
10.4.6 The vvspaceinv Table
Page
10.4.7 The cpgspace Table
Page
10.4.8 The cpgspaceinv Table
10.4.9 Common Performance Table Columns
Page
Page
Page
Page
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
Page
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
Page
10.4.16 The statvlun Table
10.4.17 The statvluninv Table
10.4.18 The statvvcmp Table
Page
10.4.19 The statvvcmpinv Table
10.4.20 The statcpu Table
Page
10.4.21 The statcpuinv Table
10.4.22 The statlink Table
Page
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
Page
11 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
Page
11.6.1 Examples of Using sysbck for Various Databases
Page
Page
Page
11.7 Dumping the Entire Database
11.7.1 Dumping the Entire SQLite Database
11.7.2 Dumping the Entire MySQL Database
Page
Index
IX.2 Index
Page
IX.4 Index
Page
IX.6 Index
Revision History
RH.1
RH.2
RH.3
RH.4
RH.5
RH.6
RH.7
RH.8