3PAR® System Reporter 2.8 User’s Guide 3PAR, Inc. 4209 Technology Drive Fremont, CA 94538 USA Part No.
Revision Notice This is the first release of this manual. A complete revision history is provided at the end of this document. Changes The material in this document is for information only and is subject to change without notice. While reasonable efforts have been made in the preparation of this document to assure its accuracy, 3PAR, Inc. assumes no liability resulting from errors or omissions in this document or from the use of the information contained herein.
■ Neither the names of the copyright owners nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
direction or management of such entity, whether by contract or otherwise, or (ii) ownership of fifty percent (50%) or more of the outstanding shares, or (iii) beneficial ownership of such entity. "You" (or "Your") shall mean an individual or Legal Entity exercising permissions granted by this License. "Source" form shall mean the preferred form for making modifications, including but not limited to software source code, documentation source, and configuration files.
worldwide, non-exclusive, no-charge, royalty-free, irrevocable (except as stated in this section) patent license to make, have made, use, offer to sell import, and otherwise transfer the Work, where such license applies only to those patent claims licensable by such Contributor that are necessarily infringed by their Contribution(s) alone or by combination of their Contribution(s) with the Work to which such Contribution(s) was submitted.
5. Submission of Contributions. Unless You explicitly state otherwise, any Contribution intentionally submitted for inclusion in the Work by You to the Licensor shall be under the terms and conditions of this License, without any additional terms or conditions. Notwithstanding the above, nothing herein shall supersede or modify the terms of any separate license agreement you may have executed with Licensor regarding such Contributions. 6. Trademarks.
TWAPI Copyright & License Copyright (c) 2003-2008, Ashok P. Nadkarni All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: - Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
We protect your rights with two steps: (1) copyright the software, and (2) offer you this license which gives you legal permission to copy, distribute and/or modify the software. Also, for each author's protection and ours, we want to make certain that everyone understands that there is no warranty for this free software.
Thus, it is not the intent of this section to claim rights or contest your rights to work written entirely by you; rather, the intent is to exercise the right to control the distribution of derivative or collective works based on the Program. In addition, mere aggregation of another work not based on the Program with the Program (or with a work based on the Program) on a volume of a storage or distribution medium does not bring the other work under the scope of this License.
If any portion of this section is held invalid or unenforceable under any particular circumstance, the balance of the section is intended to apply and the section as a whole is intended to apply in other circumstances.
System Reporter 2.8 3PAR System Reporter User’s Guide Table of Contents 1 Introduction 1.1 Audience 1.1 1.2 User Interfaces 1.1 1.3 Related Documentation 1.2 1.4 Organization 1.3 1.5 Typographical Conventions 1.4 1.6 Advisories 1.4 2 Overview and Features 2.1 About 3PAR System Reporter 2.1 2.2 Configuring System Reporter Policy Settings 2.2 2.3 Choosing a Method for Accessing Reports 2.3 2.4 Creating Customized Reports 2.4 2.5 Formatting Reports for Presentation 2.6 2.
3PAR System Reporter User’s Guide System Reporter 2.8 3 Installation, Configuration, Update, and Removal 3.1 Before You Begin 3.1 3.2 System Reporter CD Contents 3.2 3.3 System Requirements 3.4 3.4 Using the System Reporter Sizing Spreadsheet 3.6 3.5 System Reporter Components 3.9 3.6 Installing the System Reporter Components 3.11 3.7 Installing the Web Server 3.13 3.8 Installing the Database Server 3.14 3.8.1 3.8.2 3.8.3 Choosing the Appropriate Database 3.14 3.8.1.1 SQLite 3.
System Reporter 2.8 3PAR System Reporter User’s Guide 3.12 Removing the System Reporter Components 3.36 3.12.1 Removing the System Reporter Tools on Windows 3.36 3.12.2 Removing the System Reporter Tools on Linux 3.37 3.12.3 Removing the MySQL Database (Optional) 3.37 4 Getting Started 4.1 Accessing the Main System Reporter Interface 4.1 4.2 System Reporter Main Menu Window 4.3 4.3 Getting Help 4.4 4.4 Using the Object Selection Controls 4.5 4.4.1 Simple Selection List 4.5 4.4.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3 Creating Custom Reports 5.3.1 5.5 5.3.1.1 Sample Resolution 5.6 5.3.1.2 Report 5.6 5.3.1.3 Select Systems 5.8 5.3.1.4 Select Domains 5.9 Generating the Report 5.10 5.3.3 Controls Available by Report 5.14 5.3.4 Report Selection 5.17 5.3.4.1 Standard Report Types 5.18 5.3.4.2 Select Summary Columns 5.24 5.3.4.3 Compare 5.25 5.3.4.4 Select Peak 5.25 5.3.4.5 Group By 5.25 5.3.4.6 Order By 5.28 5.3.4.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.7 5.3.6.9 Select CPGs 5.37 5.3.6.10 Select LDs 5.38 5.3.6.11 Select RAID Types 5.38 5.3.6.12 Select LD Usage 5.39 5.3.6.13 Select VVs 5.40 5.3.6.14 Select Prov Types 5.41 5.3.6.15 Select VV Types 5.42 5.3.6.16 Select Ports (n:s:p) 5.42 5.3.6.17 Select Port Types 5.43 5.3.6.18 Select Hosts 5.43 5.3.6.19 Select Nodes 5.44 5.3.6.20 Select To Nodes 5.44 5.3.6.21 Select Queues 5.
3PAR System Reporter User’s Guide System Reporter 2.8 6 Interpreting Report Metrics 6.1 Summary Report 6.1 6.2 Space Reports 6.6 6.2.1 PD Space Reports 6.6 6.2.2 LD Space Reports 6.7 6.2.3 VV Space Reports 6.8 6.3 Performance Reports 6.11 6.3.1 Common Performance Metrics 6.11 6.3.2 VV Cache Performance Reports 6.13 6.3.3 Node Cache Performance Reports 6.14 6.3.4 CPU Performance Reports 6.15 6.3.5 Link Performance Reports 6.16 6.4 Adaptive Optimization Reports 6.
System Reporter 2.8 3PAR System Reporter User’s Guide 7.4.4.3 System 7.13 7.4.4.4 Metric 7.13 7.4.4.5 Direction 7.16 7.4.4.6 Limit Value 7.16 7.4.4.7 Limit Count 7.17 7.4.4.8 Condition 7.17 7.4.4.9 Condition Value 7.17 7.4.4.10 7.4.5 Recipient Example of an Alert Rule 7.5 Scheduling Reports 7.17 7.17 7.18 7.5.1 Adding a Scheduled Report 7.19 7.5.2 Changing a Scheduled Report 7.20 7.5.3 Removing a Scheduled Report 7.21 7.6 Configuring Adaptive Optimization 7.22 7.
3PAR System Reporter User’s Guide xviii Table of Contents System Reporter 2.8 8.4.10 graphlegpos 8.14 8.4.11 tableformat 8.14 8.4.12 alllabels 8.15 8.4.13 timeform 8.16 8.4.14 begintsecs 8.16 8.4.15 endtsecs 8.17 8.4.16 groupby 8.18 8.4.17 orderby 8.21 8.4.18 histbegin 8.25 8.4.19 ldspaceunit 8.25 8.4.20 pdspaceunit 8.26 8.4.21 vvspaceunit 8.27 8.4.22 selcageid 8.28 8.4.23 selchunks 8.29 8.4.24 selcpg 8.31 8.4.25 selusrcpg 8.31 8.4.26 selsnpcpg 8.31 8.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.4.42 selprovtype 8.43 8.5 Report Types 8.44 8.6 Summary Report 8.45 8.6.1 summary 8.7 Space Reports 8.45 8.45 8.7.1 pd_space_time 8.45 8.7.2 pd_space_group 8.45 8.7.3 ld_space_time 8.46 8.7.4 ld_space_group 8.46 8.7.5 vv_space_time 8.47 8.7.6 vv_space_group 8.47 8.8 Performance Reports 8.47 8.8.1 pd_perf_time 8.47 8.8.2 pd_perf_group 8.48 8.8.3 pd_svt_hist 8.48 8.8.4 pd_svt_histvstime 8.49 8.8.
3PAR System Reporter User’s Guide System Reporter 2.8 cpu_perf_group 8.54 8.9 Adaptive Optimization Reports 8.55 8.8.20 8.9.1 8.9.2 regiodensity 8.55 8.9.1.1 8.55 8.55 regmoves 8.9.2.1 8.9.3 regiondensity example regmoves example 8.55 vvtier 8.9.3.1 8.55 vvtier example 8.56 8.10 Options Available by Report 8.56 8.11 Objects Present Reports 8.61 8.11.1 objectpres= cageid 8.65 8.11.2 objectpres= cpg_name 8.66 8.11.3 objectpres= diskspeed 8.67 8.11.4 objectpres= disktype 8.
System Reporter 2.8 3PAR System Reporter User’s Guide 9.3.2 Schedule 9.9 9.3.3 Measurement Hours 9.9 9.3.4 Adaptive Optimization Mode 9.10 9.3.5 Adaptive Optimization Active 9.10 9.3.6 Adding an Adaptive Optimization Configuration 9.10 9.3.7 Changing an Adaptive Optimization Configuration 9.11 9.3.8 Removing an Adaptive Optimization Configuration 9.12 9.4 Adaptive Optimization Reports 9.13 9.4.1 Region IO Density Report 9.13 9.4.2 VV Tiers Report 9.16 9.4.
3PAR System Reporter User’s Guide System Reporter 2.8 10.4.4 The ldspaceinv Table 10.21 10.4.5 The vvspace Table 10.22 10.4.6 The vvspaceinv Table 10.25 10.4.7 The cpgspace Table 10.27 10.4.8 The cpgspaceinv Table 10.29 10.4.9 Common Performance Table Columns 10.30 10.4.9.1 Calculating Common Performance Metrics 10.35 10.4.9.2 Service Time Histogram Buckets 10.36 10.4.9.3 IO Size Histogram Buckets 10.36 10.4.10 The statpd Table 10.37 10.4.11 The statpdinv Table 10.39 10.4.
System Reporter 2.8 3PAR System Reporter User’s Guide 11.2.2 Installation Configuration 11.3 11.2.3 InServ Sampling Errors 11.3 11.2.4 11.2.3.1 Errors incurred by the inservsample process 11.4 11.2.3.2 Errors incurred by the CLI sampler process. 11.4 Sampler Service/Daemon Errors 11.3 Troubleshooting Adaptive Optimization Components 11.4 11.4 Troubleshooting the Web Server Components 11.5 11.5 Troubleshooting the Excel Client 11.5 11.6 Extracting Data from the Database with sysbck 11.
3PAR System Reporter User’s Guide xxiv Table of Contents System Reporter 2.
System Reporter 2.8 3PAR System Reporter User’s Guide 1 Introduction This guide provides the information you need to install and use 3PAR® System Reporter to monitor performance, create charge back reports, and plan storage resources for 3PAR InServ® Storage Servers. An optionally licensed component called Adaptive Optimization is also included with System Reporter that can be used to monitor and automatically optimize utilization of storage resources.
3PAR System Reporter User’s Guide System Reporter 2.8 Two user interfaces are offered as part of the InServ Storage Server: a Web-based interface and an Excel client. ■ The Web-based interface enables you to monitor InServ Storage Servers and access statistics using a standard Web browser. Configuration of the System Reporter database sampling policies must be done via a Web browser. ■ The Excel client enables you to monitor InServ Storage Servers and access statistics using Microsoft® Excel®.
System Reporter 2.8 3PAR System Reporter User’s Guide 1.4 Organization This guide is organized as follows: ■ Chapter 1, Introduction (this chapter), provides an introduction to this guide, including information on audience, related documentation, and typographical conventions. ■ Chapter 2, Overview and Features, provides an overview of System Reporter and describes its features and capabilities.
3PAR System Reporter User’s Guide System Reporter 2.8 1.5 Typographical Conventions This guide employs the following typographical conventions: Typeface Meaning Example ABCDabcd Used for dialog When prompted, click Finish to elements such as titles, complete the installation. button labels, and other screen elements. ABCDabcd Used for paths, Open the file filenames, and screen \gui\windows\setup.exe output. 1.
System Reporter 2.8 3PAR System Reporter User’s Guide 2 Overview and Features This chapter provides a brief overview of the features and capabilities offered by System Reporter. 2.1 About 3PAR System Reporter 3PAR System Reporter monitors performance and the usage of storage resources and allows you to generate charts and graphs that report useful statistics for planning and configuring the operation of 3PAR InServ® Storage Servers.
3PAR System Reporter User’s Guide ■ System Reporter 2.8 Options for choosing the time and duration for the collection of reporting statistics which can be initiated at a specific time, collected over a period of time, and/or compared between a range of times. ■ Options for viewing and comparing report information in a variety of formats through a selection of charts and tables. ■ Alerts that can be configured to send email notifications to a specified address when certain reporting criterion are met.
System Reporter 2.8 ■ 3PAR System Reporter User’s Guide Adaptive Optimization -- Configures the optionally licensed Adaptive Optimization components that are used to monitor and optimize storage utilization. See Chapter 7, Configuring the System Reporter Policy Settings for details on how to configure the policy settings for your site. 2.
3PAR System Reporter User’s Guide System Reporter 2.8 2.4 Creating Customized Reports System Reporter provides a number of options for building customized reports as follows: ■ Report Selection. Allows you to select from one of the reports shown in Table 2-1: Table 2-1. Available Reports Report Name Description Report Metrics Cross Reference Summary Displays summary 6.1 Summary Report on page 6.1 information. PD Space Displays physical disk 6.2.1 PD Space Reports on page 6.6 space usage.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 2-1. Available Reports ■ Report Name Description Report Metrics Cross Reference Node Cache Displays Node Cache 6.3.3 Node Cache Performance Performance Performance. Reports on page 6.14 CPU Displays CPU 6.3.4 CPU Performance Reports on Performance performance. page 6.15 Link Displays performance of 6.3.5 Link Performance Reports on Performance links between nodes. page 6.16 Adaptive Displays Adaptive 6.
3PAR System Reporter User’s Guide ◆ System Reporter 2.8 At Time reports allow you to compare a large number of objects, defined in more complex ways, but only at a specific point in time. The objects are plotted along the Xaxis. ◆ Histogram At Time reports show the distribution of service times and IO sizes at a specific point in time. ◆ Histogram vs Time reports show the distribution of service times and IO sizes over a period of time (time is along the X-axis). ■ Time Selection.
System Reporter 2.8 3PAR System Reporter User’s Guide See 5.3.7 Format Selection (Web interface only) on page 5.45 for descriptions and options available for formatting reporting data. 2.6 Customizing the Reporting Format Although System Reporter provides a number of built-in controls for specifying the format of a report, in some cases you may want to present the data using a different format that is not available from the standard selection.
3PAR System Reporter User’s Guide System Reporter 2.8 2.9 Using the Database Schema to Build Custom Reports The databases used by System Reporter are standard relational databases capable of supporting SQL queries. The default (built-in) database is SQLite (see http://www.sqlite.org) but MySQL and Oracle database servers can optionally be used instead. The database schema is documented so you can write your own reports by directly querying the System Reporter database.
System Reporter 2.8 3PAR System Reporter User’s Guide 3 Installation, Configuration, Update, and Removal This chapter describes how to install and configure as well as remove the 3PAR System Reporter components. 3.1 Before You Begin Before installing 3PAR System Reporter components, select a system on which to run the System Reporter sampler and Web server. This system must use Windows® Server 2003, Windows® Server 2008 or Red Hat® Enterprise Linux 5.
3PAR System Reporter User’s Guide System Reporter 2.8 3.2 System Reporter CD Contents InServ Storage Server CD includes the following contents (Table 3-1): Table 3-1. InServ Storage Server CD Contents Directory /Documents/ Filename CLI\231_CLI_Adminin Description CLI Administrators Guide. strator_Manual.pdf SR_Sizing.xls System Reporter server sizing spreadsheet (see 3.4 Using the System Reporter Sizing Spreadsheet on page 3.6). System_Reporter.pdf System Reporter User Guide (this document).
System Reporter 2.8 3PAR System Reporter User’s Guide Directory /Windows/ Filename Description apache_2.2.14- Apache HTTP Server installer win32-x86-openssl- executable for Microsoft Windows. 0.9.8k.msi This installer is provided only as a convenience. You may choose to download and install directly from: http://httpd.apache.org. installer.exe System Reporter installer executable for Microsoft Windows. /Windows/CLI/ setup.
3PAR System Reporter User’s Guide System Reporter 2.8 3.3 System Requirements 3PAR System Reporter supports the use of the 3PAR InForm OS, versions 2.2.4 thru 2.3.1 MU1 and beyond. Observe the following minimum system hardware requirements: Table 3-2.
System Reporter 2.8 3PAR System Reporter User’s Guide 3PAR System Reporter components have the following requirements: Table 3-3. InServ Storage Server System Requirements Component Supported Operating Systems Database Additional Requirements MySQL® Database Server version version 5.1(Optional) Oracle 11g® Database (Optional) (Oracle RAC is not currently supported.) Windows® Server 2003 Sampling Windows Server 2008 Oracle 11g Client (32-bit only) service Red Hat Enterprise Linux 5.
3PAR System Reporter User’s Guide System Reporter 2.8 3.4 Using the System Reporter Sizing Spreadsheet Before installing System Reporter, you need to determine the system resources that are required to adequately run System Reporter and the selected data base server.
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 3-1. System Reporter Sizing Spreadsheet Using the System Reporter Sizing Spreadsheet 3.
3PAR System Reporter User’s Guide System Reporter 2.8 To use the System Reporter Sizing Spreadsheet: 1 Click on the appropriate type of database that you are using for System Reporter at your site. You will notice that SQlite only supports one InServ Storage Server for use with System Reporter. Please consider another database if you plan on using System Reporter to monitor more than a single InServ Storage Server.
System Reporter 2.8 3PAR System Reporter User’s Guide 3.5 System Reporter Components 3PAR System Reporter includes the following components (Figure 3-2): Figure 3-2. InServ Storage Server and User Interface Components ■ Database. The 3PAR System Reporter database is capable of supporting SQL queries. Three types of databases are supported: SQLite, MySQL and Oracle (see 3.8 Installing the Database Server on page 3.14). ■ Sampler components.
3PAR System Reporter User’s Guide ◆ System Reporter 2.8 A separate inservsample process is created for each InServ system being sampled. This process in turn creates a separate CLI process that runs the sampler script which logs into the array and collects the required data. The inservsample process then inserts the data into the database. Along with the tables that contain the space and performance data, the database also includes inventory tables that allow quicker creation of report menus.
System Reporter 2.8 3PAR System Reporter User’s Guide 3.
3PAR System Reporter User’s Guide System Reporter 2.8 Install CLI (section 3.1) Install MySQL (section 3.8.2.1) Create Oracle database and set up listener (section 3.8.3.1) Install Apache Web Server and optionally configure File & Apache protection (section 3.6 and 3.10) Using MySQL? Yes Set Up the Database Create schema and users (section 3.8.2.2) (section 3.8.3.2) Setting the maximum packet parameter (section 3.8.2.3) No Using Oracle? Yes No Install System Reporter (section 3.
System Reporter 2.8 3PAR System Reporter User’s Guide 3.7 Installing the Web Server 3PAR System Reporter requires Apache HTTP Server, version 2.0 or later. A copy of the installer executable for Windows of Apache HTTP Server, version 2.2, is located on the 3PAR System Reporter CD or see www.apache.org. for download instructions. Red Hat Linux typically includes the Apache Web Server. NOTE: System Reporter 2.8 and beyond supports secure connections on Apache servers using the SSL protocol.
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.
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.1 Compacting Databases on page 7.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: If you choose Oracle as the database, you cannot install System Reporter on a 64-bit Linux system since it requires a 32-bit Oracle client which is not supported on 64-bit Linux. This limitation does not apply to the 64-bit Windows version since the 32-bit Windows version of Oracle Client works on 64-bit Windows platforms. Table 3-4 provides a comparison of features for the various database choices. Table 3-4.
System Reporter 2.8 3PAR System Reporter User’s Guide 3.8.2.1 Installing MySQL Server To use MySQL for the 3PAR System Reporter database, obtain a software license and a copy of MySQL Database Server, version 5.1. See www.mysql.com for licensing and download instructions. NOTE: Beginning with the 2.2 release, System Reporter can use a MySQL database on a remote server. The MySQL installation and configuration steps are the same for the remote server. See section 3.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: When installing on a Redhat Linux server where the MySQL server is running locally on the same server, you must complete one of the following procedures: 1 Create a symbolic link using the following command: ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock 2 Or, make the following change in the /etc/my.cnf file: socket=/var/run/mysqld/mysqld.sock and then restart the MySQL server.
System Reporter 2.8 9 3PAR System Reporter User’s Guide Confirm the following and then click Next: ◆ Install As Windows Service is selected ◆ the default Service Name is MySQL ◆ the Launch the MySQL Server automatically checkbox is checked 10 Confirm that Modify Security Settings is selected, enter a root password, and then retype the password to confirm. CAUTION: Be sure to record the password for later reference. 11 Make sure that Create An Anonymous Account is not selected and then click Next.
3PAR System Reporter User’s Guide System Reporter 2.8 /etc/init.d/mysqld restart CAUTION: It is necessary to use a large max_allowed_packet length because, when sampling a large number of systems or very large systems, the SQL INSERT command length can be quite large and the max_allowed_packet must be large enough to hold the entire statement. If the max_allowed_packet is not large enough, the sampler will get an error and sampling will stop. 3.8.2.
System Reporter 2.8 3PAR System Reporter User’s Guide As part of installing the System Reporter tools (see Installing or Upgrading the System Reporter Tools on page 3.24), the installer creates two Apache HTTP Server config.tcl files to store the user names and passwords for the cliuser and the webuser. See 7.8 Modifying the Apache HTTP Server Configuration Files on page 7.23 for instructions on editing these config.tcl files if you change the MySQL usernames and passwords at a later time.
3PAR System Reporter User’s Guide System Reporter 2.8 2 Click Next at the welcome screen. 3 Select the Create a Database radio button and click Next. 4 Select the radio button for the Data Warehouse template and click Next. 5 Enter a name for the database and Oracle System Identifier (SID) and click Next. 6 Keep defaults for Configure Enterprise Manager, and click Next. 7 Select passwords for various Oracle users and click Next. 8 Select the desired storage mechanism and click Next.
System Reporter 2.8 1 3PAR System Reporter User’s Guide At the login screen for the Oracle Enterprise Manager login as SYSTEM with the password for the SYSTEM user. 2 Click on the link (or tab) for Server. 3 Under Security, click on the link for Users. 4 Click on the Create button. 5 In the create user screen, enter the user name cliuser along with the password. Select a default and temporary tablespace, select Unlocked for the status. 6 7 Click on the link (or tab) for Roles.
3PAR System Reporter User’s Guide 8 System Reporter 2.8 Select Yes, perform a test and click Next. The test may fail if the default user and password are not set. Click the Change Login button and enter cliuser and password and click ok. The test should succeed. Click Next. 9 Enter a net service name. This is the name you will need to enter when installing the System Reporter tools. Click Next. 10 Follow instructions to complete the net service configuration and exit the program. 3.
System Reporter 2.8 3PAR System Reporter User’s Guide Click on the Upgrade button to keep the existing settings and skip to step 10. Click on the Next button to step through each of the settings as described in the following steps. NOTE: If the installer detects a previous version of System Reporter, it will pop up a window at this point. If the compactdb process is running, the popup will advise you to wait for the compaction to complete and perform the upgrade later.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: If you are upgrading from an earlier version of the System Reporter or reinstalling an existing 2.8 version for SQLite, and if you wish to retain the data collected from the previous installation, you must specify the same (existing) database, otherwise a new database will be created. System Reporter 2.8 will automatically convert the earlier release database tables into the format that it needs.
System Reporter 2.8 3PAR System Reporter User’s Guide for Email Alerts on page 7.9) you may leave all entries in this screen blank. If you want to be able to configure System Reporter to generate email alerts, you must enter the IP address or name of the SMTP server, the user name and password if the SMTP server requires authentication, and the SMTP originator name (the mailbox name that the email appears to be from). This information is stored in the sampleloop_config.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: If the Status is not Started, the installation of the 3PAR Reporting Tools may be unsuccessful. Check the sampleloop.log. If the installation was unsuccessful, remove all System Reporter components using the instructions provided in Removing the System Reporter Components on page 3.36 and then repeat the installation steps described in Installing or Upgrading the System Reporter Tools on page 3.24.
System Reporter 2.8 3PAR System Reporter User’s Guide Both these packages must be installed after logging in to a terminal session on the server as the root user. Make sure that httpd and mysqld are running before starting sampleloop (when using the MySQL database). Note that mysqld may not be running on the same server. NOTE: The sysrptwebsrv requires the 32-bit version of the gd (version 2.0 or greater) package to be installed.
3PAR System Reporter User’s Guide 4 System Reporter 2.8 For MySQL and Oracle databases, create/edit the /etc/sampleloop_dbpwfile file to include a single line that has the database user name and password separated by a space. 5 Start the sampleloop daemon by running: /etc/init.d/sampleloop start Look at the sampleloop.log file in the /var/log/sampleloop/ directory to see status and progress of the sampleloop daemon.
System Reporter 2.8 3PAR System Reporter User’s Guide 3.9.1 Adding InServ Systems Follow these instructions for adding InServ systems to be sampled. 1 Open a Web browser and point it at http:///3par/ where is the Web server where Apache HTTP Server is installed. The 3PAR System Reporter window appears. 2 Click on Policy Settings in the Extras Menu area. The System Reporter Policies window appears.
3PAR System Reporter User’s Guide 9 System Reporter 2.8 Click Submit Query. NOTE: Since performance data for LDs can increase the database size substantially you should check the Skip LD Performance data box unless you intend to configure Adaptive Optimization for the system. You can change the value of the Use SSL and Skip LD Performance data parameters or even disable sampling for a storage server entirely as described in section 7.3.4 Re-Configuring a Storage Server Sampling on page 7.8.
System Reporter 2.8 3PAR System Reporter User’s Guide You can now return to the 3PAR System Reporter window and execute database queries using a Web browser. NOTE: For performance type reports, at first you may only be able to see high resolution performance information. For space type reports, it may take more than 30 minutes before you can sample high resolution data. Daily and hourly data samples may take even longer. 3.
3PAR System Reporter User’s Guide System Reporter 2.8 CAUTION: Depending on your Web browser, simply clicking the Excel Client link may cause the Excel client to open in your browser window, which will not give you access to the full Excel client functionality. Be sure to save the file on your local machine and then refer to Accessing the Optional Excel Client on page 4.6 for further instructions. 3.
System Reporter 2.8 3PAR System Reporter User’s Guide (see Figure 4-9 on page 4.14 and Figure 4-5 on page 4.9 for examples). Depending on how you configure the Apache httpd.conf file, the user will see this dialog box when attempting to read the database (or database sampling policies) or when attempting to edit the sampling policies via Web browser. Note that the appearance of this dialog box may vary depending on which version of Windows you are using.
3PAR System Reporter User’s Guide System Reporter 2.8 3.12 Removing the System Reporter Components This section describes how to remove the 3PAR System Reporter Components. This includes removing the System Reporter sampler and default database, as well as deleting the optional MySQL database (when applicable). 3.12.1 Removing the System Reporter Tools on Windows To remove the System Reporter tools on WIndows: 1 2 Go to the Windows Control Panel, open Administrative Tools and then Services.
System Reporter 2.8 9 3PAR System Reporter User’s Guide (Optional). Go to the location where you installed Apache HTTP Server and locate the cgibin directory (for example, C:\Program Files\Apache Group\Apache2\cgi-bin), then delete the subdirectories 3par-policy and 3par-rpts. 3.12.2 Removing the System Reporter Tools on Linux 1 Stop the sampleloop daemon by running: /etc/init.
3PAR System Reporter User’s Guide System Reporter 2.8 CAUTION: Deleting the database schema will remove the inservstats database and cannot be undone. 3 Delete the users created by running the following commands: drop user cliuser; drop user webuser; 4 Exit the MySQL command line. exit; 3.
System Reporter 2.8 3PAR System Reporter User’s Guide 4 Getting Started This chapter describes how to start using 3PAR System Reporter from the primary web interface or Excel client. NOTE: For information on using a Web browser to edit database sampling policies, add or remove storage servers from the database, schedule reports or optimize storage utilization with the optional Adaptive Optimization feature, see Chapter 7, Configuring the System Reporter Policy Settings. 4.
3PAR System Reporter User’s Guide System Reporter 2.8 If the Apache HTTP Server has been configured to require a password to read the database, a connection dialog box appears (Figure 4-1). Type the user name and password and click OK. Figure 4-1. Connection Dialog Box NOTE: See About Apache HTTP Server Authorization and Access Control on page 3.34 for more instructions on setting Apache HTTP Server to require a username and password. 4.
System Reporter 2.8 3PAR System Reporter User’s Guide 4.2 System Reporter Main Menu Window The various System Reporter menu options are accessed through the Main Menu Window. Title Pane Extras Menu Main Menu Figure 4-2. The System Reporter Main Window The 3PAR System Reporter Main Menu (Figure 4-2) is divided into the following areas: ■ Title Pane which shows the version of System Reporter.
3PAR System Reporter User’s Guide ◆ System Reporter 2.8 Policy Settings (see Chapter 7, Configuring the System Reporter Policy Settings for complete details on configuring policy settings). The following tabs are provided from the policy settings window: ◆ Add Systems -- used to specify the InServ Storage Servers for reporting purposes. ◆ Alert Rules -- used to specify the alert rules. ◆ Schedule Report -- used to schedule reports at specified times.
System Reporter 2.8 3PAR System Reporter User’s Guide NOTE: Adobe Acrobat® is required to view the 3PAR System Reporter User’s Guide. See www.adobe.com/support/downloads for download instructions. 4.4 Using the Object Selection Controls Menus in System Reporter often provide a way to select a subset of objects to include in a report from among a list of available objects.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: When using an expression pattern, you should be aware that the Web interface uses a Regular Expression syntax for filtering whereas the Excel client uses a LIKE operator syntax. For example, to search for an object with “DB” anywhere in the name, the filter text would use DB for the web interface and *DB* for the Excel client. As another example, to search for an object starting with “DB” and ending with “12”, the filter text would be ^DB.
System Reporter 2.8 3PAR System Reporter User’s Guide The 3PAR System Reporter Excel client opens in Microsoft® Excel® (Figure 4-3). Figure 4-3. System Reporter Excel Client 4.5.2 Setting the Security Level for Excel The 3PAR System Reporter Excel client uses macro code to implement its functionality. In order for this code to be executed, you must set the proper security settings depending on the version of Excel that you are using. 4.5.2.
3PAR System Reporter User’s Guide System Reporter 2.8 S Figure 4-4. Security Warning for Enabling Macros in Excell 2003 1 Click Enable Macros to continue launching the Excel client. If you do not see the Security Warning, try completing steps 2 thru 7 to set the macro security level for Microsoft® Excel® 2003, before continuing. 2 On the Microsoft® Excel® Tools menu, point to Macro, then Security. The Security dialog box appears with the Security Level tab enabled (Figure 4-5). 4.
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 4-5. Setting the Security Level 3 On the Security Level tab, set the security level to Medium or Low (Medium is the default and suggested setting) and then click OK. NOTE: The 3PAR System Reporter Excel client will not work if the Microsoft® Excel® security level is set to High or Very High. 4 If you changed the security level setting, close the Excel workbook and then reopen it.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: Please consult your company’s security policy before changing any security settings. 4.5.2.2 Setting the Security Level for Excel 2007 In most cases, when accessing the System Reporter client for Excel 2007, a security warning, indicating that macros have been disabled, is shown in the upper left part of the screen. If you do not see the Security Warning, try completing steps 4 thru 9 before continuing.
System Reporter 2.8 3PAR System Reporter User’s Guide If you do not see a Security Warning when accessing the Excel client, it is likely that the main Excel Macro Settings are not set up properly and need to be changed. In this case, follow these steps: 4 Click on the Windows icon in the left corner of the screen. 5 Click Excel Options at the bottom of the menu. 6 Click Trust Center. 7 Click Trust Center Settings. The Trust Center screen appears (Figure 4-7) Figure 4-7.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: The 3PAR System Reporter Excel client will not work if the Macro Setting is set to Disable all macros without notification or Disable all macros except digitally signed macros. 9 Click OK, then click OK again to return to the System Reporter Excel client main screen. 10 Close the Excel client, then launch it again from the System Reporter main menu. 11 Continue with step 1 thru 3.
System Reporter 2.8 3PAR System Reporter User’s Guide The Connection Parameters dialog box appears (Figure 4-8). Figure 4-8. Connection Parameters Dialog Box 2 In the Server Hostname box, type a host name and click OK. The host name is the name of the Web server where the Apache HTTP Server and 3PAR System Reporter Web server scripts are installed (see Before You Begin on page 3.1). If the server is configured for secure connections, check the HTTPS box.
3PAR System Reporter User’s Guide System Reporter 2.8 Figure 4-9. Connection Dialog Box 3 Type your user name and password and click OK. NOTE: See About Apache HTTP Server Authorization and Access Control on page 3.34 for more instructions on setting Apache HTTP Server to require a username and password. The versions of the System Reporter’s Web server component and the Excel client are compared.
System Reporter 2.8 3PAR System Reporter User’s Guide 4.6.1 Changing the Web Server To change the Web server used for querying the System Reporter database: 1 Click the Add-Ins menu tab, choose the 3PAR pull down menu and then select the Set server name... option. The Connection Parameters dialog box appears. 2 In the Server Hostname box, type the new server name. 3 Click OK. 4.6.
3PAR System Reporter User’s Guide System Reporter 2.8 You can hide, unhide, or delete the Query Log sheet as desired. If deleted, a new hidden sheet is created for the next query. See Deleting Excel Sheets on page 4.16 to learn how to delete the query log and other sheets. 4.8 Deleting Excel Sheets When using the 3PAR System Reporter Excel client, you can reset the entire workbook to its original state by following the instructions in Resetting the Workbook on page 4.
System Reporter 2.8 3PAR System Reporter User’s Guide To delete the query log: 1 Make the Query Log tab visible by following the instructions in Accessing the Excel Client Query Log on page 4.15. 2 At the bottom of the Microsoft® Excel® window, point to the Query Log tab and then right-click. 3 On the shortcut menu that appears, click Delete. 4 In the confirmation dialog that appears, click OK. The query log is deleted.
3PAR System Reporter User’s Guide System Reporter 2.8 Figure 4-10. Security Alerts Multiple Issues To enable macros and the data connection, choose the Enable this content buttons. NOTE: If it is ever necessary, you can obtain an entirely new copy of the 3PAR System Reporter Excel client workbook by following the instructions provided in Installing the Excel Client (Optional) on page 3.33. 4.
System Reporter 2.8 3PAR System Reporter User’s Guide 5 Accessing and Creating Reports This chapter describes how to access quick reports, scheduled reports, and build custom reports that are specifically tailored for your operating environment. The menu selections and controls available for creating custom reports from either the web interface or the Excel client are functionally identical, so the information in this chapter applies to both with explanations provided for any minor variations.
3PAR System Reporter User’s Guide System Reporter 2.8 5.1 Accessing Quick Reports Quick reports provide predefined reports that you can generate quickly by choosing the Quick Report tab from the System Reporter Main Menu Window and then selecting one of the customized reports from the list of directories as shown in Figure 5-1.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.2 Accessing Scheduled Reports Scheduled reports are generated using pre-selected parameters at scheduled times and are stored in sub-directories whose structure is reflected in the tree shown in Figure 5-2. Scheduled reports are stored with a name that is assigned when the report is scheduled. Each time the report runs, a new subdirectory is created for that instance of the report using the timestamp as the name.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: See 7.5 Scheduling Reports for complete details on scheduling a report. 5.3 Creating Custom Reports You can create customized reports by selecting the Custom Reports tab from the Main Menu or by choosing the Excel Client from the Extras Menu.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.1 Building the Report Menu The first step in creating a report is to choose the appropriate options for the type of report that you want to generate. Figure 5-3. Custom Reports Window NOTE: The layout and placement of controls may vary slightly for the Excel client but operate in the same manner as described for the web interface. Creating Custom Reports 5.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.1.1 Sample Resolution The Sample resolution control enables you to select from one of three resolutions corresponding to the tables that are maintained in the database (see Table 5-1). The samples can be retained for a different lengths of time for each resolution (see Editing Sampling Policies on page 7.4 for instructions on altering the default sampling policies).
System Reporter 2.8 3PAR System Reporter User’s Guide Table 5-2. Reports and Uses (continued) Reports Purpose LD Space Display logical disk space usage. See 6.2.2 LD Space Reports on page 6.7 for the types of statistics provided by this report. VV Space Display virtual volume space usage. See 6.2.3 VV Space Reports on page 6.8 for the types of statistics provided by this report. Port Performance Display port performance. See 6.3.1 Common Performance Metrics on page 6.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 5-2. Reports and Uses (continued) Reports Purpose Link Performance Display performance of links between nodes. See 6.3.5 Link Performance Reports on page 6.16 for the types of statistics provided by this report. Adaptive Optimization Display Adaptive Optimization reports. See 6.4 Adaptive Optimization Reports on page 6.16 for the types of statistics provided by this report. 5.3.1.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.1.4 Select Domains This is a filtered multi-selection control (see 4.4.2 Filtered Multi-Selection Control on page 4.5) used to select one or more domains to be included in the report. This control is available for LD Space, VV Space, LD Performance, VLUN Performance and VV Cache Performance reports. Table 5-4. Select Domains Option Purpose -All The report will include all the domains that are included in the database.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.2 Generating the Report When you click on the Build Report Menu button in the Custom Reports window, a new window (or tab) is created containing a report menu for the selected report. An example of this report menu is shown in Figure 5-4. This is the report menu for Daily VLUN Performance. Figure 5-4. Report Menu for Daily VLUN Performance The top of the report menu includes a section that lists the current selection of systems of domains.
System Reporter 2.8 3PAR System Reporter User’s Guide For most reports, the controls in the report menu are divided into four sections: ■ 1. Report Selection: controls the type of report that will be generated, see 5.3.4 Report Selection on page 5.17. ■ 2. Time Selection: controls the time or range of time for which the report is generated, see 5.3.5 Time Selection on page 5.31. ■ 3. Object Selection: controls the specific objects to be included in the report, see 5.3.6 Object Selection on page 5.33.
3PAR System Reporter User’s Guide System Reporter 2.8 Once the report is generated, query results appear in one or more charts and/or tables in a new window (or tab) of the browser (Figure 5-5). The top of the report includes a section that describes the various selection parameters used to generate the report. NOTE: All the data that is shown in the results pane can be downloaded as a CSV (Comma Separated Values) format document (has a .
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 5-5. Query Results If necessary, use the scrollbox on the right to view all charts and/or tables. Creating Custom Reports 5.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.3 Controls Available by Report Table 5-5 lists the set of controls that are valid for generating each report. The entries have the following meanings: ■ A blank entry indicates that the control is not valid for report. ■ A Y entry indicates that the control is valid for all report types. ■ A T entry indicates that the control is valid for the report but only for Versus Time report types.
System Reporter 2.8 3PAR System Reporter User’s Guide T T T T 5.3.4.5 Group By A A A A A A A A A A A 5.3.4.6 Order By A A A A A A A A A A A 5.3.4.7 Low Bucket h h h h 5.3.4.8 High Bucket h h h h 5.3.4.9 Sum End Buckets h h h h Adaptive Optimization T Link Perf T CPU Perf VLUN Perf 5.3.4.4 Select Peak Node Cache Perf LD Perf T VV Cache Perf Port Perf T VV Space T LD Space T Section and Control PD Space 5.3.4.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.6.8 Select Snp CPGs Y 5.3.6.9 Select CPGs Y 5.3.6.10 Select LDs Y 5.3.6.11 Select RAID Types Y 5.3.6.12 Select LD Usage Y Y Y 5.3.6.13 Select VVs Y 5.3.6.14 Select Prov Types Y 5.3.6.15 Select VV Types Y 5.3.6.16 Select Ports (n:s:p) Creating Custom Reports Y Y 5.3.6.17 Select Port Types 5.16 Adaptive Optimization Y Y 5.3.6.19 Select Nodes Link Perf Y 5.3.6.7 Select Usr CPGs 5.3.6.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.6.20 Select To Nodes Y 5.3.6.21 Select Queues Y Adaptive Optimization Link Perf CPU Perf Node Cache Perf VV Cache Perf VLUN Perf LD Perf Port Perf PD Perf VV Space LD Space Section and Control PD Space Report: Summary Table 5-5. Controls for Each Report Format Selection 5.3.7.1 Report Information Y Y Y Y Y Y Y Y Y Y Y Y 5.3.7.2 Chart Types Y Y Y Y Y Y Y Y Y Y Y Y 5.3.7.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.4.1 Standard Report Types The following standard report types are available (Table 5-6): Table 5-6. Standard Report Types Report Type Purpose Versus Time Display metrics versus time. The beginning of the time range is specified by the Begin/At Time control (see Begin/At Time on page 5.31) and the end of the time range is specified by the End Time control (see on page 5.31).
System Reporter 2.8 3PAR System Reporter User’s Guide Table 5-6. Standard Report Types Report Type Purpose Histogram Display service time histogram versus time, with a separate data Versus Time series for each service time bucket between the Low Bucket (see 5.3.4.7 Low Bucket on page 5.30) and the High Bucket (see 5.3.4.8 High Bucket on page 5.30). The beginning of the time range is specified by the Begin/At Time control (see Begin/At Time on page 5.
3PAR System Reporter User’s Guide System Reporter 2.8 Figure 5-6. Versus Time Report Example In Figure 5-6. Versus Time Report Example the aggregate performance of all the selected objects (possibly in multiple systems) is shown. Typically, some components of the metric may be shown separately, for example Read and Write metrics are shown separately. 5.
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 5-7. Versus Time with Compare=System Report Example If you want to compare the performance of a particular class of objects (for example, systems), then you can use the Compare control (see section 5.3.4.3 Compare on page 5.25) available in some reports if the Report Type is Versus Time. Figure 5-7. Versus Time with Compare=System Report Example shows an example where systems are being compared.
3PAR System Reporter User’s Guide System Reporter 2.8 Figure 5-8. Group By System:Host At Time Report Example The At Time report can be used in conjunction with the Group By and Order By controls to do more detailed comparisons at a specific point in time. Figure 5-8. Group By System:Host At Time Report Example shows an At Time report with System and Host selected in the Group By control and IOPs/s selected in the Order By control.
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 5-9. Histogram Versus Time Report Example The Histogram Versus Time report provides a histogram or service times for the aggregate of the selected objects as shown in Figure 5-9. Histogram Versus Time Report Example. There is a separate line per service time bucket. Creating Custom Reports 5.
3PAR System Reporter User’s Guide System Reporter 2.8 Figure 5-10. Histogram At Time Report Example The Histogram At Time report provides a histogram or service times and IO sizes at a specific time for the aggregate of the selected objects as shown in Figure 5-10. Histogram At Time Report Example. 5.3.4.2 Select Summary Columns This control is valid only for the Summary report and selects which columns are displayed in the Summary report. 5.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.4.3 Compare This control is only valid for some Versus Time performance reports and the options available depend on the report. If the none option is selected, the aggregate performance metrics of the selected systems and objects are presented versus time. However, instead of the aggregate -- if you want to compare systems or objects -- select the appropriate Compare option.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 5-7. Group By Option Purpose System Group by InServ System. Domain Group by domain name. RAID Type Group by RAID Type. See Select RAID Types on page 5.38 for the list of RAID types and descriptions. Node Group by Controller Node. CageID Group by Cage ID. Mag Group by magazine. PDID Group by ID of the Physical Disk. ProvType Group by VV provisioning type. Disk Group by disk position in magazine. DiskType Group by Disk Type.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 5-7. Group By Option Purpose SnpCPG Group by the Usr CPG to which the VV belongs. PortNode Group by port’s node number (The n in n:s:p). n:s:p Group by the port (n:s:p). Creating Custom Reports 5.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.4.6 Order By This control is only valid for At Time reports and specifies the order of the X (category) axis for the reports. The menu options available depend on the report selected and are listed with each report. One or more Order By options can be selected (use CTRL+CLICK to select multiple options) and the default if none are selected is System. See Table 5-8 for a listing of all available options. Table 5-8.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 5-8. Order By Option Purpose LDSize Order by LD SIze. LDFreeSize Order by free space in LD. LDRawSize Order by LD Raw SIze. VV Order by VV name. VVType Order by VV type. VirtSize Order by VV virtual size. TotalRsvdSize Order by total reserved space associated with the VV. TotalRawSize Order by total raw space associated with the VV. CPG Order by the CPG that the LD belongs to.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 5-8. Order By Option Purpose Busy Percentage Order by the percentage of time that the VLUN is busy (i.e., has at least one outstanding IO operation). Total Accesses Order by total number of accesses for VV and node cache performance. ReadHit% Order by read hit% for VV and node cache performance. WriteHit% Order by write hit% for VV and node cache performance. Idle Order by Idle time for CPU performance reports.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.5 Time Selection 5.3.5.1 Reload After (mins) If you enter a number into the Reload After (mins) field, the browser will recompute and reload the report periodically after the specified number of minutes. NOTE: Reloading the report is not equivalent to periodically clicking Submit Query. The report will be reloaded with the parameter values that were set at the time Submit Query was clicked. 5.3.5.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 5-10. End Time Option Purpose most recent End with the most recent sample available. a list of specific time End at the specified time value. The values in the menu are values populated based on the actual samples in the selected data table. 5.3.5.4 Count This control is only valid for Histogram At Time or Histogram Versus Time reports. Table 5-11.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.6 Object Selection The type of object that can be selected and the available options depend on the type of report that is being generated as described in the following section. 5.3.6.1 Select PDIDs This is a filtered multi-selection control (see 4.4.2 Filtered Multi-Selection Control on page 4.5) used to select one or more PDIDs to include in the report. This control is available for PD Space and PD Performance reports. Table 5-12.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.6.3 Select Cage IDs This is a filtered multi-selection control (see 4.4.2 Filtered Multi-Selection Control on page 4.5) used to select one or more Cage IDs to include in the report. This control is available for PD Space reports. Table 5-14. Select Cage IDs Option Purpose -All Cage IDs- The report will include all the Cages that are included in the database. list of specific Cage Select one or more Cage IDs to include in the report.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.6.5 Select Disk Speed This control is available for PD Performance and PD Space reports. Table 5-16. Select Disk Speed Option Purpose -All Disk Speeds- The report will include all the Disk Speeds that are included in the database. list of specific Disk Select one or more Disk Speeds to include in the report. Speeds. Multiple Disk Speeds can be selected using (CTRL+CLICK).
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.6.7 Select Usr CPGs This is a filtered multi-selection control (see 4.4.2 Filtered Multi-Selection Control on page 4.5) used to select one or more Usr CPGs to include in the report. This control is available for VV Space reports. NOTE: For InForm OS releases prior to 2.3.1, a single CPG could be associated with a VV to provision its snapshot copy space.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.6.8 Select Snp CPGs This is a filtered multi-selection control (see 4.4.2 Filtered Multi-Selection Control on page 4.5) used to select one or more Snp CPGs to include in the report. This control is available for VV Space reports. See note in 5.3.6.7 Select Usr CPGs on page 5.36. Table 5-19. Select Snp CPGs Option Purpose -All CPGs- The report will include all the Snp CPGs that are included in the database.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.6.10 Select LDs This is a filtered multi-selection control (see 4.4.2 Filtered Multi-Selection Control on page 4.5) used to select one or more LDs to include in the report. This control is available for LD Space and LD Performance reports. Table 5-21. Select LDs Option Purpose -All LDs- The report will include all the LDs that are included in the database. list of specific LDs Select one or more LDs to include in the report.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.6.12 Select LD Usage This option is only available for the LD Space reports. Table 5-23. Select LD Usage Option Purpose -All LD Uses- Include all LD uses. V: Volume User Space Include LDs mapped to VV user space. C,SD: Copy Snapshot Include LDs mapped to VV snapshot copy data space. Data C,SA: Copy Snapshot Include LDs mapped to VV snapshot copy admin space.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.6.13 Select VVs This is a filtered multi-selection control (see 4.4.2 Filtered Multi-Selection Control on page 4.5) used to select one or more VVs to include in the report. This control is available for VV Space, VLUN Performance and VV Cache reports. Table 5-24. Select VVs Option Purpose -All VVs- The report will include all the VVs that are included in the database. list of specific VVs Select one or more VVs to include in the report.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.6.14 Select Prov Types This control is available for VV Space reports. Table 5-25. Select Prov Types Option Purpose -All Prov Types- The report will include all the VV provisioning types that are included in the database. list of specific Select one or more VV provisioning types to include in the report. provisioning types Multiple VV provisioning types can be selected using (CTRL+CLICK).
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.6.15 Select VV Types This control is available for VV Space reports and is used to select the copy type of the VV. Table 5-26. Select VV Types Option Purpose -All VV Types- The report will include all the VV Types that are included in the database. list of specific VV Select one or more VV Types to include in the report. Multiple VV Types Types can be selected using (CTRL+CLICK).
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.6.17 Select Port Types This control is only available for Port Performance reports. Table 5-28. Select Port Types Option Purpose -All Port Types- The report will include all the Port Types that are included in the database. list of specific Port Select one or more Port Types to include in the report. Multiple Types Port Types can be selected using (CTRL+CLICK).
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.6.19 Select Nodes This control is available for CPU and Link Performance reports. For Link Performance reports it is the source node for the link. Table 5-30. Select Nodes Option Purpose -All Nodes- The report will include all the Controller Nodes that are included in the database. list of specific Select one or more Nodes to include in the report. Multiple Nodes Nodes can be selected using (CTRL+CLICK). 5.3.6.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.6.21 Select Queues This control is available for Link Performance reports. Table 5-32. Select Queues Option Purpose -All Queues- The report will include all the queues that are included in the database. list of specific Select one or more Queues to include in the report. Multiple Queues Queues can be selected using (CTRL+CLICK). 5.3.
3PAR System Reporter User’s Guide System Reporter 2.8 Figure 5-11. Example of a Table 5.3.7.2 Chart Types Stacked charts stack data on top of each other so you can also see totals. However, since the total height of the stacked charts (with Stacked Bars, Stacked Vert Bars and Stacked Area charts) is the sum of the individual segments, they are not suitable for some forms of data.
System Reporter 2.8 ■ 3PAR System Reporter User’s Guide Stacked Bars Figure 5-12. Chart Using Stacked Bars ■ Stacked Vert Bars Figure 5-13. Chart Using Stacked Vert Bars Creating Custom Reports 5.
3PAR System Reporter User’s Guide ■ System Reporter 2.8 Stacked Area Figure 5-14. Chart Using Stacked Areas ■ Lines Figure 5-15. Chart Using Lines 5.
System Reporter 2.8 ■ 3PAR System Reporter User’s Guide Bars Figure 5-16. Chart Using Bars ■ Vert Bars Figure 5-17. Chart Using Vert Bars Creating Custom Reports 5.
3PAR System Reporter User’s Guide System Reporter 2.8 5.3.7.3 Chart X Pixels You can explicitly specify the length in pixels of the X (category) axis of charts. If this is left blank the X axis length will be automatically chosen. If the length specified is too small, the chart may not be drawn. 5.3.7.4 Chart Y Pixels You can explicitly specify the length in pixels of the Y (value) axis of charts. If this is left blank the Y-axis length will be automatically chosen.
System Reporter 2.8 3PAR System Reporter User’s Guide 5.3.7.7 Time Format This control selects how time values are labelled and is only valid when Report Type is Versus Time. Table 5-34. Time Format Option Purpose Auto Time format is chosen automatically based on the sample resolution. If resolution is Daily, the format includes the month, date, hours and minutes, for example: 11-29 08:32. If the resolution is hourly, the format includes the date, hours and minutes, for example: 29 08:32.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 5-35. Select Space Unit Option Purpose GiB (2^30 bytes) Space unit is 2^30 bytes (“binary” gigabyte). TB (10^12 bytes) Space unit is 10^12 bytes. TiB (2^40 bytes) Space unit is 2430 bytes (“binary” terabyte). 5.4 Working with Excel Charts When working with reports created with the Excel client, you have a variety of choices on how to format the information for presentation once the report has been generated. 5.4.
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 5-18. Change Chart Type Menu for the Excel Client 4 Choose the appropriate selection from the list of chart types, then select on the chart that you want to use to display the report data. 5 Click OK. CAUTION: The Excel Chart controls are configured for the default Chart Type. If you change the default Chart Type, you may also need to modify other chart controls for optimal viewing. 5.4.
3PAR System Reporter User’s Guide System Reporter 2.8 Using another option provided through Excel, you can have the data refreshed according to a specific schedule by modifying the properties of query table from which the charting information is derived. When the table data is refreshed, any charts based on the table will also be refreshed. Setting a table to be automatically refreshed is most applicable with a table that was created using relative time selections.
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 5-20. External Data Range Properties Dialog Box 3 Click OK. 5.4.3 Retaining Charts The 3PAR System Reporter Excel client workbook is designed to reuse data sheets, redrawing charts on the reporting tool sheets with updated data or modified query parameters as required. To redraw a chart on a reporting tools sheet with updated data or modified query parameters, use the reporting tool sheet controls to make any changes and then click Refresh.
3PAR System Reporter User’s Guide 2 System Reporter 2.8 On the shortcut menu, click Location (for Excel 2003) or Move Chart (for Excel 2007). The Chart Location (for Excel 2003) or Move Chart (for Excel 2007) dialog appears. 3 In the Chart Location or Move Chart dialog box, click As new sheet or New sheet and then click OK to move the chart to a new sheet. A new tab (with the specified name) appears at the bottom of the window for the new worksheet that holds the moved chart.
System Reporter 2.8 1 3PAR System Reporter User’s Guide Click on the appropriate tab at the bottom of the screen to access the report you want to save as an executable file. 2 Click on the Windows Office Button in the upper right corner. 3 Choose Save As, then select Microsoft Office Excel Workbook (for Excel 2007, you also have the option of saving as (Excel Macro Enabled Workbook). 4 Assign a name to the file and click Save. 5.4.
3PAR System Reporter User’s Guide System Reporter 2.8 The Dly PDSpace (1) sheet is created to hold the data represented in the chart at the bottom of the PD Space reporting tool sheet. 2 On the Dly PDSpace (1) sheet, scroll to the first empty cell to the right of Data table. In cell N52, click and type a new header for Non-failed spare.
System Reporter 2.8 3PAR System Reporter User’s Guide NOTE: The following example uses the XY chart type, which works well for HighRes, Daily, and Hourly resolutions (see Sample Resolution on page 5.6). Other chart types may not work as expected.
3PAR System Reporter User’s Guide System Reporter 2.8 If you want to move the Chart to a new sheet, right click on the chart and select Move Chart. 5.4.5.3 Saving Customized Settings After customizing data sheets and creating customized charts, save the customized workbook in Excel by using the Save As... option and saving a copy of the workbook with a new name. This saves the entire workbook, including the customizations you made to the data sheet and any custom charts.
System Reporter 2.8 3PAR System Reporter User’s Guide 6 Interpreting Report Metrics This chapter describes the metrics that are shown for each of the various reports generated through System Reporter. 6.1 Summary Report Figure 6-1 shows a typical example of the metrics that are provided by a Summary Report. Figure 6-1. Summary Report Metrics Interpreting Report Metrics 6.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 6-1 describes all of the metrics available for Summary Reports. Only some of the metrics described here are shown by default, the others depend on which columns are selected through the Select Summary Columns control (see Select Summary Columns on page 5.24). Table 6-1. Summary Report Metrics Metric Description All Columns Shows all columns. IP Address IP Address of the InServ system. OS Revision The InForm OS Revision.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 6-1. Summary Report Metrics Metric Description FC Host Ports Number of host ports. iSCSI Host Ports Number of iSCSI host ports. RCFC Ports Number of RCFC ports. RCIP Ports Number of RCIP ports. FC 15K RPM PDs Number of FC 15K physical disks. FC 10K RPM PDs Number of FC 10K physical disks. NL 7K RPM PDs Number of 7K near line physical disks. SSD PDs Number of 150 SSD physical disks. PDs Number of PDs (physical disks).
3PAR System Reporter User’s Guide System Reporter 2.8 Table 6-1. Summary Report Metrics Metric Description Host Total Svct ms Total (reads + writes) average service time in millisec to hosts. Shown by default. Host Total IOSz Kbytes Total (reads + writes) average IO size in KBytes to hosts. Host Total Queue Total (reads + writes) queue length to hosts. Length Shown by default. PD Read IOPs IO read operations/sec to PDs. PD Write IOPs IO write operations/sec to PDs.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 6-1. Summary Report Metrics Metric Description CPVVs Virtual Size GiB Virtual size in GiBs for CPVVs. Full Virtual Size GiB Total virtual size in GiBs. TPSDs Virtual Size GiB Virtual size in GiBs for TPSDs. TPVVs Virtual Size GiB Virtual size in GiBs for TPVVs. Total VV Virtual Size GiB Total VV virtual size in GiBs. Summary Report 6.
3PAR System Reporter User’s Guide System Reporter 2.8 6.2 Space Reports This section describes the metrics that are shown for the Physical DIsk (PD), Logical Disk (LD), and Virtual Volume (VV) space reports used to determine storage capacities and usage. 6.2.1 PD Space Reports PD (Physical Disk) Space reports show the amount of physical disk space composed of chunklets according to the usage types shown in Table 6-2. Table 6-2.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 6-2. Chunklet Usage Types (continued) Usage Type Description Spare, Unused, Failed Chunklets reserved as spares but unusable because they are failed. Totals Total of all the selected chunklets. The total is only shown in non-stacked charts. For charts, scroll down to locate the color key listing the chunklet types represented in the chart (Figure 6-2). Figure 6-2. Chunklet Color Key 6.2.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 6-3. LD Space Report Metrics Metric Description Free Space The LD space that is not mapped to VVs. Note that logging and preserved data LDs cannot be mapped to VVs and will show up as free space. Total The total LD space (Used Space + Free Space). Space This metric is not shown in stacked charts. 6.2.3 VV Space Reports Table 6-4 describes the metrics that are shown for VV (Virtual Volume) Space Reports Table 6-4.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 6-4. VV Space Report Metrics Metric Description User Free Space User Rsvd Space that is not actually used. This is zero for Virtual Copy (snapshot) VVs. User Rsvd Space Space that is reserved for User (base volume) Space for the selected VVs. This is zero for Virtual Copy (snapshot) VVs. Snap Used Space Snap space that is used by the selected VVs. This is zero for Virtual Copy (snapshot) VVs.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 6-4. VV Space Report Metrics Metric Description Admin Vcopy Admin Space used by Virtual Copy (snapshot) VVs only. This is zero Space for all VVs that are not Virtual Copies (snapshots). Note that this value is calculated on the InServ by running the updatesnapspace command. System Reporter does not run this command. Beginning with the InForm OS 2.3.1 release running the updatesnapspace command can be scheduled periodically on the InServ.
System Reporter 2.8 3PAR System Reporter User’s Guide 6.3 Performance Reports This section describes the metrics for reports that provide performance data for a given system. 6.3.1 Common Performance Metrics Table 6-5 describes the metrics that are shown in common for (PD, Port, LD and VLUN) performance reports when selecting the Versus TIme and At TIme report types. Table 6-5. Performance Metrics for PD, Port, LD and VLUN Performance Reports Metric Description Read IOPS Read operation per sec.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 6-5. Performance Metrics for PD, Port, LD and VLUN Performance Reports Metric Description Queue Length Queue length at the sample time. Note that (unlike the other metrics above), the queue length is an instantaneous measure at the sample time, not an average over the sample interval. Please note that due to the way that RCFC ports process data, the Queue Length may not be a valid measure.
System Reporter 2.8 3PAR System Reporter User’s Guide 6.3.2 VV Cache Performance Reports Table 6-6 describes the metrics that are shown for VV Cache Performance Reports. Table 6-6. VV Cache Performance Report Metrics Metric Description Read Hits Number of reads that hit in the cache. Read Misses Number of reads that miss in the cache. Read Total Total number of reads. Not shown in charts. Write Hits Number of writes for which the page is already in cache AND is dirty (i.e.
3PAR System Reporter User’s Guide System Reporter 2.8 6.3.3 Node Cache Performance Reports Table 6-7 describes the metrics that are shown for Node Cache Performance Reports. Table 6-7. Node Cache Performance Report Metrics Metric Description Read Hits Number of reads that hit in the cache. Read Misses Number of reads that miss in the cache. Read Total Total number of reads. Not shown in charts. Write Hits Number of writes for which the page is already in cache AND is dirty (i.e.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 6-7. Node Cache Performance Report Metrics Metric Description WriteScheduled Number of pages scheduled to be written to disk. Writing Number of pages being currently written by the flusher to disk. Recov During node down, number of dead node pages recovered that have to be written to disk. 6.3.4 CPU Performance Reports Table 6-8 describes the metrics that are shown for CPU Performance Reports. Table 6-8.
3PAR System Reporter User’s Guide System Reporter 2.8 6.3.5 Link Performance Reports Table 6-9 describes the metrics that are shown for Link Performance Reports. Table 6-9. Link Performance Report Metrics Metric Description Transfers/s Transfers per second on the link. Bandwidth Bandwidth used on the link. Transfer size Average size of the transfers on the link. 6.4 Adaptive Optimization Reports Table 6-10 describes the metrics that are shown for Adaptive Optimization Reports. Table 6-10.
System Reporter 2.8 3PAR System Reporter User’s Guide 7 Configuring the System Reporter Policy Settings This chapter describes how to edit 3PAR System Reporter policies, such as editing the sampling policies, adding or removing storage servers from the database, and scheduling reports. These actions can only be performed using a Web browser and cannot be performed using the System Reporter Excel client.
3PAR System Reporter User’s Guide System Reporter 2.8 The following options are available from the menu tabs: ■ Sampling Policies -- Configures report sampling policies. ■ InServ Systems -- Specifies the InServ Storage Servers to include for sampling and subsequent report generation and optional optimization. ■ Alert Rules -- Specifies alert rules for email reports. ■ Scheduled Reports -- Schedules reports for generation at a specified time.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 7-1. Sampling Policies Policy Default Number of days to keep Adaptive 7 Optimization hourly samples Number of days to keep daily samples 366 Ratio of Hi-Res performance samples to 6 Hi-Res space samples. Typically space changes are slower than performance so space sampling can be configured at a slower rate than performance sampling. Perform compaction of the database after daily next sample (SQLite only.
3PAR System Reporter User’s Guide System Reporter 2.8 If the policy value is set to now the compaction is done once and the value is automatically reset to 0. To achieve compaction with MySQL databases, System Reporter uses the OPTIMIZE command. For Oracle databases System Reporter uses the ALTER TABLE SHRINK SPACE command. Refer to your SQLite, MySQL or Oracle database documentation for further information about database compaction using these commands.
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 7-1. Connection Dialog Box NOTE: See About Apache HTTP Server Authorization and Access Control on page 3.34 for more instructions on setting Apache HTTP Server to require a username and password to read the database or view sampling policies. 4 In the Sampling Policies screen that appears, locate the policy to be changed and, to the right of the policy, click Change.
3PAR System Reporter User’s Guide System Reporter 2.8 Figure 7-2. Connection Dialog Box NOTE: See About Apache HTTP Server Authorization and Access Control on page 3.34 for more instructions on setting Apache HTTP Server to require a username and password in order to edit sampling policies. 6 In the New Value box, type a new value and then click Submit Query. The Sampling Policies window appears with the new value. 7 When finished editing policies, close the Sampling Policies window. 7.
System Reporter 2.8 ■ 3PAR System Reporter User’s Guide To re-configure sampling parameters for a storage server see section 7.3.4 Re-Configuring a Storage Server Sampling on page 7.8 7.3.1 Adding a Storage Server Refer to section 3.9.1 Adding InServ Systems on page 3.31 for instructions on how to add an InServ system to be sampled by System Reporter. 7.3.2 Verifying Addition of a Storage Server To verify that a new storage server was successfully added to the system table refer to 3.9.1.
3PAR System Reporter User’s Guide 7 System Reporter 2.8 Click OK to return to the Sampling Policies window. NOTE: If you want to temporarily disable sampling of a storage server, you do not need to remove it from the list of systems being sampled. Instead you can disable sampling for the storage server by checking the Disable Sampling parameter for the storage server as described in 7.3.4 Re-Configuring a Storage Server Sampling on page 7.8.
System Reporter 2.8 3PAR System Reporter User’s Guide 7.4 Configuring Rules for Email Alerts System Reporter can be configured to evaluate numerous rules and generate email alerts to specified recipients for each rule whose conditions are met. 7.4.1 Adding an Alert Rule To add an alert rule: 1 Point your browser at the Web server where Apache HTTP Server and the 3PAR System Reporter Web server scripts are installed. The 3PAR System Reporter main window appears.
3PAR System Reporter User’s Guide System Reporter 2.8 13 Enter the Condition Value to specify the minimum amount that is to be met for the associated condition. 14 Enter the Recipient email address to whom the alert for this rule should be sent. 15 Click Submit Query. 16 An alert window appears confirming that the alert rule was added. 17 Click OK to return to the Sampling Policies window. 7.4.
System Reporter 2.8 3PAR System Reporter User’s Guide The 3PAR System Reporter Policies window appears. 3 Choose the Alert Rules tab. 4 Click Remove Alert. 5 Select the alert rule to remove from the drop-down list. 6 Click Submit Query. 7 An alert window appears confirming that the alert rule was removed. 8 Click OK to return to the Sampling Policies window. 7.4.4 Alert Rule Parameters Alert rules are specified using parameters described in the following sections. 7.4.4.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 7-2. Data Table Data Table Description statpd_fc15 Restricts statpd to only the FC 15K RPM PDs. statpd_ssd150 Restricts statpd to only the SSD PDs with speed 150. statpd_sum Represents the aggregation of all the PDs in the InServ system. statpd_nl7sum Represents the aggregation of all the NL 7.2K RPM PDs in the InServ system. statpd_fc10sum Represents the aggregation of all the FC 10K RPM PDs in the InServ system.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 7-3. Resolution Resolution Description hires Data table that contains the high resolution samples. hourly Data table that contains the hourly samples daily Data table that contains the daily samples 7.4.4.3 System If System is specified, the alert rule is calculated only for objects in the specified system. If System is left blank the alert rule is calculated for all systems. 7.4.4.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 7-4.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 7-4.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 7-4.
System Reporter 2.8 3PAR System Reporter User’s Guide 7.4.4.7 Limit Count The alert will only be generated if the number of objects for which the Metric exceeds the Limit Value (in the direction specified by Direction) is greater than Limit Count in any given sample. This should be an integer. 7.4.4.8 Condition Specifies the condition (min_read_iops, min_write_iops, min_total_iops) that should be monitored. 7.4.4.9 Condition Value Specifies the condition value. 7.4.4.
3PAR System Reporter User’s Guide System Reporter 2.8 The email shows that a single VLUN instance had an average total service time of 2098.800680 millisec during a high-resolution sampling interval. 7.5 Scheduling Reports You can have a predefined report run according to a predetermined schedule by choosing the Scheduled Reports tab from the System Reporter Policies window (Figure 7-5). Figure 7-5.
System Reporter 2.8 3PAR System Reporter User’s Guide Each time the report runs, a new subdirectory is created for that instance of the report with the timestamp as the name. All of the PNG image files, the .CSV file and the .html file will be placed in that subdirectory.
3PAR System Reporter User’s Guide System Reporter 2.8 6 Specify the report name. 7 Specify the report schedule. Hold the CTRL key to pick multiple dates and times. The minimum possible granularity of a scheduled report is 1 hr. 8 Specify the report URL parameters (you can copy these from the address bar of the report that define the report). Do not include the http:// portion of the URL. The maximum size of a URL should not exceed 4000 characters.
System Reporter 2.8 3PAR System Reporter User’s Guide 7.5.3 Removing a Scheduled Report To remove a scheduled report: 1 Point your browser at the Web server where Apache HTTP Server and the 3PAR System Reporter Web server scripts are installed. The 3PAR System Reporter main window appears. 2 Click on Policy Settings in the Extras Menu area. The System Reporter Policies window appears. 3 Choose the Scheduled Reports tab. The Scheduled Reports window appears. 4 Click Remove Scheduled Report.
3PAR System Reporter User’s Guide System Reporter 2.8 7.6 Configuring Adaptive Optimization An optionally licensed Adaptive Optimization component is included with System Reporter that can be used to monitor and optimize storage utilization. NOTE: See Chapter 9, Using Adaptive Optimization for complete details on how to configure and use Adaptive Optimization. 7.
System Reporter 2.8 3PAR System Reporter User’s Guide 7.8 Modifying the Apache HTTP Server Configuration Files You must modify the Apache HTTP Server config.tcl files located in the 3par-policy and 3par-rpts subdirectories whenever you change MySQL user names and passwords. 1 Go to the Apache HTTP server cgi-bin directory and locate the 3par-policy subdirectory (for example: C:\Program Files\ApacheGroup\Apache2\cgi- bin\3par-policy). 2 In the 3par-policy subdirectory, locate the config.
3PAR System Reporter User’s Guide 7 At the bottom of the file, alter the $dbuser = and $dbpasswd = fields as necessary. # Select the type of database (sqlite or mysql): $main::dbtype = 'mysql'; $main::dbhost = 'localhost'; # Enter database name $main::dbname = 'inservstats'; # Enter database user name and password $main::dbuser = 'webuser'; $main::dbpasswd = 'password'; 7.24 System Reporter 2.
System Reporter 2.8 3PAR System Reporter User’s Guide 8 Web Queries This chapter documents the queries that the 3PAR System Reporter interfaces make to the System Reporter Web server. 8.1 About Web Queries System Reporter Web queries have the following basic format: http:///cgi-bin/3par-rpts/ inserv_perf.exe?report=[&
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: In the above example and elsewhere in this chapter, the following typographical conventions are used: ■ variables are denoted by angle brackets (for example, ) ■ braces denote optional items (for example [&
System Reporter 2.8 3PAR System Reporter User’s Guide where is the name of your server. The following is an example of the table returned: Figure 8-1. System Reporter Version Report This query returns a 3x3 table with the column headers Category, Major, and Minor. The two rows after the header contain major and minor numbers for Product and ReportData. The Product version numbers are informational only and are the numbers assigned to the product when it is released.
3PAR System Reporter User’s Guide System Reporter 2.8 The definitions of queries and the data they return given below are version 4.1. A client coded to these definitions would compare major number 4 and minor number 1 against the server's Report Data major and minor numbers. 8.3 About Reports and Options There are five categories of reports that you can generate using System Reporter: ■ summary reports (see Summary Report on page 8.45) ■ space reports (see Space Reports on page 8.
System Reporter 2.8 3PAR System Reporter User’s Guide NOTE: The System Reporter maintains three database tables that each offer a different granularity of resolution and stored time range. See also Sample Resolution on page 5.6. Specify one of the following: daily (Default). Specifies that results will be pulled from the daily database table. For the daily database table, the storage server is sampled once daily, shortly after midnight.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.2.1 values: Specify one of the following: none (Default) No comparison is performed. System Compares the set of systems specified with the query or all systems if none are specified. Domain Compares the set of domains specified with the query or all domains if none are specified. PortType Compares selected port types. This value is only available for the port_perf_time report. DiskType Compares selected disk types.
System Reporter 2.8 3PAR System Reporter User’s Guide Host Compares selected hosts. This value is only available for the vlun_perf_time report. VV Compares selected volumes. This value is only available for the vlun_perf_time and vv_space_time reports. VVType Compares selected VV Type. This value is only available for the vv_space_time report. ProvType Compares selected VV Provisioning Type. This value is only available for the vv_space_time report. LDUsage Compares selected LD Usage.
3PAR System Reporter User’s Guide System Reporter 2.8 Disk Compares selected disk magazine position. This value is only available for the pd_space_time report. 8.4.2.2 example: The following example specifies that all logical disks are compared: &compare=LD 8.4.3 comparesel When the compare option (see compare on page 8.5) is used, up to 16 objects can be compared. However, if there are more than 16 objects selected, then the comparesel option is used to select a metric.
System Reporter 2.8 3PAR System Reporter User’s Guide interrupts The CPU interrupts per second. ctxtsws The CPU context switches per second. total_space The total selected space. raw_space The raw space (including RAID overhead). used_space The used space. free_space The free space. TotalRsvdSize The total reserved size. TotalRawSize The total raw (including RAID overhead) size. VirtSize The virtual size. 8.4.
3PAR System Reporter User’s Guide System Reporter 2.8 pdspace Returns values from the pdspace database tables. vvspace Returns values from the vvspace database tables. statpd Returns values from the statpd database tables. statld Returns values from the statld database tables. statvlun Returns values from the statvlun database tables. statvvcmp Returns values from the statvvcmp database tables. statcmp Returns values from the statcmp database tables.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.4.5 refresh Use the refresh option to have the web browser automatically reload the report with the same options after the specified number of minutes. This option can only be specified once in a given query string. 8.4.5.1 values: Specify an integer number of minutes. Any other value will be ignored. 8.4.5.2 example: The following example specifies that the report is to be reloaded every 2 minutes: &refresh=2 8.4.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.6.2 example: The following example specifies that query results are to be displayed in the form of one or more charts: &charttab=chart 8.4.7 charttype Use the charttype option in conjunction with charttab=chart or charttab=both to specify the chart type to be used when results are to be displayed in chart form. This option can only be specified once in a given query string.
System Reporter 2.8 3PAR System Reporter User’s Guide bars (Default). Specifies that bar charts will be used. See Figure 5-16 on page 5.49 for an example of a bar chart. vbars Specifies that vertical bar charts will be used. See Figure 5-17 on page 5.49 for an example of a bar chart lines Specifies that line graph charts will be used. See Figure 5-15 on page 5.48 for an example of a chart using lines. 8.4.7.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.9.1 value: Specify an integer number of pixels. 8.4.9.2 example: The following example specifies that the chart Yaxis should be 300 pixels. charttab=chart&charttype=lines&graphy=300 8.4.10 graphlegpos Use the graphlegpos option to specify the position of the chart legend. If not defined, the legend position is selected automatically based on the charttype. This option can only be specified once in a given query string. 8.4.10.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.4.11.1 value: excel This option causes the results in the left column of the table to be preceeded by an apostrophe so that Excel will not perceive values as numbers. See Objects Present Reports on page 8.61 for additional details. 8.4.11.2 example: The following example specifies that results in the left column of the table are to be preceded by an apostrophe so that Excel will not perceive the values as a numbers: tableformat=excel 8.4.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.13 timeform Use the timeform option to specify a time format (either relative or absolute) when using a report that requires a time range. This option can only be specified once in a given query string. 8.4.13.
System Reporter 2.8 3PAR System Reporter User’s Guide If this option is not defined, ■ for reports that require a time range, the earliest available time is applied. ■ for reports that only require a begintsecs time, the most recent available time is applied. ■ for objects_present reports (see Objects Present Reports on page 8.61), the earliest available time is applied.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.15.1 value: If is non-negative it represents a point in time, expressed as the number of seconds since January 1, 1970, GMT. For example, to express 2005/07/13 11:00:34 as a value, use the value 1121277634. If is negative, it represents a point in time seconds before the current time. NOTE: You can use the sample_times report (see sample_times on page 8.
System Reporter 2.8 3PAR System Reporter User’s Guide Domain Group results by domain. Host Group results by hosts. CPG Group results by Common Provisioning Group (CPG) name. UsrCPG Group results by Common Provisioning Group (CPG) name for the User Space of VVs. SnpCPG Group results by Common Provisioning Group (CPG) name for the Snap Space of VVs. VV Group results by Virtual Volume (VV) name. VVType Group results by Virtual Volume (VV) Type.
3PAR System Reporter User’s Guide System Reporter 2.8 LDUsage Group results by logical disk usage. See Table 5-22 on page 5.39 for a list of these usage types. DiskType Group results by physical disk type. DiskSpeed Group results by physical disk speed. CageID Group results by drive cage ID number. Mag Group results by magazine position within the drive cage (0 through 7). Disk Group results by disk position on a magazine (0 through 3). PDID Group results by physical disk ID number.
System Reporter 2.8 3PAR System Reporter User’s Guide The following example specifies that results should be grouped by system, drive magazine, and physical disk ID: &groupby=System&groupby=Mag&groupby=PDID 8.4.17 orderby Use the orderby option to determine how to order results. The orderby option can be used multiple times in the same query string. When multiple orderby options are used the order of the objects specified with the orderby option is relevant.
3PAR System Reporter User’s Guide System Reporter 2.8 SnpCPG Order results by Common Provisioning Group (CPG) name for the Snap Space of VVs. VV Order results by Virtual Volume (VV) name. VVType Order results by Virtual Volume (VV) Type. ProvType Order results by Virtual Volume (VV) provisioning type. LD Order results by Logical Disk (LD) name. n:s:p Order results by port. For this value, an escape sequence may be required to retain spacing and special characters (for example: n%3As%3Ap).
System Reporter 2.8 3PAR System Reporter User’s Guide Mag Order results by magazine position within the drive cage (0 through 7). Disk Order results by disk position on a magazine (0 through 3). PDID Order results by physical disk ID number. Node Order results by controller node number (0-7, depending on the storage server model and configuration). IOPs Order results by I/O per second. Bandwidth Order results by bandwidth. Service Time Order results by service time.
3PAR System Reporter User’s Guide Idle Order results by CPU idle percentage. Intr Order results by CPU interrupts/sec. Ctxt Order results by CPU context switches/sec. VirtSize Order results by VV virtual size. TotalRsvdSize Order results by VV reserved space size. TotalRawSize Order results by VV total raw reserved space size. LDSize Order results by total LD size. LDFreeSize Order results by total free LD size. LDRawSize Order results by total raw LD size.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.4.17.2 example: The following example specifies that results should be ordered by system: &orderby=System The following example specifies that results should be ordered by system, disk type, and physical disk ID: &orderby=System&orderby=DiskType&orderby=PDID 8.4.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.19.1 values: Specify one of the following: MiB (2^20 bytes) (Default). Use megabytes (1,048,576 bytes) as the logical disk space unit. For this value, an escape sequence may be required to retain spacing and special characters (for example, “MiB%20%282%5E20%20bytes%29”). GB (10^9 bytes) Use gigabytes (1,000,000 bytes) as the logical disk space unit.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.4.20.1 values: Specify one of the following: Chunklets (Default). Use the chunklet (a 256-MB block of contiguous space on a physical disk) as the physical disk space unit. GB (10^9 bytes) See ldspaceunit on page 8.25. GiB (2^30 bytes) See ldspaceunit on page 8.25. 8.4.20.
3PAR System Reporter User’s Guide System Reporter 2.8 GB (10^9 bytes) See ldspaceunit on page 8.25. GiB (2^30 bytes) (Default). See ldspaceunit on page 8.25. 8.4.21.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.4.22.2 examples: The following example shows two ways to include cages regardless of their cage IDs: &selcageid= OR &selcageid=--All%20Cage%20IDs-- The following example includes only physical disks in cage number 1: &selcageid=1 The following example includes only physical disks in cages number 1, 3 or 5: &selcageid=1&selcageid=3&selcageid=5 8.4.23 selchunks Use the selchunks option to include chunklets according to their chunklet type.
3PAR System Reporter User’s Guide System Reporter 2.8 NRM_AVAIL_FAIL Include only normal available (unused) chunklets that are failed. SPR_USED_OK Include only spare used chunklets that are OK. SPR_USED_FAIL Include only spare used chunklets that have failed. SPR_AVAIL_CLEAN Include only spare available (unused) chunklets that have been cleaned (initialized). SPR_AVAIL_DRTY Include only spare available (unused) chunklets that are still being cleaned (and are uninitialized).
System Reporter 2.8 3PAR System Reporter User’s Guide 8.4.24 selcpg Use the selcpg option to select a common provisioning group (CPG). 8.4.24.1 value: Specify one or more of the following: --All CPGs-(Default). This value does not exclude CPGs based on their names. This value consists of a CPG name. 8.4.24.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.27.1 value: Specify one or more of the following: --All Disk Types-(Default). This value does not exclude disks based on their type. FC This value allows you to include only Fibre Channel type disks. NL This value allows you to include only Near Line type disks. 8.4.27.
System Reporter 2.8 3PAR System Reporter User’s Guide 10 This value allows you to include only 10K RPM disks. 7 This value allows you to include only 7200 RPM disks. 8.4.28.2 example: The following examples show two ways to include disks regardless of speed: &seldiskspeed= OR &seldiskspeed=--All%20Disk%20Speeds-- The following example specifies that only 10K RPM disks are to be included: &seldiskspeed=10 8.4.29 seldomain Use the seldomain option to select a domain according to the domain name. 8.4.
3PAR System Reporter User’s Guide System Reporter 2.8 The following example specifies including only VLUNs belonging to domain domain1: &seldomain=domain1 The following example specifies including only VLUNs belonging to domain domain1 or domain2: &seldomain=domain1&seldomain=domain2 8.4.30 selhost Use the selhost option to select a host according to the host name. 8.4.30.1 value: Specify one or more of the following: --ALL Hosts-(Default). Does not exclude any hosts based on host names.
System Reporter 2.8 3PAR System Reporter User’s Guide The following example specifies including only VLUNs exported to host winhost1 or winhost2: &selhost=winhost1&selhost=winhost2 8.4.31 selld Use the selld option to select logical disks according to their LD names. 8.4.31.1 value: Specify one or more of the following: --All LDs-(Default). Does not exclude logical disks based on their names. This value consists of a logical disk name. 8.4.31.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.32.1 values: Specify one or more of the following: V Includes only logical disks used for volume user space. C,SD Includes only logical disks used for copy snapshot data. C,SA Includes only logical disks used for copy snapshot administration. P Includes only logical disks used for preserved data. P,F Includes only logical disks used for first preserved data. log Includes only logical disks used for logging. 8.4.32.
System Reporter 2.8 3PAR System Reporter User’s Guide --All Nodes-(Default). Specifies that nodes are not to be excluded based on their names. This value consists of a controller node number (value is an integer between 0 and 7). 8.4.33.2 example: The following example shows two ways to specify that nodes are not to be excluded based on name: &selnode= OR &selnode=--All%20Nodes-- The following example specifies that nodes 0 and 1will be included: &selnode=0&selnode=1 8.4.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.34.2 example: The following example shows two ways to specify that no ports are to be excluded based on location: &selnsp= OR &selnsp=--All%20Ports-- The following example specifies that only port 0:1:1 will be included: &selnsp=0%3A1%3A1 8.4.35 selpdid Use the selpdid option to select physical disks according to the physical disk ID. 8.4.35.1 value: Specify one or more of the following: --ALL PDIDs-(Default).
System Reporter 2.8 3PAR System Reporter User’s Guide 8.4.36 selpdstate Use the selpdstate option to select physical disks according to their state (valid or Not valid). 8.4.36.1 values: Specify one or more of the following: --All PD States-(Default). PDs are not excluded based on their state. valid Specify this value to include all valid physical disks. Not valid Specify this value to include only physical disks that do not have a state of valid.
3PAR System Reporter User’s Guide System Reporter 2.8 --All Port Types-(Default). All port types are selected. disk Specify this value to include only ports connected to disks. free Specify this value to include only free ports. host Specify this value to include only ports connected to hosts. rcip Specify this value to include only Remote Copy over IP ports. rcfc Specify this value to include only Remote Copy over Fibre Channel ports. iscsi Specify this value to include only iscsi ports. 8.4.37.
System Reporter 2.8 3PAR System Reporter User’s Guide 1 Specify this value to include RAID 1 logical disks. 5 Specify this value to include RAID 5 logical disks. 6 Specify this value to include RAID 6 logical disks. 8.4.38.2 example: The following example specifies inclusion of all logical disks regardless of RAID level: &selraidtype= The following example includes RAID 1 and RAID 5 logical disks only: &selraidtype=1&selraidtype=5 8.4.
3PAR System Reporter User’s Guide System Reporter 2.8 8.4.39.2 example: The following example shows two ways to specify that storage servers should not be excluded based on their names: &selsys= OR &selsys=--All%20Systems--& The following example includes data from InServ1: &selsys=InServ1 8.4.40 selvv Use the selvv option to specify virtual volumes according to their names. 8.4.40.1 values: Specify one or more of the following: --All VVs-(Default).
System Reporter 2.8 3PAR System Reporter User’s Guide 8.4.41 selvvtype Use the selvvtype option to specify virtual volumes according to their types. 8.4.41.1 values: Specify one or more of the following: --All VV Types-(Default). Does not exclude virtual volumes based on their types. base Select base VVs. vcopy Select Virtual Copy (snapshot) VVs. pcopy Select Full Copy (physical copy) VVs. 8.4.42 selprovtype Use the selprovtype option to specify virtual volumes according to their provisioning types.
3PAR System Reporter User’s Guide System Reporter 2.8 tpvv Select thin provisioned VVs that have separate User and Snap spaces. tpsd Select old-style (created before InForm OS release 2.3.1) thin provisioned VVs that have user and snapshot data allocated from a single Snap Space. snp Select snapshot VVs. 8.
System Reporter 2.8 ■ performance reports ■ objects present reports 3PAR System Reporter User’s Guide 8.6 Summary Report 8.6.1 summary Shows summary information for all systems. 8.6.1.1 example: The following example shows the entire query string for a summary report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?category=daily&pdspaceunit=Chunklets&report=summary 8.7 Space Reports 8.7.
3PAR System Reporter User’s Guide System Reporter 2.8 8.7.2.1 example: The following example shows the entire query string for a pd_space_group report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& pdspaceunit=Chunklets&selsys=--All%20Systems--&selpdid=--All%20PDIDs--& selchunks=&selpdstate=--All%20PD%20States--&selcageid=--All%20Cage%20IDs--& seldisktype=--All%20Disk%20Types--& groupby=System&orderby=System&report=pd_space_group 8.7.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.7.5 vv_space_time Plots the virtual size as well as raw and LD space used by the user, snap, and admin (on y-axis) versus time (on the x-axis). For the LD space, it separates free and used space. 8.7.5.1 example: The following example shows the entire query string for a vv_space_time report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.
3PAR System Reporter User’s Guide System Reporter 2.8 respectively, being aggregated over the other object types (e.g., aggregated over selected PDs and ports when compare=System). 8.8.1.1 example: The following example shows the entire query string for a pd_perf_time report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.8.4 pd_svt_histvstime Plots the service time histogram of all the physical disks in the selected systems versus time. 8.8.4.1 example: The following example shows the entire query string for a pd_svt_histvstime report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=lines&category=daily&begintsecs=& selsys=--All%20Systems--&selpdid=--All%20PDIDs--&selnsp=--All%20Ports-&histbegin=1&report=pd_svt_histvstime 8.8.
3PAR System Reporter User’s Guide System Reporter 2.8 8.8.6.1 example: The following example shows the entire query string for a port_perf_group report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?category=daily&charttab=chart&charttype=stackedbars&refresh=&begin tsecs=&selsys=--All%20Systems--&selporttype=--All%20Port%20Types--&selnsp=-All%20Ports--&groupby=System&orderby=System&report=port_perf_group 8.8.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.8.9.1 example: The following example shows the entire query string for a ld_perf_time report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& endtsecs=&timeform=absolute&selsys=--All%20Systems--&selld=--All%20LDs-&report=pd_perf_time 8.8.
3PAR System Reporter User’s Guide System Reporter 2.8 8.8.12.1 example: The following example shows the entire query string for a ld_svt_histvstime report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& selsys=--All%20Systems--&selld=--All%20LDs--&histbegin=1&report=ld_svt_histvstime 8.8.
System Reporter 2.8 3PAR System Reporter User’s Guide Plots the service time histogram of all the VLUNs (exports) in the selected systems at a specific time. 8.8.15.1 example: The following example shows the entire query string for a vlun_svt_hist report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& selsys=--All%20Systems--&selhost=--All%20Hosts--&selvv=--All%20VVs--& selnsp=--All%20Ports--&histbegin=1&report=vlun_svt_hist 8.8.
3PAR System Reporter User’s Guide System Reporter 2.8 8.8.18.1 example: The following example shows the entire query string for a vv_cmp_group report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?category=daily&charttab=chart&charttype=stackedbars&refresh=&begin tsecs=&selsys=--All%20Systems--&selvv=--All%20VVs-&groupby=System&orderby=System&report=vv_cmp_group 8.8.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.9 Adaptive Optimization Reports 8.9.1 regiodensity Returns a region I/O density report over the requested interval (from begintsecs to endtsecs). The report is a histogram where the buckets are various region I/O access rates (accesses per GiB per minute). Two values are shown for each bucket: ■ the total space for regions in that bucket, and ■ the total accesses/min for the regions in that bucket. 8.9.1.
3PAR System Reporter User’s Guide System Reporter 2.8 8.9.3.1 vvtier example The following example shows the entire query string for a vvtier report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&selsys=3par1&report=vvtier 8.10 Options Available by Report Table 8-1 lists the options that are valid for summary and space report and Table 8-2 lists the options that are valid for performance reports.
System Reporter 2.8 3PAR System Reporter User’s Guide vv_space_time vv_space_group regiodensity regmoves vvtier Y ld_space_group tableformat ld_space_time grpahlegpos pd_space_group Option summary Report: pd_space_time Table 8-1.
3PAR System Reporter User’s Guide System Reporter 2.8 M M M M vvtier M regmoves ld_space_group M regiodensity ld_space_time M vv_space_group pd_space_group M vv_space_time pd_space_time Table 8-1.
System Reporter 2.8 3PAR System Reporter User’s Guide nd_cmp_group nd_cmp_time link_perf_group link_perf_time cpu_perf_group cpu_perf_time vv_cmp_group vv_cmp_time vlun_svt_histvstime vlun_svt_hist vlun_perf_group vlun_perf_time ld_svt_histvstime ld_svt_hist ld_perf_group ld_perf_time port_svt_histvstime port_svt_hist port_perf_group port_perf_time pd_svt_histvstime pd_svt_hist Option pd_perf_group Report: pd_perf_time Table 8-2.
3PAR System Reporter User’s Guide System Reporter 2.8 histhbkt Y Y Y Y histsum Y Y Y Y nd_cmp_group nd_cmp_time link_perf_group link_perf_time cpu_perf_group cpu_perf_time vv_cmp_group vv_cmp_time vlun_svt_histvstime vlun_svt_hist vlun_perf_group vlun_perf_time ld_svt_histvstime ld_svt_hist ld_perf_group ld_perf_time port_svt_histvstime port_svt_hist port_perf_group port_perf_time pd_svt_histvstime pd_svt_hist Option pd_perf_group Report: pd_perf_time Table 8-2.
System Reporter 2.8 3PAR System Reporter User’s Guide selpdid nd_cmp_group nd_cmp_time link_perf_group link_perf_time cpu_perf_group cpu_perf_time vv_cmp_group vv_cmp_time vlun_svt_histvstime vlun_svt_hist vlun_perf_group vlun_perf_time ld_svt_histvstime ld_svt_hist ld_perf_group ld_perf_time port_svt_histvstime port_svt_hist port_perf_group port_perf_time pd_svt_histvstime pd_svt_hist Option pd_perf_group Report: pd_perf_time Table 8-2.
3PAR System Reporter User’s Guide System Reporter 2.8 The objects_present report requires the category (see category on page 8.4) and table (see table on page 8.9) parameters. The category parameter must be one of daily, hourly or hires. The valid table values for the report are described in Table 8-3 on page 8.64. Exactly one value for the category and table parameters must be specified.
System Reporter 2.8 3PAR System Reporter User’s Guide using tableformat=excel without using tableformat=excel Figure 8-2. Using the tableformat=excel Option Objects Present Reports 8.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 8-3. Objects Present Report table values Report table values objects_present&objectpres= cageid on page 8.65 pdspace objects_present&objectpres= cpg_name on page 8.66 ldspace vvspace statld objects_present&objectpres= diskspeed on page 8.67 pdspace statpd objects_present&objectpres= disktype on page 8.68 ldspace pdspace statpd objects_present&objectpres= domain_name on page 8.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 8-3. Objects Present Report table values (continued) Report table values objects_present&objectpres= system on page 8.74 ldspace pdspace vvspace statcpu statpd statport statld statvlun statvvcmp objects_present&objectpres= vv_name on page 8.75 statvlun statvvcmp vvspace objects_present&objectpres= vv_name_nosnap on page 8.76 vvspace objects_present&objecctpres= porttype on page 8.77 statport sample_times on page 8.
3PAR System Reporter User’s Guide System Reporter 2.8 8.11.1.1 example: The following example shows the entire query string for objects_present&objectpres=cageid: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=cageid&table=pdspace& category=daily 8.11.1.2 output: Returns a row for each drive cage ID number on each system. Output columns are: ■ System: the system name ■ CageID: drive cage ID numbers The following is example output of the query: 8.11.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.11.2.1 example: The following example shows the entire query string for objects_present&objectpres=cpg_name: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=cpg_name&table=ldspace& category=hires 8.11.2.2 output: Returns a row for each common provisioning group on each system. Output columns are: ■ System: the system name ■ CPG: common provisioning group name.
3PAR System Reporter User’s Guide System Reporter 2.8 8.11.3.1 example: The following example shows the entire query string for objects_present&objectpres=diskspeed: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=diskspeed&table=statpd& category=daily 8.11.3.2 output: Returns a row for each disk speed on each system. Output columns are: ■ System: the system name ■ DiskSpeed: list of disk speed 8.11.4 objectpres= disktype Returns a list of disk types. 8.11.4.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.11.5 objectpres= domain_name Returns a list of domain names. 8.11.5.1 example: The following example shows the entire query string for objects_present&objectpres=domain_name: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=domain_name& table=statvlun&category=daily 8.11.5.2 output: Returns a row for each domain present over the time range on each system.
3PAR System Reporter User’s Guide 8.11.6.1 example: The following example shows the entire query string for objects_present&objectpres=host_name: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=host_name& table=statvlun&category=daily 8.11.6.2 output: Returns a row for each host present over the time range on each system. Output columns are: ■ System: the system name ■ Host: host names The following is example output of the query: 8.11.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.11.7.1 example: The following example shows the entire query string for objects_present&objectpres=ld_name: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=ld_name&table=ldspace& category=hourly 8.11.7.2 output: Returns a row for each logical disk present over the time range for each system.
3PAR System Reporter User’s Guide 8.11.8.1 example: The following example shows the entire query string for objects_present&objectpres=node: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=node&table=statcpu& category=hourly 8.11.8.2 output: Returns a row for each node present over the time range for each system. Output columns are: ■ System: the system name ■ Node: controller node number The following is example output of the query: 8.11.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.11.9.1 example: The following example shows the entire query string for objects_present&objectpres=pdid: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=pdid&table=pdspace& category=daily 8.11.9.2 output: Returns a row for each physical disk present over the time range for each system.
3PAR System Reporter User’s Guide System Reporter 2.8 8.11.10.1 example: The following example shows the entire query string for objects_present&objectpres=port: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=port&table=statvlun& category=daily 8.11.10.2 output: Returns a row for each port present over the time range for each system.
System Reporter 2.8 3PAR System Reporter User’s Guide 8.11.11.1 example: The following example shows the entire query string for objects_present&objectpres=system using: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=system&table=pdspace& category=daily 8.11.11.2 output: Returns a row for each system present over the time range for each system. Output columns are: ■ System: system name ■ IP Name: system IP name The following is example output of the query: 8.
3PAR System Reporter User’s Guide System Reporter 2.8 8.11.12.2 output: Returns a row for each virtual volume present over the time range for each system. Output columns are: ■ System: system name ■ VV: virtual volume names The following is example output of the query: 8.11.13 objectpres= vv_name_nosnap Returns a list of virtual volume names, excluding snapshot volumes. 8.11.13.
System Reporter 2.8 ■ System: system name ■ VV: virtual volume name 3PAR System Reporter User’s Guide The following is example output of the query: 8.11.14 objecctpres= porttype Returns a list of port types. 8.11.14.1 example: The following example shows the entire query string for objects_present&objectpres=porttype: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=porttype&table=statport& category=daily 8.11.14.
3PAR System Reporter User’s Guide System Reporter 2.8 8.11.15 sample_times Returns valid times of database samples. 8.11.15.1 example: The following example shows the entire query string for sample_times: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=sample_times&category=daily&table=pdspace 8.11.15.2 output: Returns a row for each time sample in the given table for the given category (resolution).
System Reporter 2.8 3PAR System Reporter User’s Guide Objects Present Reports 8.
3PAR System Reporter User’s Guide 8.80 Objects Present Reports System Reporter 2.
System Reporter 2.8 3PAR System Reporter User’s Guide 9 Using Adaptive Optimization This chapter provides information about the optionally licensed Adaptive Optimization feature that works in conjunction with System Reporter to optimize storage utilization across multiple tiers. NOTE: Adaptive Optimization is only supported by InForm OS versions 2.3.1 MU 1 and beyond. 9.
3PAR System Reporter User’s Guide System Reporter 2.8 and tier 2 is the slowest. Tiers are defined by Common Provisioning Groups (CPGs) and all of the cost and performance characteristics of the tier are determined by the setting of the CPG, such as the RAID level, number of disks used, disk type and speed. You can also control the maximum space available for each tier. See section 9.3.1 Tier Definition (CPG Name and GiB) on page 9.6 for more details.
System Reporter 2.8 3PAR System Reporter User’s Guide 9.2 Selecting an InServ for Adaptive Optimization To begin using Adaptive Optimization on an InServ array, you must either add it configured to include collection of data (region-level data) for sampling purposes (see 3.9.1 Adding InServ Systems on page 3.31) or change the configuration to include the data. To change the configuration, click on the InServ Systems tab in the System Reporter Policies window. Figure 9-1.
3PAR System Reporter User’s Guide System Reporter 2.8 been checked and is set to 1. In addition, the Skip LD Performance Data should not be set since Adaptive Optimization also looks at LD performance data. NOTE: In order to use Adaptive Optimization to perform system optimization, you need to have Edit level privileges on the arrays where this capability is implemented. 9.
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 9-2. Adaptive Optimization Configuration Main Window The following information is provided for each Adaptive Optimization configuration: ■ Id -- A unique identification number assigned automatically to the configuration when it is created. ■ InServ -- Name of the InServ Storage Server for which the configuration is implemented. ■ Tier # CPG Name -- CPG name associated with a given tier (0 - 2) (see 9.3.
3PAR System Reporter User’s Guide ■ System Reporter 2.8 Mode -- Optimization mode (Cost/Performance/Balanced. See 9.3.4 Adaptive Optimization Mode on page 9.10). ■ Active -- Indicates whether or not optimization is currently implemented (true/false). ■ Change -- Clicking on this link brings up a screen used to change the configuration. 9.3.1 Tier Definition (CPG Name and GiB) Each tier is defined by the CPG and the maximum space that the tier should use.
System Reporter 2.8 3PAR System Reporter User’s Guide The TPVV usr space and Snapshot copy space for a CPG can be examined using the InForm CLI showvv -cpg alloc command. Since this space may need to grow on demand as the host writes the VV or snapshot, you should make sure that the CPG associated with the TPVV usr space and Snapshot copy space has room to grow (i.e., you should not associate TPVV usr space with a space-constrained SSD CPG).
3PAR System Reporter User’s Guide System Reporter 2.8 CAUTION: You can remove a CPG from a configuration by either specifying a different CPG in its place or by setting the tier’s CPG to “-” (no CPG). However, when a CPG is removed from a configuration, all the VV space mapped to LDs in that CPG remain in that CPG, Adaptive Optimization does not move them to a different CPG. And since Adaptive Optimization no longer considers that CPG in its analysis that space will remain there.
System Reporter 2.8 3PAR System Reporter User’s Guide 9.3.2 Schedule The schedule consists of three components: dates, weekdays and hours. You can choose multiple values of each of these components to create a schedule for when each adaptive optimization configuration executes. NOTE: Adaptive optimization configurations may be scheduled to run at intervals that are shorter than their measurement hours (see 9.3.3 Measurement Hours on page 9.9).
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: The measurement hours selected should not exceed the retention time for adaptive optimization samples set in the sampling policies (see 7.2.2 Editing Sampling Policies on page 7.4). 9.3.
System Reporter 2.8 3PAR System Reporter User’s Guide NOTE: When you add a new InServ to be sampled, the system, its domains and the CPGs that are available may not appear until after the CPG space data has been sampled for that system. 3 Choose a domain. 4 Choose the CPG that is to be monitored and optimized for each tier. Up to 3 tiers may be defined. 5 Enter the amount of storage space (in GiBs) to make available for the tier. 6 Schedule when the optimization is to occur.
3PAR System Reporter User’s Guide System Reporter 2.8 9.3.8 Removing an Adaptive Optimization Configuration To remove an Adaptive Optimization configuration: 1 From the Adaptive Optimization Configuration window, click Remove Adaptive Optimization. The Remove Adaptive Optimization Configuration window appears. 2 Choose the configuration to remove from the pull-down menu based on tiers that are defined. 3 When done, click Submit Query.
System Reporter 2.8 3PAR System Reporter User’s Guide 9.4 Adaptive Optimization Reports System Reporter provides three types of Adaptive Optimization reports as follows: ■ ■ Region IO Density -- Show the I/O access rate and distribution of data for each tier. VV Tiers -- Shows the distribution of space in each VV among the tiers in absolute terms and also as a percentage. ■ Space Moved -- Shows the space moved over a selected time interval.
3PAR System Reporter User’s Guide System Reporter 2.8 Figure 9-3. Region IO Density with Adaptive Optimization You can see from the chart on the left that most of the space is used by tier 2 (blue) for regions that have a very small access rate. You can also see from the chart on the right that most of the IO accesses are handled by the regions in tier 0 (red) even though the chart on the left shows that these regions occupy very little space.
System Reporter 2.8 3PAR System Reporter User’s Guide Figure 9-4. Region IO Density without Adaptive Optimization As with Figure 9-3 on page 9.14, you can see that much of the space is used for regions with very few IO accesses and most of the IO accesses are handled by a very small number of regions. Adaptive Optimization would work very well in this situation since the busiest regions would be moved to the fastest tier and the most idle regions would be moved to the slowest tier.
3PAR System Reporter User’s Guide System Reporter 2.8 9.4.2 VV Tiers Report The VV Tiers report shows the distribution of space in each VV among the tiers in an Adaptive Optimization configuration, in absolute terms and also as a percentage (Figure 9-5). Figure 9-5. VV Tiers Report 9.
System Reporter 2.8 3PAR System Reporter User’s Guide 9.4.3 Adaptive Optimization Space Moved Report The Space Moved report shows the space moved over a selected time interval for each Adaptive Optimization configuration (Figure 9-6). Figure 9-6. Space Moved Report The space moved between tiers represents a performance overhead for Adaptive Optimization since it takes system resources and disk bandwidth to move data between tiers.
3PAR System Reporter User’s Guide System Reporter 2.8 9.5 The showvvcpg CLI extension Adaptive Optimization may move regions of a VV into different CPGs. In order to more easily see how much of each VV is in each tier, the CD for System Reporter 2.8 includes a CLI script file, showvvcpg.tcl, that adds a new CLI command when it is sourced from the CLI. Once you start the CLI and connect to the InServ array, you can source the showvvcpg.tcl: cli% source showvvcpg.
System Reporter 2.
3PAR System Reporter User’s Guide 9.20 The showvvcpg CLI extension System Reporter 2.
System Reporter 2.8 3PAR System Reporter User’s Guide 10 Database Schema This chapter documents the 3PAR System Reporter database schema. 10.1 Using The Database Schema The description of the database schema is provided as a convenience to those wishing to query the database directly instead of using the web queries described in Chapter 8, Web Queries.
3PAR System Reporter User’s Guide System Reporter 2.8 10.2 Table Versions and Naming Conventions All tables are versioned and their version number appears at the end of the table names. Administrative tables contain only the base name and version number. For example policy_1 is the policy table and it is version 1. The sample data tables and the inventory tables include the base name, sampling resolution and the version number.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.3.2 The sampleinserv Table The sampleinserv_4 table contains a row for each of InServ systems that the System Reporter must sample. Table 10-2. sampleinserv_4 Table Column Type Comment name VARCHAR(64) IP address of the InServ system to NOT NULL sample INTEGER NOT Determines whether CLI connections to the NULL InServ will use SSL. usessl 0 - Do not use SSL 1 - Use SSL cliport INTEGER NOT Currently unused.
3PAR System Reporter User’s Guide System Reporter 2.8 10.3.3 The system Table The system_3 table contains a row for each InServ system that has been sampled. A single physical InServ may have multiple entries in this table because any changes in the columns for that system will result in a new row in the table. Table 10-3. system_3 Table Column Type Comment uniq_id INTEGER PRIMARY A unique identifier for the InServ system KEY instance.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.3.4 The alertconfig Table The alertconfig_2 table contains a row for each alert configuration rule. Table 10-4. alertconfig_2 Table Column Type Comment alertid INTEGER PRIMARY A unique identifier for each rule. KEY (AUTO_INCREMENT) data_table VARCHAR(32) NOT The data table on which the rule operates.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-4. alertconfig_2 Table Column Type Comment metric VARCHAR(32) NOT The metric that is calculated. The NULL supported values depend on the data_table value. direction VARCHAR(32) NOT How the metric is compared against the NULL limit_val. Currently this should be either > (greater than) or < (less than). limit_val limit_count DOUBLE PRECISION The calculated metric is compared based NOT NULL on direction against limit_val.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.3.5 The scheduled_report Table The scheduled_report_1 table contains a row for each scheduled report and defines where the report should be stored, when it should be run and parameters used to generate the report. Table 10-5. scheduled_report_1 Table Column Type Comment rpt_id INTEGER PRIMARY A unique identifier for each scheduled KEY report.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-5. scheduled_report_1 Table Column Type Comment rpt_createtime VARCHAR(64) NOT The time when this scheduled report was NULL created. INTEGER NOT NULL The number of days for which created rpt_retentiondays reports should be kept. Reports that are older are automatically deleted. 10.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.3.6 The scheduled_report_log Table The scheduled_report_log_1 table is used to keep track of when each scheduled report has run. Table 10-6. scheduled_report_log_1 Table Column Type Comment rpt_id INTEGER PRIMARY A unique identifier for each scheduled KEY report. (AUTO_INCREMENT) rpt_run_start_time VARCHAR(64) NOT The time the report was started. NULL rpt_run_end_time VARCHAR(64) NOT The time the report finished NULL executing.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-7. adprovconfig_1 Table Column Type Comment t0_cpg_name VARCHAR(32) NOT Tier 0 CPG name. If there is no tier 0, this NULL should be the empty string. VARCHAR(32) NOT Tier 1 CPG name. If there is no tier 1, this NULL should be the empty string. VARCHAR(32) NOT Tier 2 CPG name. If there is no tier 2, this NULL should be the empty string.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.3.8 The adprov_log Table The adprov_log_1 table is used to keep track of when each adaptive optimization configuration has been executed. Table 10-8. adprov_log_1 Table Column Type Comment adprovid INTEGER PRIMARY A unique identifier for each adaptive KEY optimization configuration. (AUTO_INCREMENT) start_tsecs INTEGER NOT NULL Time in secs when the adaptive optimization configuration was started.
3PAR System Reporter User’s Guide System Reporter 2.8 10.3.9 The ldrgmoves Table The ldrgmoves_1 table is used to keep track of the LD region moves generated for each adaptive optimization configuration that has been executed. Table 10-9. ldrgmoves_1 Table Column Type Comment sched_tsecs INTEGER NOT NULL Time in secs when the LD region move was scheduled. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-9. ldrgmoves_1 Table Column Type Comment dst_tier INTEGER NOT NULL Specifies the destination tier. dst_cpgname VARCHAR(32) NOT Specifies the destination CPG name. NULL move_reason VARCHAR(32) NOT The reason for the move, can be one of NULL the following: ■ busy_space - Busy region moved to faster tier because of lack of space in source tier. ■ busiest - Busiest region moved to faster tier since it met movement criteria.
3PAR System Reporter User’s Guide System Reporter 2.8 10.3.10 The recentsample Table The recentsample_1 table contains a row for each sample resolution containing the time of the most recent sample for that resolution. Beginning with the 2.4.1 release System Reporter inserts data from each InServ system into the database separately. Consequently, a given data table at a specific time may contain data from only some of the systems since the remaining systems’ data may not have been inserted yet.
System Reporter 2.8 3PAR System Reporter User’s Guide indexes on the data tables. To improve the efficiency of these queries, a separate set of inventory tables is maintained, one for each sample data table. The inventory tables contain a row for each distinct object in the corresponding sample data table. When the sampler inserts new samples into a table, or removes older samples from a table, it also updates the corresponding inventory table. 10.4.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-11. pdspace__3 Table Column Type Comment disktype VARCHAR(32) NOT The disk type. Currently, the disk types NULL are FC - Fibre channel drive. NL - Nearline drive. diskspeed INTEGER NOT The approximate disk speed in K RPM NULL state VARCHAR(32) NOT The state of the PD. NULL wwn CHAR(16) NOT The WWN of the PD.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-11. pdspace__3 Table Column Type Comment SPR_USED_FAIL INTEGER NOT Number of spare chunklets that were NULL used in LDs but have failed. INTEGER NOT Number of spare unused chunklets that NULL have been initialized. These are free for SRP_AVAIL_CLEAN use in new LDs. SPR_AVAIL_DRTY INTEGER NOT Number of spare unused chunklets that NULL have not yet been initialized.
3PAR System Reporter User’s Guide System Reporter 2.8 10.4.2 The pdspaceinv Table The pdspaceinv__2 table holds the inventory for the pdspace__3 table. Table 10-12. pdspaceinv__21Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs of the most recent sample for the PD in the corresponding data table. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.3 The ldspace Table The ldspace__2 table holds logical disk (LD) space data samples. Table 10-13. ldspace__2 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the InServ system instance refers to the uniq_id for the InServ system instance in the system_3 table.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-13. ldspace__2 Table Column Type Comment rawsizemb INTEGER NOT NULL Raw size of the LD in MB. sizemb INTEGER NOT NULL Size of the LD in MB. usedmb INTEGER NOT NULL Used MB in the lD. cpg_name VARCHAR(32) NOT NULL The name of the CPG that the LD belongs to. If the LD does not belong to a CPG the name is “-”. ld_use VARCHAR(32) NOT NULL Describes what the LD is used for.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.4 The ldspaceinv Table The ldspaceinv__2 table holds the inventory for the ldspace__2 table. Table 10-14. ldspaceinv__2 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the InServ system instance refers to the uniq_id for the InServ system instance in the system_3 table.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-14. ldspaceinv__2 Table Column Type Comment cpg_name VARCHAR(32) NOT NULL The name of the CPG that the LD belongs to. If the LD does not belong to a CPG the name is “-”. ld_use VARCHAR(32) NOT NULL Describes what the LD is used for. The possible values are described in Table 5-22 on page 5.39. 10.4.5 The vvspace Table The vvspace__3 table holds virtual volume (VV) space data samples. Table 10-15.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-15. vvspace__3 Table Column Type Comment wwn CHAR(16) NOT NULL The WWN of the VV. snp_cpg_name VARCHAR(32) NOT NULL The name of the CPG, if any, that is associated with the VV’s snapshot space. If the VV snapshot space is not associated with a CPG, this column is “-”. usr_cpg_name VARCHAR(32) NOT NULL The name of the CPG, if any, that is associated with the VV’s user space.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-15. vvspace__3 Table Column Type Comment adm_rsvd_mb DOUBLE PRECISION NOT Snapshot admin space reserved for NULL the VV in MB. DOUBLE PRECISION NOT Raw (physical space including RAID NULL overhead) snapshot admin space adm_rawrsvd_mb reserved for the VV in MB. adm_used_mb adm_zn DOUBLE PRECISION NOT Snapshot admin space used by the VV NULL in MB. DOUBLE PRECISION NOT Admin zones in the VV.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-15. vvspace__3 Table Column Type Comment usr_rawrsvd_mb DOUBLE PRECISION NOT Raw (physical space including RAID NULL overhead) user space reserved for the VV in MB. usr_used_mb DOUBLE PRECISION NOT User space used by the VV in MB. NULL usr_zn DOUBLE PRECISION NOT User zones in the VV. NULL usr_free_zn DOUBLE PRECISION NOT Free user zones in the VV. NULL 10.4.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-16. vvspaceinv__3 Table Column Type Comment bsid INTEGER NOT NULL The ID of the base VV for the VV. vv_name VARCHAR(32) NOT NULL The VV name. wwn CHAR(16) NOT NULL The WWN of the VV. snp_cpg_name VARCHAR(32) NOT NULL The name of the CPG, if any, that is associated with the VV’s snapshot space. If the VV snapshot space is not associated with a CPG, this column is “-”.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.7 The cpgspace Table The cpgspace__1 table holds Common Provisioning Group (CPG) space data samples. Table 10-17. cpgspace__1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the InServ system instance refers to the uniq_id for the InServ system instance in the system_3 table.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-17. cpgspace__1 Table Column Type Comment snp_total_mb DOUBLE PRECISION NOT The total snapshot LD space in the NULL CPG in MB. DOUBLE PRECISION NOT The total raw (including RAID NULL overhead) snapshot space in the CPG snp_rawtotal_mb in MB. snp_used_mb snp_rawused_mb DOUBLE PRECISION NOT The used snapshot LD space in the NULL CPG in MB.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.8 The cpgspaceinv Table The cpgspaceinv__1 table holds the inventory for the cpgspace_1 table. Table 10-18. cpgspaceinv__1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the InServ system instance refers to the uniq_id for the InServ system instance in the system_3 table.
3PAR System Reporter User’s Guide System Reporter 2.8 10.4.9 Common Performance Table Columns The statport, statvlun, statld and statpd tables all have a common set of columns for the performance data. These columns are described in Table 10-19. Table 10-19. Common Performance Columns Column Type Comment begin DOUBLE PRECISION NOT Timestamp value indicating when the NULL counting started (typically when the system was rebooted or the device was created).
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-19. Common Performance Columns Column Type Comment d_qlen DOUBLE PRECISION NOT Difference between qlen value from last NULL sample for the same object. DOUBLE PRECISION NOT Time in microsecs that the device has been NULL busy. DOUBLE PRECISION NOT Difference between busy value from last NULL sample for the same object. DOUBLE PRECISION NOT Total number of reads since the object was NULL first created or restarted.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-19. Common Performance Columns Column Type Comment d_rticks DOUBLE PRECISION NOT Difference between rticks value from last NULL sample for the same object. DOUBLE PRECISION NOT Total number of writes since the object was NULL first created or restarted DOUBLE PRECISION NOT Difference between wcount value from last NULL sample for the same object.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-19. Common Performance Columns Column Type Comment d_rhist0 DOUBLE PRECISION NOT Difference between rhist0 value from last NULL sample for the same object. ... ... ... rhist31 DOUBLE PRECISION NOT Number of reads in service time bucket NULL number 31. DOUBLE PRECISION NOT Difference between rhist31 value from last NULL sample for same object. DOUBLE PRECISION NOT Number of writes in service time bucket NULL number 0.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-19. Common Performance Columns Column Type Comment d_rsize15 DOUBLE PRECISION NOT Difference between rsize15 value from last NULL sample for same object. DOUBLE PRECISION NOT Number of writes in IO size bucket number NULL 0 (512 bytes). DOUBLE PRECISION NOT Difference between wsize0 value from last NULL sample for the same object. ... ... ...
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.9.1 Calculating Common Performance Metrics Table 10-20 shows SQL expressions that can be used to calculate various performance metrics from the common performance columns for any sample row. Table 10-20. Common Performance Metrics for a Sample Row Metric SQL Expression Read IOPs/s CASE WHEN d_now > 0 THEN d_rcount * 1000000.0/d_now ELSE 0 END Write IOPs/s CASE WHEN d_now > 0 THEN d_wcount * 1000000.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-20. Common Performance Metrics for a Sample Row Metric SQL Expression Total IO Size CASE WHEN (d_rcount + d_wcount) > 0 THEN (d_rbytes + d_wbytes) / ((d_rcount + d_wcount) * 1000.0) ELSE 0 END (KBytes) Queue length CASE WHEN qlen > 0 THEN qlen ELSE 0 END The check for qlen > 0 is because qlen < 0 indicates that qlen is invalid for that sample. Busy% AVG(CASE WHEN ((d_now > 0) AND (d_busy < busy)) THEN (d_busy * 100.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.10 The statpd Table The statpd__3 table holds physical disk (PD) performance data samples. Table 10-21. statpd__3 Table Column Type Comment tsecs INTEGER NOT Sample time in secs. This is the Unix time NULL and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT A unique identifier for the InServ system NULL instance refers to the uniq_id for the InServ system instance in the system_3 table.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-21. statpd__3 Table Column Type Comment diskspeed INTEGER NOT The approximate disk speed in K RPM. NULL (common The rest of the columns are the common performance performance columns described in columns) Common Performance Table Columns on page 10.30). 10.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.11 The statpdinv Table The statpdinv__2 table holds inventory for the statpd__3 table. Table 10-22. statpdinv__2 Table Column Type Comment tsecs INTEGER NOT Sample time in secs. This is the Unix time NULL and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT A unique identifier for the InServ system NULL instance refers to the uniq_id for the InServ system instance in the system_3 table.
3PAR System Reporter User’s Guide System Reporter 2.8 10.4.12 The statld Table The statld__4 table holds logical disk (LD) performance data samples. Table 10-23. statld__4 Table Column Type Comment tsecs INTEGER NOT Sample time in secs. This is the Unix time NULL and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT A unique identifier for the InServ system NULL instance refers to the uniq_id for the InServ system instance in the system_3 table.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.13 The statldinv Table The statldinv__3 table holds the inventory for the statld__4 table . Table 10-24. statldinv__2 Table Column Type Comment tsecs INTEGER NOT Sample time in secs. This is the Unix time NULL and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT A unique identifier for the InServ system NULL instance refers to the uniq_id for the InServ system instance in the system_3 table.
3PAR System Reporter User’s Guide System Reporter 2.8 10.4.14 The statport Table The statport__2 table holds port performance data samples. Table 10-25. statport__2 Table Column Type Comment tsecs INTEGER NOT Sample time in secs. This is the Unix time NULL and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT A unique identifier for the InServ system NULL instance refers to the uniq_id for the InServ system instance in the system_3 table.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-25. statport__2 Table Column Type Comment porttype VARCHAR(32) NOT The port type. Currently, the port types NULL are: ■ disk - Fibre channel ports that disks are connected to. ■ host -.Fibre channel ports that hosts are connected to (directly or through a fabric). ■ rcip - Remote Copy IP ports. ■ rcfc - Remote Copy fibre channel ports. ■ iscsi - iSCSI host ports. ■ free - ports that are not connected.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-26. statportinv__1 Table Column Type Comment port_n INTEGER NOT The node that the port is connected to NULL (the “n” part of n:s:p). INTEGER NOT The PCI slot in the node that the port is NULL connected to (the “s” part of n:s:p). INTEGER NOT The port number in the PCI slot in the NULL node that the port is connected to (the port_s port_p “p” part of n:s:p). porttype VARCHAR(32) NOT The port type.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.16 The statvlun Table The statvlun__3 table holds VLUN performance data samples. Table 10-27. statvlun__3 Table Column Type Comment tsecs INTEGER NOT Sample time in secs. This is the Unix time NULL and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT A unique identifier for the InServ system NULL instance refers to the uniq_id for the InServ system instance in the system_3 table.
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-27. statvlun__3 Table Column Type Comment port_p INTEGER NOT The port number in the PCI slot in the NULL node that the port is connected to (the “p” part of n:s:p). (common The rest of the columns are the common performance performance columns described in columns) Common Performance Table Columns on page 10.30). 10.4.17 The statvluninv Table The statvluninv__2 table holds the inventory for statvlun__3 table.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-28. statvluninv__2 Table Column Type Comment host_name VARCHAR(32) NOT The host name. NULL lun INTEGER NOT The LUN number. NULL host_wwn port_n port_s port_p VARCHAR(128) The host WWN (world wide name) or NOT NULL iscsi name. INTEGER NOT The node that the port is connected to NULL (the “n” part of n:s:p). INTEGER NOT The PCI slot in the node that the port is NULL connected to (the “s” part of n:s:p).
3PAR System Reporter User’s Guide System Reporter 2.8 Table 10-29. statvvcmp__2 Table Column Type Comment dom_name VARCHAR(32) NOT NULL The domain name that the VV belongs to. If the VV is not assigned to a domain, this column contains the value “-”. vvid INTEGER NOT NULL The VV ID. vv_name VARCHAR(32) NOT NULL The VV name. rdhit DOUBLE PRECISION NOT The number of read cache hits for the VV. NULL d_rdhit rdmiss d_rdmiss wrhit d_wrhit wrmiss d_wrmiss 10.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.19 The statvvcmpinv Table The statvvcmpinv__2 table holds the inventory for the statvvcmp__2 table. Table 10-30. statvvcmpinv__2 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT.
3PAR System Reporter User’s Guide System Reporter 2.8 10.4.20 The statcpu Table The statcpu__1 table holds CPU performance data samples. Table 10-31. statcpu__1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the InServ system instance refers to the uniq_id for the InServ system instance in the system_3 table.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-31. statcpu__1 Table Column Type Comment cputicks DOUBLE PRECISION NOT The CPU tick count. NULL A single count for all CPUs on a node is maintained in CPU 0, all other CPUs on the node have 0 values for this column. d_cputicks intr DOUBLE PRECISION NOT Difference between cputicks value from NULL last sample for same CPU. DOUBLE PRECISION NOT The number of interrupts for the CPU.
3PAR System Reporter User’s Guide System Reporter 2.8 10.4.21 The statcpuinv Table The statcpuinv__1 table holds the inventory for the statcpu__1 table. Table 10-32. statcpuinv__1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the InServ system instance refers to the uniq_id for the InServ system instance in the system_3 table.
System Reporter 2.8 3PAR System Reporter User’s Guide Table 10-33. statlink__1 Table Column Type Comment node_to INTEGER NOT NULL The node number of the destination of the link. queue VARCHAR (32) NOT NULL The name of the Queue. begin DOUBLE PRECISION NOT Timestamp value indicating when the NULL counting started (typically when the system was rebooted or the device was created). Two count samples should only be compared if the begin value is the same for the two samples.
3PAR System Reporter User’s Guide System Reporter 2.8 10.4.23 The statlinkinv Table The statlinkinv__1 table holds the inventory for the statlink__1 table. Table 10-34. statlinkinv__1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.24 The statldrg Table The statldrg_hourly_1 table holds the LD region performance data. Only hourly samples are kept. Table 10-35. statldrg_hourly_1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT.
3PAR System Reporter User’s Guide System Reporter 2.8 10.4.25 The statldrg_timeinv Table The statldrg_timeinv_1 table holds the time inventory for the statldrg_hourly_1 table. Table 10-36. statldrg_timeinv_1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT.
System Reporter 2.8 3PAR System Reporter User’s Guide 10.4.26 The perf_timeinv Table The perf_timeinv__1 table holds the sample times for performance samples for each system. Table 10-37. perf_timeinv__1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT.
3PAR System Reporter User’s Guide 10.58 The Sample Data and Inventory Tables System Reporter 2.
System Reporter 2.8 3PAR System Reporter User’s Guide 11 Troubleshooting This chapter describes how to troubleshoot and solve common problems that may occur while setting up or using System Reporter. 11.1 Troubleshooting Overview The first step when troubleshooting System Reporter is to identify the component that is causing problems (see Figure 3-2 on page 3.9 for the structure of System Reporter). ■ If there are problems in sampling components see 11.
3PAR System Reporter User’s Guide System Reporter 2.8 11.2 Troubleshooting the Sampling Components The System Reporter sampling components include several processes. Most of these processes create log files that are the first things you should look at when troubleshooting. 11.2.1 Sampling Component Log Files In general, a sampling component process named creates a log file named .log.
System Reporter 2.8 3PAR System Reporter User’s Guide 11.2.2 Installation Configuration On Windows, you can see the parameters with which the sampler was installed by typing the following command in that directory (which should contain the winserv.exe file) as follows: # winserv.exe showconfig "3PAR System Reporter sampler" Configuration of 3PAR System Reporter sampler: -displayname 3PAR System Reporter sampler (managed by WinServ) -noninteractive -binary C:\Program Files\3PAR\System Reporter\winserv.
3PAR System Reporter User’s Guide System Reporter 2.8 11.2.3.1 Errors incurred by the inservsample process Errors incurred by the inservsample process are typically database errors including: ◆ Loss of network connectivity to the database server. ◆ Database server errors. One example when using MySQL as the database is if the max_allowed_packet parameter is not sufficiently large (see 3.8.2.3 Setting the max_allowed_packet parameter on page 3.
System Reporter 2.8 3PAR System Reporter User’s Guide 11.4 Troubleshooting the Web Server Components Errors generated by the Apache HTTP Server are logged in the errors.log file in the logs directory (default location on Windows is C:\Program Files\Apache Group\Apache2\logs and the default location on Linux is /var/log/httpd). 11.5 Troubleshooting the Excel Client This section contains troubleshooting information for the System Reporter Excel client.
3PAR System Reporter User’s Guide System Reporter 2.8 Figure 11-1. Microsoft Office Excel Internal Error If you experience a problem with a recovered copy of the workbook (Figure 11-2), try starting with a fresh copy of System Reporter workbook. Figure 11-2. Microsoft Excel Recovery Error 11.6 Extracting Data from the Database with sysbck Sometimes it is necessary to extract some of the data from the System Reporter database.
System Reporter 2.8 3PAR System Reporter User’s Guide NOTE: If necessary, when using sysbck to extract large amounts of data from a database, the contents may be saved in separate 2 Gb files. NOTE: The sysbck command is recommended when extracting a relatively small sampling of the database. The command creates a file with SQL statements to insert each row of extracted data into a database.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: The -inservname parameter specifies the IP Name or Address that was assigned while configuring the InServ Systems. If you are not sure, consult Policy Settings -> InServ Systems to get this parameter. NOTE: The -dbouttype parameter should not be used when extracting data for analysis by 3PAR support. Depending on the -scripttype parameter, the sysbck command produces one or both of the following types of files: 1 The .
System Reporter 2.
3PAR System Reporter User’s Guide ■ System Reporter 2.
System Reporter 2.
3PAR System Reporter User’s Guide System Reporter 2.8 NOTE: When executing sysbck.exe from any other directory on Windows, ensure that the PATH environment variable is set to the System Reporter root directory path (by default, this path is C:\Program Files\3par). 11.7 Dumping the Entire Database When you want to extract a large part of the database, it may be more efficient, both in time and disk space, to dump the entire database instead of using sysbck.
System Reporter 2.8 3PAR System Reporter User’s Guide NOTE: Ideally, when extracting data for 3PAR support from an SQLite database, use sysbck without the default dbouttype parameter. 11.7.2 Dumping the Entire MySQL Database To create a dump of a MySQL database use the mysqldump program as follows # mysqldump --host=hostname --user=username --password=passwd --opt dbname > dbname.sql This creates a text file called dbname.
3PAR System Reporter User’s Guide 11.14 Dumping the Entire Database System Reporter 2.
3PAR System Reporter User’s Guide Index 3PAR System Reporter User’s Guide 4.4 3PAR System Reporter.xls 3.33 3par-policy subdirectory 7.23 3par-rpts subdirectory 7.23 A Adaptive Optimization 9.1 troubleshooting 11.4 adding a system to the list of systems to be sampled 7.6 Administrator’s Guide 1.2, 3.1 advisories, conventions 1.4 Alert Rules 7.9 alertconfig table 10.5 alllabels, web query option 8.15 Apache HTTP Server cgi-bin directory 7.23 config.pl files 7.23 Directory directives 3.34 httpd.conf file 3.
3PAR System Reporter User’s Guide daily database table 8.5 daily samples 7.3 data tables 5.6 database adding or removing storage servers 7.1 length for retaining samples 7.3 sampling policies 3.35, 7.1 troubleshooting 11.6 database sampling policies hi-res samples 7.2 Decision Support (DSS)/OLAP 3.18 deinstallation 3.1 DHCP-assigned address changing 3.1 dialog elements 1.4 Directory directives (Apache HTTP Server) 3.34 documentation, related 1.2 E endtsecs, web query option 8.17 Excel client 3.
3PAR System Reporter User’s Guide O Operator’s Guide 1.2 Oracle 3.15 Order By 5.28 orderby, web query option 8.21 P PD Performance Reports 2.4, 5.7, 6.13 PD Space Reports 2.4, 5.6, 6.6 pd_perf_group, report option value 8.48 pd_perf_time, report option value 8.47 pd_space_group, report option value 8.45 pd_space_time, report option value 8.45 pd_svt_hist, report option value 8.48 pd_svt_histvstime, report option value 8.49 pdspace table 10.15 pdspaceinv table 10.18 pdspaceunit, web query option 8.
3PAR System Reporter User’s Guide Space Moved Report 9.17 spare chunklets 8.30 special considerations 3.14 SQLite 3.14 Stacked Area chart (example of) 5.48 Stacked Bars chart (example of) 5.47 Stacked Vert Bars chart (example of) 5.47 statcpu table 10.50 statcpuinv table 10.52 statld table 10.40 statldinv table 10.41 statpd table 10.37 statpdinv table 10.39 statport table 10.42 statportinv table 10.43 statvlun table 10.45 statvluninv table 10.46 statvvcmp table 10.47 statvvcmpinv table 10.
3PAR System Reporter User’s Guide W Web browser editing sampling policies 7.1 requirements 4.1 using System Reporter with 4.1 Web Queries 8.1 Web server 3.1 installing 3.13 Windows® Server 2003 3.1 Windows® Server 2008 3.1 Index IX.
3PAR System Reporter User’s Guide IX.
3PAR System Reporter User’s Guide Revision History Release level Revision summary 320-1330-01 First release of this manual to support the release of 3PAR System August 2005 Reporter, external beta release. 320-1330-02 Second release of this manual to support external beta release 1.1. September 2005 Changes include: ■ SQLite database compaction is no longer necessary.
3PAR System Reporter User’s Guide 320-1330-03 Third release of this manual to support release 2.0. January 2006 Changes include: ■ Installation flowchart added to Chapter 3, Installation, Configuration, Update, and Removal. ■ The CLI password directory is created during installation by the Installer. ■ Port performance and virtual volume cache performance tables added to Web and Excel client interfaces. Also available as performance Web queries.
3PAR System Reporter User’s Guide 320-1330-05 Fifth release of this manual to support release 2.2. November 2006 Changes include: ■ Changes in installation to support remote MySQL server, specification of full CLI path. ■ Vertical bar charts and stacked vertical bar charts added. ■ Added controls to specify chart legend positions, X and Y axis pixels. ■ Queue length charts added for some reports. ■ Updated various figures to show version 2.2 screens.
3PAR System Reporter User’s Guide 320-1330-07 Seventh release of this manual to support release 2.4. December 2007 Changes include: ■ Add support for Oracle database ■ Add statlink tables and add support for link performance reports. ■ For statport, statvlun, statld and statpd add IO Size histogram and busy time data and increment the table version numbers. Added corresponding reports to the web and Excel clients.
3PAR System Reporter User’s Guide 320-1330-09 Ninth release of the manual to support release 2.5. August 2008 Changes include: ■ Add support for installing System Reporter on Red Hat Enterprise Linux 5 MU1and Microsoft Windows Server 2008. ■ Dropped support for MySQL version 4.x. ■ Dropped support for Excel 2000, added support for Excel 2007. ■ On Windows, the installer now detects an existing installation and offers an option to upgrade keeping the existing settings.
3PAR System Reporter User’s Guide 320-200222 Rev A First version of this guide for System Reporter 2.7, replaces previous April 2010 version 320-1330-10. Improvements and additions for release 2.7 include: ■ Added an optionally licensed Adaptive Provisioning component that analyzes and optimizes storage utilization. ■ Added the ability to configure scheduled reports with predefined parameters, execution times, destination directories and retention periods.
3PAR System Reporter User’s Guide 320-200257 Rev A First version of this guide for System Reporter 2.8, replaces previous November 2010 version 320-200222 Rev A. Improvements and additions for release of the user guide include: ■ New Chapter 2 “Overview” describing features and capabilities. ■ Reorganized Chapter 3 “Installation” to place all installation material in one chapter. ■ Reorganized Chapter 4 “Getting Started” describing how to get up an running with the web interface and Excel client.
3PAR System Reporter User’s Guide RH.
