Manuals / Brands / Computer Equipment / Software / HP / Computer Equipment / Software

HP 3PAR System Reporter E-Media Kit, System Reporter Media Kit 3.8.1.2 MySQL, 3.8.1.3 Oracle

1 378

Download 378 pages, 2.5 Mb

System Reporter 2.8

3PAR System Reporter User’s Guide

SQLite supports only limited database concurrency because it relies on a single file lock for the entire database. The sampling process needs exclusive access to the database when inserting new samples. If the database is very large or if there are a large number of concurrent web requests, the sampler or the Web server can time out. Furthermore, database compaction (see

7.2.1Compacting Databases on page 7.3) cannot be done in parallel with sample insertion so there could be a large gap in samples during database compaction.

Sampling of multiple InServ Storage Servers is not supported with an SQLite database, either the MySQL or the Oracle database servers should be used instead.

For large databases (over about 1 GB) or a large number of concurrent Web users, either the MySQL® or the Oracle database servers should be used instead.

NOTE: The optionally licensed Adaptive Optimization feature is not supported with the SQLite database. Please consider another database if you plan on utilizing the storage optimization capabilities provided by Adaptive Optimization.

3.8.1.2 MySQL

A MySQL database server can be used with System reporter but is not included with it. You must purchase it separately. MySQL is a good choice for System reporter because it supports MyISAM tables. These tables do not support transactions (which are not required for System Reporter) and are consequently somewhat higher performance than Oracle for sample insertion and deletion.

3.8.1.3 Oracle

Beginning with the 2.4 release, System Reporter also supports an Oracle 11g database server but it is not included with it. You must purchase it separately. Compared with MySQL, Oracle is slightly slower and more resource intensive for sample insertion and deletion. However, Oracle is also a good choice for large and active System Reporter installation.

NOTE: System Reporter does not currently support Oracle RAC implementations.

NOTE: System Reporter requires the 32-bit Oracle client and does not support the 64-bit version.

Installing the Database Server

3.15

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