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

HP 3PAR System Reporter E-Media Kit, System Reporter Media Kit 3.8 Installing the Database Server, 3.8.1 Choosing the Appropriate Database, 3.8.1.1 SQLite

1 378

Download 378 pages, 2.5 Mb

3PAR System Reporter User’s Guide

System Reporter 2.8

NOTE: If SELinux (Security Enhanced Linux) is implemented at your site, you may need to either disable SELinux entirely or temporarily grant permissive access to the system to install the System Reporter tools. Please consult your Linux documentation for details on how to grant permissive access.

NOTE: It is recommended that you increase the default Timeout parameter to at least 360 seconds (or more for installations with very large databases) in the appropriate apache configuration file (typically httpd.conf) and then restart apache to let this change take effect. This is to ensure that CGI calls that take a long time to generate a report do not timeout.

On Windows, by default the Timeout parameter is specified in the following file:

C:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd- default.conf

On Linux, by default the Timeout parameter is specified in the following file:

/etc/httpd/conf/httpd.conf

3.8 Installing the Database Server

3PAR System Reporter supports three database servers: SQLite, MySQL and Oracle. Before beginning the installation, select the database based on the considerations described below and summarized in Table 3-4.

3.8.1 Choosing the Appropriate Database

Before beginning, you want to choose the right database for your particular installation.

3.8.1.1 SQLite

SQLite is an embedded database that is included with System Reporter. It does not run as a separate application but rather as a module within the sampling tool and web server. Since it requires no installation or configuration, it is very simple to use but it has several limitations that make it only suitable for small database sizes and limited concurrency.

3.14	Installing the Database Server

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