Hp 3PAR System Reporter Software Instrukcja Użytkownika Strona 1

Przeglądaj online lub pobierz Instrukcja Użytkownika dla Przechowywanie Hp 3PAR System Reporter Software. HP 3PAR System Reporter Software User Manual Instrukcja obsługi

  • Pobierz
  • Dodaj do moich podręczników
  • Drukuj

Podsumowanie treści

Strona 1 - User’s Guide

3PAR® System Reporter 2.8User’s Guide3PAR, Inc.4209 Technology DriveFremont, CA 94538 USAPart No. 320-200257 Rev ANovember 2010

Strona 2

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

Strona 3 - Oractcl Copyright and License

5.8Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.1.3 Select SystemsThis is a filtered multi-selection control (see 4

Strona 4

5.9Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.1.4 Select DomainsThis is a filtered multi-selection control (see 4

Strona 5

5.10Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.2 Generating the ReportWhen you click on the Build Report Menu but

Strona 6

5.11Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideFor most reports, the controls in the report menu are divided into fou

Strona 7 - PREAMBLE

5.12Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.8Once the report is generated, query results appear in one or more char

Strona 8

5.13Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 5-5. Query ResultsIf necessary, use the scrollbox on the right

Strona 9

5.14Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.3 Controls Available by ReportTable 5-5 lists the set of controls

Strona 10 - NO WARRANTY

5.15Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.4.3 Compare T T T T T T5.3.4.4 Select Peak T T T T5.3.4.5 Group By

Strona 11 - Table of Contents

5.16Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.6.4 Select Disk Types Y Y Y5.3.6.5 Select Disk Speed Y Y5.3.6.6 In

Strona 12

5.17Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideDetailed descriptions for each of the controls described in this table

Strona 13 - 4 Getting Started

xiTable of ContentsSystem Reporter 2.8 3PAR System Reporter User’s GuideTable of Contents1 Introduction1.1 Audience 1.11.2 User Interfaces 1.11.3 Re

Strona 14

5.18Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.4.1 Standard Report TypesThe following standard report types are a

Strona 15

5.19Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideFor each report type, controls in the report menu that do not apply to

Strona 16 - 6 Interpreting Report Metrics

5.20Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.8Figure 5-6. Versus Time Report ExampleIn Figure 5-6. Versus Time Repo

Strona 17 - 8Web Queries

5.21Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 5-7. Versus Time with Compare=System Report Example If you wan

Strona 18

5.22Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.8Figure 5-8. Group By System:Host At Time Report ExampleThe At Time re

Strona 19

5.23Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 5-9. Histogram Versus Time Report ExampleThe Histogram Versus

Strona 20 - 9 Using Adaptive Optimization

5.24Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.8Figure 5-10. Histogram At Time Report ExampleThe Histogram At Time re

Strona 21 - 10 Database Schema

5.25Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.4.3 CompareThis control is only valid for some Versus Time perform

Strona 22 - 11 Troubleshooting

5.26Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.8Table 5-7. Group By Option PurposeSystem Group by InServ System.Domai

Strona 23 - RH Revision History

5.27Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideSnpCPG Group by the Usr CPG to which the VV belongs.PortNode Group by

Strona 24

xiiTable of Contents 3PAR System Reporter User’s Guide System Reporter 2.83 Installation, Configuration, Update, and Removal3.1 Before You Begin 3.13

Strona 25 - Introduction

5.28Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.4.6 Order ByThis control is only valid for At Time reports and spe

Strona 26 - 1.3 Related Documentation

5.29Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideLDSize Order by LD SIze.LDFreeSize Order by free space in LD.LDRawSize

Strona 27 - 1.4 Organization

5.30Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.4.7 Low BucketThis control is only valid for Histogram Versus Time

Strona 28 - 1.6 Advisories

5.31Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.5 Time Selection5.3.5.1 Reload After (mins)If you enter a number i

Strona 29 - Overview and Features

5.32Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.5.4 CountThis control is only valid for Histogram At Time or Histo

Strona 30

5.33Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.6 Object SelectionThe type of object that can be selected and the

Strona 31

5.34Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.6.3 Select Cage IDsThis is a filtered multi-selection control (see

Strona 32 - Table 2-1. Available Reports

5.35Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.6.5 Select Disk SpeedThis control is available for PD Performance

Strona 33

5.36Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.6.7 Select Usr CPGsThis is a filtered multi-selection control (see

Strona 34

5.37Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.6.8 Select Snp CPGsThis is a filtered multi-selection control (see

Strona 35 - 2.7 Generating Email Alerts

xiiiTable of Contents System Reporter 2.8 3PAR System Reporter User’s Guide3.12 Removing the System Reporter Components 3.363.12.1 Removing the Syste

Strona 36

5.38Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.6.10 Select LDsThis is a filtered multi-selection control (see 4.4

Strona 37 - Update, and Removal

5.39Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.6.12 Select LD UsageThis option is only available for the LD Space

Strona 38 - System Reporter CD Contents

5.40Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.6.13 Select VVsThis is a filtered multi-selection control (see 4.4

Strona 39 - 0.9.8k.msi

5.41Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.6.14 Select Prov TypesThis control is available for VV Space repor

Strona 40 - 3.3 System Requirements

5.42Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.6.15 Select VV TypesThis control is available for VV Space reports

Strona 41 - System Requirements

5.43Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.6.17 Select Port TypesThis control is only available for Port Perf

Strona 42

5.44Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.6.19 Select NodesThis control is available for CPU and Link Perfor

Strona 43

5.45Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.6.21 Select QueuesThis control is available for Link Performance r

Strona 44

5.46Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.8Figure 5-11. Example of a Table5.3.7.2 Chart TypesStacked charts stac

Strona 45 - System Reporter Components

5.47Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide Stacked BarsFigure 5-12. Chart Using Stacked Bars Stacked Vert Bar

Strona 46

xivTable of Contents 3PAR System Reporter User’s Guide System Reporter 2.85.3 Creating Custom Reports 5.45.3.1 Building the Report Menu 5.55.3.1.1 S

Strona 47

5.48Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.8 Stacked AreaFigure 5-14. Chart Using Stacked Areas LinesFigure 5-1

Strona 48

5.49Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide BarsFigure 5-16. Chart Using Bars Vert BarsFigure 5-17. Chart Usi

Strona 49 - Installing the Web Server

5.50Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.7.3 Chart X PixelsYou can explicitly specify the length in pixels

Strona 50 - 3.8.1.1 SQLite

5.51Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.7.7 Time FormatThis control selects how time values are labelled a

Strona 51 - 3.8.1.3 Oracle

5.52Working with Excel Charts3PAR System Reporter User’s Guide System Reporter 2.85.4 Working with Excel ChartsWhen working with reports created with

Strona 52

5.53Working with Excel ChartsSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 5-18. Change Chart Type Menu for the Excel Client4 Choose th

Strona 53

5.54Working with Excel Charts3PAR System Reporter User’s Guide System Reporter 2.8Using another option provided through Excel, you can have the data r

Strona 54

5.55Working with Excel ChartsSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 5-20. External Data Range Properties Dialog Box3 Click OK.5.

Strona 55

5.56Working with Excel Charts3PAR System Reporter User’s Guide System Reporter 2.82 On the shortcut menu, click Location (for Excel 2003) or Move Char

Strona 56

5.57Working with Excel ChartsSystem Reporter 2.8 3PAR System Reporter User’s Guide1 Click on the appropriate tab at the bottom of the screen to access

Strona 57

xvTable of Contents System Reporter 2.8 3PAR System Reporter User’s Guide5.3.6.9 Select CPGs 5.375.3.6.10 Select LDs 5.385.3.6.11 Select RAID Types

Strona 58

5.58Working with Excel Charts3PAR System Reporter User’s Guide System Reporter 2.8The Dly PDSpace (1) sheet is created to hold the data represented in

Strona 59

5.59Working with Excel ChartsSystem Reporter 2.8 3PAR System Reporter User’s GuideFor Excel 2003:To create a custom chart with the Percent spare used

Strona 60

5.60Working with Excel Charts3PAR System Reporter User’s Guide System Reporter 2.8If you want to move the Chart to a new sheet, right click on the cha

Strona 61

System Reporter 2.8 3PAR System Reporter User’s Guide6.1Interpreting Report Metrics6Interpreting Report MetricsThis chapter describes the metrics that

Strona 62

6.2Summary Report3PAR System Reporter User’s Guide System Reporter 2.8Table 6-1 describes all of the metrics available for Summary Reports. Only some

Strona 63

6.3Summary ReportSystem Reporter 2.8 3PAR System Reporter User’s GuideFC Host Ports Number of host ports.iSCSI Host Ports Number of iSCSI host ports.R

Strona 64

6.4Summary Report3PAR System Reporter User’s Guide System Reporter 2.8Host Total Svct ms Total (reads + writes) average service time in millisec to ho

Strona 65

6.5Summary ReportSystem Reporter 2.8 3PAR System Reporter User’s GuideCPVVs Virtual Size GiB Virtual size in GiBs for CPVVs.Full Virtual Size GiB Tota

Strona 66

6.6Space Reports3PAR System Reporter User’s Guide System Reporter 2.86.2 Space ReportsThis section describes the metrics that are shown for the Physic

Strona 67 - 3.9.1 Adding InServ Systems

6.7Space ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideFor charts, scroll down to locate the color key listing the chunklet types repres

Strona 68 - Reporter\log\sampleloop.log)

xviTable of Contents 3PAR System Reporter User’s Guide System Reporter 2.86 Interpreting Report Metrics6.1 Summary Report 6.16.2 Space Reports 6.66.

Strona 69 - 3PAR System Reporter.xls

6.8Space Reports3PAR System Reporter User’s Guide System Reporter 2.86.2.3 VV Space ReportsTable 6-4 describes the metrics that are shown for VV (Virt

Strona 70

6.9Space ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideUser Free Space User Rsvd Space that is not actually used. This is zero for Virtu

Strona 71

6.10Space Reports3PAR System Reporter User’s Guide System Reporter 2.8Admin Vcopy SpaceAdmin Space used by Virtual Copy (snapshot) VVs only. This is z

Strona 72

6.11Performance ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide6.3 Performance ReportsThis section describes the metrics for reports that

Strona 73

6.12Performance Reports3PAR System Reporter User’s Guide System Reporter 2.8For Histogram At Time and Histogram Versus Time report types, the PD, Port

Strona 74

6.13Performance ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide6.3.2 VV Cache Performance ReportsTable 6-6 describes the metrics that are

Strona 75 - Getting Started

6.14Performance Reports3PAR System Reporter User’s Guide System Reporter 2.86.3.3 Node Cache Performance ReportsTable 6-7 describes the metrics that a

Strona 76

6.15Performance ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide6.3.4 CPU Performance ReportsTable 6-8 describes the metrics that are show

Strona 77

6.16Adaptive Optimization Reports3PAR System Reporter User’s Guide System Reporter 2.86.3.5 Link Performance ReportsTable 6-9 describes the metrics th

Strona 78 - 4.3 Getting Help

System Reporter 2.8 3PAR System Reporter User’s Guide7.1Configuring the System Reporter Policy Settings7Configuring the System Reporter Policy Setting

Strona 79 - 4.4.1 Simple Selection List

xviiTable of Contents System Reporter 2.8 3PAR System Reporter User’s Guide7.4.4.3 System 7.137.4.4.4 Metric 7.137.4.4.5 Direction 7.167.4.4.6 Limi

Strona 80

7.2Configuring Sampling Policies3PAR System Reporter User’s Guide System Reporter 2.8The following options are available from the menu tabs: Sampling

Strona 81

7.3Configuring Sampling PoliciesSystem Reporter 2.8 3PAR System Reporter User’s Guide7.2.1 Compacting DatabasesWhen some sampling policies are changed

Strona 82

7.4Configuring Sampling Policies3PAR System Reporter User’s Guide System Reporter 2.8If the policy value is set to now the compaction is done once and

Strona 83

7.5Configuring Sampling PoliciesSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 7-1. Connection Dialog Box4 In the Sampling Policies scre

Strona 84

7.6Adding, Removing and Re-Configuring InServ Storage Systems3PAR System Reporter User’s Guide System Reporter 2.8Figure 7-2. Connection Dialog Box6

Strona 85

7.7Adding, Removing and Re-Configuring InServ Storage SystemsSystem Reporter 2.8 3PAR System Reporter User’s Guide To re-configure sampling parameter

Strona 86

7.8Adding, Removing and Re-Configuring InServ Storage Systems3PAR System Reporter User’s Guide System Reporter 2.87 Click OK to return to the Sampling

Strona 87

7.9Configuring Rules for Email AlertsSystem Reporter 2.8 3PAR System Reporter User’s Guide7.4 Configuring Rules for Email AlertsSystem Reporter can b

Strona 88

7.10Configuring Rules for Email Alerts3PAR System Reporter User’s Guide System Reporter 2.813 Enter the Condition Value to specify the minimum amount

Strona 89 - 4.6.2 Resetting the Workbook

7.11Configuring Rules for Email AlertsSystem Reporter 2.8 3PAR System Reporter User’s GuideThe 3PAR System Reporter Policies window appears.3 Choose t

Strona 90 - 4.8 Deleting Excel Sheets

xviiiTable of Contents 3PAR System Reporter User’s Guide System Reporter 2.88.4.10 graphlegpos 8.148.4.11 tableformat 8.148.4.12 alllabels 8.158.4.

Strona 91

7.12Configuring Rules for Email Alerts3PAR System Reporter User’s Guide System Reporter 2.87.4.4.2 ResolutionThe resolution of data table on which the

Strona 92

7.13Configuring Rules for Email AlertsSystem Reporter 2.8 3PAR System Reporter User’s Guide7.4.4.3 SystemIf System is specified, the alert rule is cal

Strona 93 - Accessing and Creating

7.14Configuring Rules for Email Alerts3PAR System Reporter User’s Guide System Reporter 2.8Table 7-4. MetricMetrics Description Data Tablesread_iops

Strona 94 - 5.1 Accessing Quick Reports

7.15Configuring Rules for Email AlertsSystem Reporter 2.8 3PAR System Reporter User’s Guidewrite_kbps Write KBytes/sec statport, statport_nodesum, sta

Strona 95 - Accessing Scheduled Reports

7.16Configuring Rules for Email Alerts3PAR System Reporter User’s Guide System Reporter 2.87.4.4.5 DirectionSpecifies whether the Metric should be les

Strona 96 - 5.3 Creating Custom Reports

7.17Configuring Rules for Email AlertsSystem Reporter 2.8 3PAR System Reporter User’s Guide7.4.4.7 Limit CountThe alert will only be generated if the

Strona 97

7.18Scheduling Reports3PAR System Reporter User’s Guide System Reporter 2.8The email shows that a single VLUN instance had an average total service ti

Strona 98 - 5.3.1.2 Report

7.19Scheduling ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideEach time the report runs, a new subdirectory is created for that instance

Strona 99

7.20Scheduling Reports3PAR System Reporter User’s Guide System Reporter 2.86 Specify the report name.7 Specify the report schedule. Hold the CTRL key

Strona 100 - 5.3.1.3 Select Systems

7.21Scheduling ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide7.5.3 Removing a Scheduled ReportTo remove a scheduled report:1 Point your

Strona 101 - 5.3.1.4 Select Domains

xixTable of Contents System Reporter 2.8 3PAR System Reporter User’s Guide8.4.42 selprovtype 8.438.5 Report Types 8.448.6 Summary Report 8.458.6.1

Strona 102 - 5.3.2 Generating the Report

7.22Configuring Adaptive Optimization3PAR System Reporter User’s Guide System Reporter 2.87.6 Configuring Adaptive OptimizationAn optionally licensed

Strona 103 - Creating Custom Reports

7.23Modifying the Apache HTTP Server Configuration FilesSystem Reporter 2.8 3PAR System Reporter User’s Guide7.8 Modifying the Apache HTTP Server Con

Strona 104

7.24Modifying the Apache HTTP Server Configuration Files3PAR System Reporter User’s Guide System Reporter 2.87 At the bottom of the file, alter the $d

Strona 105 - Figure 5-5. Query Results

System Reporter 2.8 3PAR System Reporter User’s Guide8.1Web Queries8Web QueriesThis chapter documents the queries that the 3PAR System Reporter interf

Strona 106

8.2Data Format Version Report3PAR System Reporter User’s Guide System Reporter 2.8The following example shows a query for Web server named localhost:

Strona 107

8.3Data Format Version ReportSystem Reporter 2.8 3PAR System Reporter User’s Guidewhere <server_name> is the name of your server. The following

Strona 108

8.4About Reports and Options3PAR System Reporter User’s Guide System Reporter 2.8The definitions of queries and the data they return given below are v

Strona 109 - 5.3.4 Report Selection

8.5Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s GuideSpecify one of the following:daily(Default). Specifies that results will be pull

Strona 110 - 5.3.4.1 Standard Report Types

8.6Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.2.1 values:Specify one of the following:none(Default) No comparison is perfo

Strona 111

8.7Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s GuideHostCompares selected hosts. This value is only available for the vlun_perf_time

Strona 112

Revision NoticeThis is the first release of this manual. A complete revision history is provided at the end of this document.ChangesThe material in th

Strona 113

xxTable of Contents 3PAR System Reporter User’s Guide System Reporter 2.88.8.20 cpu_perf_group 8.548.9 Adaptive Optimization Reports 8.558.9.1 regio

Strona 114

8.8Report Options3PAR System Reporter User’s Guide System Reporter 2.8DiskCompares selected disk magazine position. This value is only available for t

Strona 115

8.9Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s GuideinterruptsThe CPU interrupts per second.ctxtswsThe CPU context switches per seco

Strona 116 - Summary report

8.10Report Options3PAR System Reporter User’s Guide System Reporter 2.8pdspaceReturns values from the pdspace database tables.vvspaceReturns values fr

Strona 117 - 5.3.4.5 Group By

8.11Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.4.5 refreshUse the refresh option to have the web browser automatically reloa

Strona 118 - Table 5-7. Group By

8.12Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.6.2 example:The following example specifies that query results are to be di

Strona 119 - Option Purpose

8.13Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guidebars(Default). Specifies that bar charts will be used. See Figure 5-16 on page

Strona 120 - 5.3.4.6 Order By

8.14Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.9.1 value:Specify an integer number of pixels.8.4.9.2 example:The following

Strona 121 - Table 5-8. Order By

8.15Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.4.11.1 value:excelThis option causes the results in the left column of the ta

Strona 122 - 5.3.4.9 Sum End Buckets

8.16Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.13 timeformUse the timeform option to specify a time format (either relativ

Strona 123 - 5.3.5 Time Selection

8.17Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s GuideIf this option is not defined, for reports that require a time range, the earl

Strona 124 - 5.3.5.4 Count

xxiTable of Contents System Reporter 2.8 3PAR System Reporter User’s Guide9.3.2 Schedule 9.99.3.3 Measurement Hours 9.99.3.4 Adaptive Optimization M

Strona 125 - 5.3.6 Object Selection

8.18Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.15.1 value:<tsecs>If <tsecs> is non-negative it represents a po

Strona 126 - 5.3.6.4 Select Disk Types

8.19Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s GuideDomainGroup results by domain. HostGroup results by hosts. CPGGroup results by

Strona 127 - 5.3.6.6 Include PDs in States

8.20Report Options3PAR System Reporter User’s Guide System Reporter 2.8LDUsageGroup results by logical disk usage. See Table 5-22 on page 5.39 for a l

Strona 128 - 5.3.6.7 Select Usr CPGs

8.21Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s GuideThe following example specifies that results should be grouped by system, drive

Strona 129 - 5.3.6.9 Select CPGs

8.22Report Options3PAR System Reporter User’s Guide System Reporter 2.8SnpCPGOrder results by Common Provisioning Group (CPG) name for the Snap Space

Strona 130 - 5.3.6.11 Select RAID Types

8.23Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s GuideMagOrder results by magazine position within the drive cage (0 through 7).DiskO

Strona 131 - 5.3.6.12 Select LD Usage

8.24Report Options3PAR System Reporter User’s Guide System Reporter 2.8IdleOrder results by CPU idle percentage.IntrOrder results by CPU interrupts/se

Strona 132 - 5.3.6.13 Select VVs

8.25Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.4.17.2 example:The following example specifies that results should be ordered

Strona 133 - 5.3.6.14 Select Prov Types

8.26Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.19.1 values:Specify one of the following:MiB (2^20 bytes)(Default). Use meg

Strona 134 - 5.3.6.16 Select Ports (n:s:p)

8.27Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.4.20.1 values:Specify one of the following:Chunklets(Default). Use the chunkl

Strona 135 - 5.3.6.18 Select Hosts

xxiiTable of Contents 3PAR System Reporter User’s Guide System Reporter 2.810.4.4 The ldspaceinv Table 10.2110.4.5 The vvspace Table 10.2210.4.6 The

Strona 136 - 5.3.6.20 Select To Nodes

8.28Report Options3PAR System Reporter User’s Guide System Reporter 2.8GB (10^9 bytes)See ldspaceunit on page 8.25.GiB (2^30 bytes)(Default). See ldsp

Strona 137 - 5.3.7.1 Report Information

8.29Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.4.22.2 examples:The following example shows two ways to include cages regardl

Strona 138 - 5.3.7.2 Chart Types

8.30Report Options3PAR System Reporter User’s Guide System Reporter 2.8NRM_AVAIL_FAILInclude only normal available (unused) chunklets that are failed.

Strona 139 - Stacked Vert Bars

8.31Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.4.24 selcpgUse the selcpg option to select a common provisioning group (CPG).

Strona 140 - Stacked Area

8.32Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.27.1 value:Specify one or more of the following:--All Disk Types--(Default)

Strona 141 - Vert Bars

8.33Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide10This value allows you to include only 10K RPM disks.7This value allows you to

Strona 142 - 5.3.7.6 Legend Position

8.34Report Options3PAR System Reporter User’s Guide System Reporter 2.8The following example specifies including only VLUNs belonging to domain domain

Strona 143 - 5.3.7.8 Select Space Unit

8.35Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s GuideThe following example specifies including only VLUNs exported to host winhost1

Strona 144 - 5.4.1 Choosing a Chart Type

8.36Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.32.1 values:Specify one or more of the following:VIncludes only logical dis

Strona 145 - 5.4.2 Refreshing Charts

8.37Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide--All Nodes--(Default). Specifies that nodes are not to be excluded based on th

Strona 146 - Working with Excel Charts

xxiiiTable of Contents System Reporter 2.8 3PAR System Reporter User’s Guide11.2.2 Installation Configuration 11.311.2.3 InServ Sampling Errors 11.3

Strona 147 - 5.4.3 Retaining Charts

8.38Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.34.2 example:The following example shows two ways to specify that no ports

Strona 148

8.39Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.4.36 selpdstateUse the selpdstate option to select physical disks according t

Strona 149

8.40Report Options3PAR System Reporter User’s Guide System Reporter 2.8--All Port Types--(Default). All port types are selected. diskSpecify this valu

Strona 150 - =IF(N53>0,H53/N53*100,0)

8.41Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide1Specify this value to include RAID 1 logical disks.5Specify this value to incl

Strona 151

8.42Report Options3PAR System Reporter User’s Guide System Reporter 2.88.4.39.2 example:The following example shows two ways to specify that storage s

Strona 152

8.43Report OptionsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.4.41 selvvtypeUse the selvvtype option to specify virtual volumes according t

Strona 153 - Interpreting Report Metrics

8.44Report Types3PAR System Reporter User’s Guide System Reporter 2.8tpvvSelect thin provisioned VVs that have separate User and Snap spaces.tpsdSelec

Strona 154 - Summary Report

8.45Summary ReportSystem Reporter 2.8 3PAR System Reporter User’s Guide performance reports objects present reports8.6 Summary Report8.6.1 summarySh

Strona 155

8.46Space Reports3PAR System Reporter User’s Guide System Reporter 2.88.7.2.1 example:The following example shows the entire query string for a pd_spa

Strona 156

8.47Performance ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.7.5 vv_space_timePlots the virtual size as well as raw and LD space used

Strona 157

xxivTable of Contents 3PAR System Reporter User’s Guide System Reporter 2.8

Strona 158 - 6.2 Space Reports

8.48Performance Reports3PAR System Reporter User’s Guide System Reporter 2.8respectively, being aggregated over the other object types (e.g., aggregat

Strona 159 - 6.2.2 LD Space Reports

8.49Performance ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.8.4 pd_svt_histvstimePlots the service time histogram of all the physica

Strona 160 - 6.2.3 VV Space Reports

8.50Performance Reports3PAR System Reporter User’s Guide System Reporter 2.88.8.6.1 example:The following example shows the entire query string for a

Strona 161 - Space Reports

8.51Performance ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.8.9.1 example:The following example shows the entire query string for a

Strona 162

8.52Performance Reports3PAR System Reporter User’s Guide System Reporter 2.88.8.12.1 example:The following example shows the entire query string for a

Strona 163 - 6.3 Performance Reports

8.53Performance ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuidePlots the service time histogram of all the VLUNs (exports) in the selecte

Strona 164 - Performance Reports

8.54Performance Reports3PAR System Reporter User’s Guide System Reporter 2.88.8.18.1 example:The following example shows the entire query string for a

Strona 165

8.55Adaptive Optimization ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.9 Adaptive Optimization Reports8.9.1 regiodensityReturns a re

Strona 166

8.56Options Available by Report3PAR System Reporter User’s Guide System Reporter 2.88.9.3.1 vvtier exampleThe following example shows the entire query

Strona 167 - 6.3.4 CPU Performance Reports

8.57Options Available by ReportSystem Reporter 2.8 3PAR System Reporter User’s Guidegrpahlegpos Y Y Y Y Y Y Y Y Ytableformat Y Y Y Y Y Y Y Y Y Yalllab

Strona 168 - Adaptive Optimization Reports

System Reporter 2.8 3PAR System Reporter User’s Guide1.1Introduction1IntroductionThis guide provides the information you need to install and use 3PAR®

Strona 169 - Reporter Policy Settings

8.58Options Available by Report3PAR System Reporter User’s Guide System Reporter 2.8seldisktype M M M Mseldiskspeedselhost M Mselld M Msellduse M Msel

Strona 170 - Table 7-1. Sampling Policies

8.59Options Available by ReportSystem Reporter 2.8 3PAR System Reporter User’s GuideTable 8-2. Valid Options for Performance ReportsReport:Optionpd_p

Strona 171 - 7.2.1 Compacting Databases

8.60Options Available by Report3PAR System Reporter User’s Guide System Reporter 2.8histhbkt Y Y Y Yhistsum Y Y Y Ypdspaceunitldspaceunitvvspaceunitse

Strona 172 - Configuring Sampling Policies

8.61Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.11 Objects Present ReportsObjects present reports return the objects

Strona 173

8.62Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.8The objects_present report requires the category (see category on page

Strona 174

8.63Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 8-2. Using the tableformat=excel Optionusing tableformat=excel

Strona 175 - 7.3.1 Adding a Storage Server

8.64Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.8Table 8-3. Objects Present Report table valuesReport table valuesobje

Strona 176

8.65Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.11.1 objectpres= cageidReturns a list of drive cages.objects_present

Strona 177 - 7.4.1 Adding an Alert Rule

8.66Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.88.11.1.1 example:The following example shows the entire query string f

Strona 178 - 7.4.3 Removing an Alert Rule

8.67Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.11.2.1 example:The following example shows the entire query string f

Strona 179 - 7.4.4 Alert Rule Parameters

1.2Related Documentation3PAR System Reporter User’s Guide System Reporter 2.8Two user interfaces are offered as part of the InServ Storage Server: a W

Strona 180 - 7.4.4.2 Resolution

8.68Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.88.11.3.1 example:The following example shows the entire query string f

Strona 181 - 7.4.4.4 Metric

8.69Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.11.5 objectpres= domain_nameReturns a list of domain names.8.11.5.1

Strona 182 - Table 7-4. Metric

8.70Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.88.11.6.1 example:The following example shows the entire query string f

Strona 183

8.71Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.11.7.1 example:The following example shows the entire query string f

Strona 184 - 7.4.4.6 Limit Value

8.72Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.88.11.8.1 example:The following example shows the entire query string f

Strona 185 - 7.4.4.10 Recipient

8.73Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.11.9.1 example:The following example shows the entire query string f

Strona 186 - 7.5 Scheduling Reports

8.74Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.88.11.10.1 example:The following example shows the entire query string

Strona 187 - Scheduling Reports

8.75Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide8.11.11.1 example:The following example shows the entire query string

Strona 188

8.76Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.88.11.12.2 output:Returns a row for each virtual volume present over th

Strona 189

8.77Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide System: system name VV: virtual volume nameThe following is example

Strona 190 - 7.7 About File Permissions

1.3OrganizationSystem Reporter 2.8 3PAR System Reporter User’s Guide1.4 OrganizationThis guide is organized as follows: Chapter 1, Introduction (thi

Strona 191

8.78Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.88.11.15 sample_timesReturns valid times of database samples. 8.11.15.1

Strona 192

8.79Objects Present ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide

Strona 193 - Web Queries

8.80Objects Present Reports3PAR System Reporter User’s Guide System Reporter 2.8

Strona 194 - [&<option>...])

System Reporter 2.8 3PAR System Reporter User’s Guide9.1Using Adaptive Optimization9Using Adaptive OptimizationThis chapter provides information about

Strona 195 - Data Format Version Report

9.2Overview3PAR System Reporter User’s Guide System Reporter 2.8and tier 2 is the slowest. Tiers are defined by Common Provisioning Groups (CPGs) and

Strona 196 - 8.4 Report Options

9.3Selecting an InServ for Adaptive OptimizationSystem Reporter 2.8 3PAR System Reporter User’s Guide9.2 Selecting an InServ for Adaptive Optimizatio

Strona 197 - 8.4.2 compare

9.4Configuring Adaptive Optimization3PAR System Reporter User’s Guide System Reporter 2.8been checked and is set to 1. In addition, the Skip LD Perfor

Strona 198 - 8.4.2.1 values:

9.5Configuring Adaptive OptimizationSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 9-2. Adaptive Optimization Configuration Main WindowT

Strona 199 - Report Options

9.6Configuring Adaptive Optimization3PAR System Reporter User’s Guide System Reporter 2.8 Mode -- Optimization mode (Cost/Performance/Balanced. See 9

Strona 200 - 8.4.3 comparesel

9.7Configuring Adaptive OptimizationSystem Reporter 2.8 3PAR System Reporter User’s GuideThe TPVV usr space and Snapshot copy space for a CPG can be e

Strona 201 - 8.4.4 table

1.4Typographical Conventions3PAR System Reporter User’s Guide System Reporter 2.81.5 Typographical ConventionsThis guide employs the following typogra

Strona 202 - 8.4.4.2 example:

9.8Configuring Adaptive Optimization3PAR System Reporter User’s Guide System Reporter 2.8CAUTION: You can remove a CPG from a configuration by either

Strona 203 - 8.4.6 charttab

9.9Configuring Adaptive OptimizationSystem Reporter 2.8 3PAR System Reporter User’s Guide9.3.2 ScheduleThe schedule consists of three components: date

Strona 204 - 8.4.7 charttype

9.10Configuring Adaptive Optimization3PAR System Reporter User’s Guide System Reporter 2.89.3.4 Adaptive Optimization ModeYou have the choice of three

Strona 205 - 8.4.9 graphy

9.11Configuring Adaptive OptimizationSystem Reporter 2.8 3PAR System Reporter User’s Guide3 Choose a domain. 4 Choose the CPG that is to be monitored

Strona 206 - 8.4.11 tableformat

9.12Configuring Adaptive Optimization3PAR System Reporter User’s Guide System Reporter 2.89.3.8 Removing an Adaptive Optimization ConfigurationTo remo

Strona 207 - 8.4.12 alllabels

9.13Adaptive Optimization ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide9.4 Adaptive Optimization ReportsSystem Reporter provides three

Strona 208 - 8.4.14 begintsecs

9.14Adaptive Optimization Reports3PAR System Reporter User’s Guide System Reporter 2.8Figure 9-3. Region IO Density with Adaptive OptimizationYou can

Strona 209 - 8.4.15 endtsecs

9.15Adaptive Optimization ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 9-4. Region IO Density without Adaptive OptimizationAs w

Strona 210 - 8.4.16 groupby

9.16Adaptive Optimization Reports3PAR System Reporter User’s Guide System Reporter 2.89.4.2 VV Tiers ReportThe VV Tiers report shows the distribution

Strona 211

9.17Adaptive Optimization ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide9.4.3 Adaptive Optimization Space Moved ReportThe Space Moved re

Strona 212 - 8.4.16.2 example:

System Reporter 2.8 3PAR System Reporter User’s Guide2.1Overview and Features2Overview and FeaturesThis chapter provides a brief overview of the featu

Strona 213 - 8.4.17 orderby

9.18The showvvcpg CLI extension3PAR System Reporter User’s Guide System Reporter 2.89.5 The showvvcpg CLI extensionAdaptive Optimization may move reg

Strona 214

9.19The showvvcpg CLI extensionSystem Reporter 2.8 3PAR System Reporter User’s GuideAn example of the output of the command is shown below, where we h

Strona 215

9.20The showvvcpg CLI extension3PAR System Reporter User’s Guide System Reporter 2.8

Strona 216

System Reporter 2.8 3PAR System Reporter User’s Guide10.1Database Schema10Database SchemaThis chapter documents the 3PAR System Reporter database sche

Strona 217 - 8.4.19 ldspaceunit

10.2Table Versions and Naming Conventions3PAR System Reporter User’s Guide System Reporter 2.810.2 Table Versions and Naming ConventionsAll tables are

Strona 218 - 8.4.20 pdspaceunit

10.3Administrative TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.3.2 The sampleinserv TableThe sampleinserv_4 table contains a row for

Strona 219 - 8.4.21 vvspaceunit

10.4Administrative Tables3PAR System Reporter User’s Guide System Reporter 2.810.3.3 The system TableThe system_3 table contains a row for each InServ

Strona 220 - 8.4.22 selcageid

10.5Administrative TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.3.4 The alertconfig TableThe alertconfig_2 table contains a row for e

Strona 221 - 8.4.23 selchunks

10.6Administrative Tables3PAR System Reporter User’s Guide System Reporter 2.8metric VARCHAR(32) NOT NULLThe metric that is calculated. The supported

Strona 222 - 8.4.23.2 example:

10.7Administrative TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.3.5 The scheduled_report TableThe scheduled_report_1 table contains a

Strona 223 - 8.4.27 seldisktype

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 wi

Strona 224 - 8.4.28 seldiskspeed

2.2Configuring System Reporter Policy Settings3PAR System Reporter User’s Guide System Reporter 2.8 Options for choosing the time and duration for th

Strona 225 - 8.4.29 seldomain

10.8Administrative Tables3PAR System Reporter User’s Guide System Reporter 2.8rpt_createtime VARCHAR(64) NOT NULLThe time when this scheduled report w

Strona 226 - 8.4.30 selhost

10.9Administrative TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.3.6 The scheduled_report_log TableThe scheduled_report_log_1 table is

Strona 227 - 8.4.32 sellduse

10.10Administrative Tables3PAR System Reporter User’s Guide System Reporter 2.8t0_cpg_name VARCHAR(32) NOT NULLTier 0 CPG name. If there is no tier 0,

Strona 228 - 8.4.33 selnode

10.11Administrative TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.3.8 The adprov_log TableThe adprov_log_1 table is used to keep track

Strona 229 - 8.4.34 selnsp

10.12Administrative Tables3PAR System Reporter User’s Guide System Reporter 2.810.3.9 The ldrgmoves TableThe ldrgmoves_1 table is used to keep track o

Strona 230 - 8.4.35 selpdid

10.13Administrative TablesSystem Reporter 2.8 3PAR System Reporter User’s Guidedst_tier INTEGER NOT NULL Specifies the destination tier.dst_cpgname VA

Strona 231 - 8.4.37 selporttype

10.14The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.3.10 The recentsample TableThe recentsample_1 table c

Strona 232 - 8.4.38 selraidtype

10.15The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guideindexes on the data tables. To improve the efficiency of

Strona 233 - 8.4.39 selsys

10.16The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8disktype VARCHAR(32) NOT NULLThe disk type. Currently, t

Strona 234 - 8.4.40 selvv

10.17The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s GuideSPR_USED_FAIL INTEGER NOT NULLNumber of spare chunklets

Strona 235 - 8.4.42 selprovtype

2.3Choosing a Method for Accessing ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide Adaptive Optimization -- Configures the optionally li

Strona 236 - 8.5 Report Types

10.18The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.2 The pdspaceinv TableThe pdspaceinv_<res>_2

Strona 237 - 8.7 Space Reports

10.19The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.3 The ldspace TableThe ldspace_<res>_2 table

Strona 238 - 8.7.4 ld_space_group

10.20The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8rawsizemb INTEGER NOT NULL Raw size of the LD in MB.size

Strona 239 - 8.8 Performance Reports

10.21The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.4 The ldspaceinv TableThe ldspaceinv_<res>_2

Strona 240 - 8.8.3 pd_svt_hist

10.22The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.5 The vvspace TableThe vvspace_<res>_3 table

Strona 241 - 8.8.6 port_perf_group

10.23The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guidewwn CHAR(16) NOT NULL The WWN of the VV.snp_cpg_name VAR

Strona 242 - 8.8.9 ld_perf_time

10.24The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8adm_rsvd_mb DOUBLE PRECISION NOT NULLSnapshot admin spac

Strona 243 - 8.8.12 ld_svt_histvstime

10.25The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.6 The vvspaceinv TableThe vvspaceinv_<res>_3

Strona 244 - 8.8.15 vlun_svt_hist

10.26The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8bsid INTEGER NOT NULL The ID of the base VV for the VV.v

Strona 245 - 8.8.18 vv_cmp_group

10.27The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.7 The cpgspace TableThe cpgspace_<res>_1 tabl

Strona 246 - 8.8.20 cpu_perf_group

2.4Creating Customized Reports3PAR System Reporter User’s Guide System Reporter 2.82.4 Creating Customized ReportsSystem Reporter provides a number o

Strona 247 - 8.9.3 vvtier

10.28The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8snp_total_mb DOUBLE PRECISION NOT NULLThe total snapshot

Strona 248 - 8.9.3.1 vvtier example

10.29The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.8 The cpgspaceinv TableThe cpgspaceinv_<res>_

Strona 249 - Options Available by Report

10.30The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.9 Common Performance Table ColumnsThe statport, sta

Strona 250

10.31The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guided_qlen DOUBLE PRECISION NOT NULLDifference between qlen

Strona 251

10.32The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8d_rticks DOUBLE PRECISION NOT NULLDifference between rti

Strona 252

10.33The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guided_rhist0 DOUBLE PRECISION NOT NULLDifference between rhi

Strona 253 - 8.11 Objects Present Reports

10.34The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8Although in principle it was not necessary to store the

Strona 254 - Objects Present Reports

10.35The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.9.1 Calculating Common Performance MetricsTable 10-

Strona 255

10.36The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.9.2 Service Time Histogram BucketsThe service time

Strona 256

10.37The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.10 The statpd TableThe statpd_<res>_3 table h

Strona 257 - 8.11.1 objectpres= cageid

2.5Creating Customized ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide Sample Resolution. Specifies how often operational metrics are sa

Strona 258 - 8.11.2 objectpres= cpg_name

10.38The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8diskspeed INTEGER NOT NULLThe approximate disk speed in

Strona 259 - 8.11.3 objectpres= diskspeed

10.39The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.11 The statpdinv TableThe statpdinv_<res>_2 t

Strona 260 - 8.11.4 objectpres= disktype

10.40The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.12 The statld TableThe statld_<res>_4 table h

Strona 261 - 8.11.6 objectpres= host_name

10.41The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.13 The statldinv TableThe statldinv_<res>_3 t

Strona 262 - 8.11.7 objectpres= ld_name

10.42The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.14 The statport TableThe statport_<res>_2 tab

Strona 263 - 8.11.8 objectpres=node

10.43The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.15 The statportinv TableThe statportinv_<res>

Strona 264 - 8.11.9 objectpres=pdid

10.44The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8port_n INTEGER NOT NULLThe node that the port is connect

Strona 265 - 8.11.10 objectpres=port

10.45The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.16 The statvlun TableThe statvlun_<res>_3 tab

Strona 266 - 8.11.11 objectpres= system

10.46The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.17 The statvluninv TableThe statvluninv_<res>

Strona 267 - 8.11.12 objectpres= vv_name

10.47The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.18 The statvvcmp TableThe statvvcmp_<res>_2 t

Strona 268 - 8.11.13.2 output:

2.6Formatting Reports for Presentation3PAR System Reporter User’s Guide System Reporter 2.8◆ At Time reports allow you to compare a large number of ob

Strona 269 - 8.11.14 objecctpres= porttype

10.48The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8dom_name VARCHAR(32) NOT NULL The domain name that the V

Strona 270 - 8.11.15 sample_times

10.49The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.19 The statvvcmpinv TableThe statvvcmpinv_<res&g

Strona 271

10.50The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.20 The statcpu TableThe statcpu_<res>_1 table

Strona 272

10.51The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guidecputicks DOUBLE PRECISION NOT NULLThe CPU tick count.A s

Strona 273 - Optimization

10.52The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.21 The statcpuinv TableThe statcpuinv_<res>_1

Strona 274 - Overview

10.53The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guidenode_to INTEGER NOT NULL The node number of the destinat

Strona 275

10.54The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.23 The statlinkinv TableThe statlinkinv_<res>

Strona 276

10.55The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.24 The statldrg TableThe statldrg_hourly_1 table ho

Strona 277

10.56The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.810.4.25 The statldrg_timeinv TableThe statldrg_timeinv_1

Strona 278

10.57The Sample Data and Inventory TablesSystem Reporter 2.8 3PAR System Reporter User’s Guide10.4.26 The perf_timeinv TableThe perf_timeinv_<res&g

Strona 279

2.7Customizing the Reporting FormatSystem Reporter 2.8 3PAR System Reporter User’s GuideSee 5.3.7 Format Selection (Web interface only) on page 5.45 f

Strona 280

10.58The Sample Data and Inventory Tables3PAR System Reporter User’s Guide System Reporter 2.8

Strona 281 - 9.3.3 Measurement Hours

System Reporter 2.8 3PAR System Reporter User’s Guide11.1Troubleshooting11TroubleshootingThis chapter describes how to troubleshoot and solve common p

Strona 282

11.2Troubleshooting the Sampling Components3PAR System Reporter User’s Guide System Reporter 2.811.2 Troubleshooting the Sampling ComponentsThe System

Strona 283

11.3Troubleshooting the Sampling ComponentsSystem Reporter 2.8 3PAR System Reporter User’s Guide11.2.2 Installation ConfigurationOn Windows, you can s

Strona 284

11.4Troubleshooting Adaptive Optimization Components3PAR System Reporter User’s Guide System Reporter 2.811.2.3.1 Errors incurred by the inservsample

Strona 285

11.5Troubleshooting the Web Server ComponentsSystem Reporter 2.8 3PAR System Reporter User’s Guide11.4 Troubleshooting the Web Server ComponentsErrors

Strona 286

11.6Extracting Data from the Database with sysbck3PAR System Reporter User’s Guide System Reporter 2.8Figure 11-1. Microsoft Office Excel Internal Er

Strona 287

11.7Extracting Data from the Database with sysbckSystem Reporter 2.8 3PAR System Reporter User’s GuideOn Windows the sysbck.exe executable is installe

Strona 288 - 9.4.2 VV Tiers Report

11.8Extracting Data from the Database with sysbck3PAR System Reporter User’s Guide System Reporter 2.8Depending on the -scripttype parameter, the sysb

Strona 289

11.9Extracting Data from the Database with sysbckSystem Reporter 2.8 3PAR System Reporter User’s Guide From MySQL to Oracle: From MySQL to MySQL:Fro

Strona 290 - The showvvcpg CLI extension

2.8Using the Database Schema to Build Custom Reports3PAR System Reporter User’s Guide System Reporter 2.82.9 Using the Database Schema to Build Custo

Strona 291

11.10Extracting Data from the Database with sysbck3PAR System Reporter User’s Guide System Reporter 2.8 From SQLite to SQLite: From SQLite to MySQL:

Strona 292

11.11Extracting Data from the Database with sysbckSystem Reporter 2.8 3PAR System Reporter User’s Guide Backs up the entire database from MySQL: Bac

Strona 293 - Database Schema

11.12Dumping the Entire Database3PAR System Reporter User’s Guide System Reporter 2.811.7 Dumping the Entire DatabaseWhen you want to extract a large

Strona 294 - 10.3 Administrative Tables

11.13Dumping the Entire DatabaseSystem Reporter 2.8 3PAR System Reporter User’s Guide11.7.2 Dumping the Entire MySQL DatabaseTo create a dump of a MyS

Strona 295 - 10.3.2 The sampleinserv Table

11.14Dumping the Entire Database3PAR System Reporter User’s Guide System Reporter 2.8

Strona 296 - 10.3.3 The system Table

3PAR System Reporter User’s GuideIX.1IndexIndex3PAR System Reporter User’s Guide 4.43PAR System Reporter.xls 3.333par-policy subdirectory 7.233par-rpt

Strona 297 - 10.3.4 The alertconfig Table

IX.2Index3PAR System Reporter User’s Guidedaily database table 8.5daily samples 7.3data tables 5.6databaseadding or removing storage servers 7.1length

Strona 298 - Administrative Tables

IX.3Index3PAR System Reporter User’s GuideOOperator’s Guide 1.2Oracle 3.15Order By 5.28orderby, web query option 8.21PPD Performance Reports 2.4, 5.7,

Strona 299

IX.4Index3PAR System Reporter User’s GuideSpace Moved Report 9.17spare chunklets 8.30special considerations 3.14SQLite 3.14Stacked Area chart (example

Strona 300

IX.5Index3PAR System Reporter User’s GuideWWeb browserediting sampling policies 7.1requirements 4.1using System Reporter with 4.1Web Queries 8.1Web se

Strona 301 - 10.3.7 The adprovconfig Table

System Reporter 2.8 3PAR System Reporter User’s Guide3.1Installation, Configuration, Update, and Removal3Installation, Configuration, Update, and Remo

Strona 302

IX.6Index3PAR System Reporter User’s Guide

Strona 303 - 10.3.8 The adprov_log Table

3PAR System Reporter User’s GuideRH.1Revision HistoryRevision HistoryRelease level Revision summary320-1330-01August 2005First release of this manual

Strona 304 - 10.3.9 The ldrgmoves Table

RH.2Revision History3PAR System Reporter User’s Guide320-1330-03January 2006Third release of this manual to support release 2.0.Changes include: Inst

Strona 305

RH.3Revision History3PAR System Reporter User’s Guide320-1330-05November 2006Fifth release of this manual to support release 2.2.Changes include: Cha

Strona 306 - ■ daily - Daily sample

RH.4Revision History3PAR System Reporter User’s Guide320-1330-07December 2007Seventh release of this manual to support release 2.4.Changes include: A

Strona 307 - 10.4.1 The pdspace Table

RH.5Revision History3PAR System Reporter User’s Guide320-1330-09August 2008Ninth release of the manual to support release 2.5.Changes include: Add su

Strona 308

RH.6Revision History3PAR System Reporter User’s Guide320-200222 Rev AApril 2010First version of this guide for System Reporter 2.7, replaces previous

Strona 309

RH.7Revision History3PAR System Reporter User’s Guide320-200257 Rev ANovember 2010First version of this guide for System Reporter 2.8, replaces previo

Strona 310 - 10.4.2 The pdspaceinv Table

RH.8Revision History3PAR System Reporter User’s Guide

Strona 311 - 10.4.3 The ldspace Table

3.2System Reporter CD Contents3PAR System Reporter User’s Guide System Reporter 2.83.2 System Reporter CD ContentsInServ Storage Server CD includes t

Strona 312

3.3System Reporter CD ContentsSystem Reporter 2.8 3PAR System Reporter User’s Guide/Windows/apache_2.2.14-win32-x86-openssl-0.9.8k.msiApache HTTP Serv

Strona 313 - 10.4.4 The ldspaceinv Table

direction or management of such entity, whether by contract or otherwise, or (ii) ownership of fifty percent (50%) or more of the outs

Strona 314 - 10.4.5 The vvspace Table

3.4System Requirements3PAR System Reporter User’s Guide System Reporter 2.83.3 System Requirements3PAR System Reporter supports the use of the 3PAR In

Strona 315

3.5System RequirementsSystem Reporter 2.8 3PAR System Reporter User’s Guide3PAR System Reporter components have the following requirements:Table 3-3.

Strona 316

3.6Using the System Reporter Sizing Spreadsheet3PAR System Reporter User’s Guide System Reporter 2.83.4 Using the System Reporter Sizing SpreadsheetB

Strona 317 - 10.4.6 The vvspaceinv Table

3.7Using the System Reporter Sizing SpreadsheetSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 3-1. System Reporter Sizing Spreadsheet

Strona 318

3.8Using the System Reporter Sizing Spreadsheet3PAR System Reporter User’s Guide System Reporter 2.8To use the System Reporter Sizing Spreadsheet:1 Cl

Strona 319 - 10.4.7 The cpgspace Table

3.9System Reporter ComponentsSystem Reporter 2.8 3PAR System Reporter User’s Guide3.5 System Reporter Components3PAR System Reporter includes the fol

Strona 320

3.10System Reporter Components3PAR System Reporter User’s Guide System Reporter 2.8◆ A separate inservsample process is created for each InServ system

Strona 321 - 10.4.8 The cpgspaceinv Table

3.11Installing the System Reporter ComponentsSystem Reporter 2.8 3PAR System Reporter User’s Guide3.6 Installing the System Reporter ComponentsTo beg

Strona 322

3.12Installing the System Reporter Components3PAR System Reporter User’s Guide System Reporter 2.8Install CLIUsing MySQL?Install Apache Web ServerInst

Strona 323

3.13Installing the Web ServerSystem Reporter 2.8 3PAR System Reporter User’s Guide3.7 Installing the Web Server3PAR System Reporter requires Apache H

Strona 324

worldwide, non-exclusive, no-charge, royalty-free, irrevocable (except as stated in this section) patent license to make, have made, u

Strona 325

3.14Installing the Database Server3PAR System Reporter User’s Guide System Reporter 2.83.8 Installing the Database Server3PAR System Reporter supports

Strona 326

3.15Installing the Database ServerSystem Reporter 2.8 3PAR System Reporter User’s GuideSQLite supports only limited database concurrency because it re

Strona 327

3.16Installing the Database Server3PAR System Reporter User’s Guide System Reporter 2.8Table 3-4 provides a comparison of features for the various dat

Strona 328

3.17Installing the Database ServerSystem Reporter 2.8 3PAR System Reporter User’s Guide3.8.2.1 Installing MySQL Server To use MySQL for the 3PAR Syste

Strona 329 - 10.4.10 The statpd Table

3.18Installing the Database Server3PAR System Reporter User’s Guide System Reporter 2.83.8.2.2 Configuring the MySQL DatabaseUse the MySQL Server Inst

Strona 330

3.19Installing the Database ServerSystem Reporter 2.8 3PAR System Reporter User’s Guide9 Confirm the following and then click Next:◆ Install As Window

Strona 331 - 10.4.11 The statpdinv Table

3.20Installing the Database Server3PAR System Reporter User’s Guide System Reporter 2.8/etc/init.d/mysqld restart3.8.2.4 Creating MySQL Users and Sche

Strona 332 - 10.4.12 The statld Table

3.21Installing the Database ServerSystem Reporter 2.8 3PAR System Reporter User’s GuideAs part of installing the System Reporter tools (see Installing

Strona 333 - 10.4.13 The statldinv Table

3.22Installing the Database Server3PAR System Reporter User’s Guide System Reporter 2.82 Click Next at the welcome screen.3 Select the Create a Databa

Strona 334 - 10.4.14 The statport Table

3.23Installing the Database ServerSystem Reporter 2.8 3PAR System Reporter User’s Guide1 At the login screen for the Oracle Enterprise Manager login a

Strona 335 - 10.4.15 The statportinv Table

5. Submission of Contributions. Unless You explicitly state otherwise, any Contribution intentionally submitted for inclusion in the Work

Strona 336

3.24Installing or Upgrading the System Reporter Tools3PAR System Reporter User’s Guide System Reporter 2.88 Select Yes, perform a test and click Next.

Strona 337 - 10.4.16 The statvlun Table

3.25Installing or Upgrading the System Reporter ToolsSystem Reporter 2.8 3PAR System Reporter User’s GuideClick on the Upgrade button to keep the exis

Strona 338 - 10.4.17 The statvluninv Table

3.26Installing or Upgrading the System Reporter Tools3PAR System Reporter User’s Guide System Reporter 2.88 When prompted, type the webuser password i

Strona 339 - 10.4.18 The statvvcmp Table

3.27Installing or Upgrading the System Reporter ToolsSystem Reporter 2.8 3PAR System Reporter User’s Guidefor Email Alerts on page 7.9) you may leave

Strona 340

3.28Installing or Upgrading the System Reporter Tools3PAR System Reporter User’s Guide System Reporter 2.813 Close the Services window.At this point t

Strona 341

3.29Installing or Upgrading the System Reporter ToolsSystem Reporter 2.8 3PAR System Reporter User’s GuideBoth these packages must be installed after

Strona 342 - 10.4.20 The statcpu Table

3.30Installing or Upgrading the System Reporter Tools3PAR System Reporter User’s Guide System Reporter 2.84 For MySQL and Oracle databases, create/edi

Strona 343

3.31Installing or Upgrading the System Reporter ToolsSystem Reporter 2.8 3PAR System Reporter User’s Guide3.9.1 Adding InServ SystemsFollow these inst

Strona 344 - 10.4.22 The statlink Table

3.32Installing or Upgrading the System Reporter Tools3PAR System Reporter User’s Guide System Reporter 2.89 Click Submit Query.10 Repeat step 5 to add

Strona 345

3.33Installing the Excel Client (Optional)System Reporter 2.8 3PAR System Reporter User’s GuideYou can now return to the 3PAR System Reporter window a

Strona 346 - 10.4.23 The statlinkinv Table

TWAPI Copyright & LicenseCopyright (c) 2003-2008, Ashok P. NadkarniAll rights reserved.Redistribution and use in source and binary forms, with or

Strona 347 - 10.4.24 The statldrg Table

3.34About Apache HTTP Server Authorization and Access Control3PAR System Reporter User’s Guide System Reporter 2.83.11 About Apache HTTP Server Author

Strona 348

3.35About Apache HTTP Server Authorization and Access ControlSystem Reporter 2.8 3PAR System Reporter User’s Guide(see Figure 4-9 on page 4.14 and Fig

Strona 349

3.36Removing the System Reporter Components3PAR System Reporter User’s Guide System Reporter 2.83.12 Removing the System Reporter ComponentsThis secti

Strona 350

3.37Removing the System Reporter ComponentsSystem Reporter 2.8 3PAR System Reporter User’s Guide9 (Optional). Go to the location where you installed A

Strona 351 - Troubleshooting

3.38Removing the System Reporter Components3PAR System Reporter User’s Guide System Reporter 2.83 Delete the users created by running the following co

Strona 352

System Reporter 2.8 3PAR System Reporter User’s Guide4.1Getting Started4Getting StartedThis chapter describes how to start using 3PAR System Reporter

Strona 353 - 11.2.3 InServ Sampling Errors

4.2Accessing the Main System Reporter Interface3PAR System Reporter User’s Guide System Reporter 2.8If the Apache HTTP Server has been configured to r

Strona 354

4.3System Reporter Main Menu WindowSystem Reporter 2.8 3PAR System Reporter User’s Guide4.2 System Reporter Main Menu WindowThe various System Report

Strona 355 - /var/log/httpd)

4.4Getting Help3PAR System Reporter User’s Guide System Reporter 2.8◆ Policy Settings (see Chapter 7, Configuring the System Reporter Policy Settings

Strona 356

4.5Using the Object Selection ControlsSystem Reporter 2.8 3PAR System Reporter User’s Guide4.4 Using the Object Selection ControlsMenus in System Rep

Strona 357

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

Strona 358

4.6Accessing the Optional Excel Client3PAR System Reporter User’s Guide System Reporter 2.84.5 Accessing the Optional Excel ClientThe 3PAR System Rep

Strona 359 - ■ From Oracle to Oracle:

4.7Accessing the Optional Excel ClientSystem Reporter 2.8 3PAR System Reporter User’s GuideThe 3PAR System Reporter Excel client opens in Microsoft® E

Strona 360 - ■ From SQLite to Oracle:

4.8Accessing the Optional Excel Client3PAR System Reporter User’s Guide System Reporter 2.8SFigure 4-4. Security Warning for Enabling Macros in Excel

Strona 361

4.9Accessing the Optional Excel ClientSystem Reporter 2.8 3PAR System Reporter User’s GuideFigure 4-5. Setting the Security Level3 On the Security Le

Strona 362 - Dumping the Entire Database

4.10Accessing the Optional Excel Client3PAR System Reporter User’s Guide System Reporter 2.84.5.2.2 Setting the Security Level for Excel 2007In most c

Strona 363

4.11Accessing the Optional Excel ClientSystem Reporter 2.8 3PAR System Reporter User’s GuideIf you do not see a Security Warning when accessing the Ex

Strona 364

4.12Accessing the Optional Excel Client3PAR System Reporter User’s Guide System Reporter 2.89 Click OK, then click OK again to return to the System Re

Strona 365

4.13Accessing the Optional Excel ClientSystem Reporter 2.8 3PAR System Reporter User’s GuideThe Connection Parameters dialog box appears (Figure 4-8).

Strona 366

4.14Changing the Excel Client Server and Resetting the Workbook3PAR System Reporter User’s Guide System Reporter 2.8Figure 4-9. Connection Dialog Box

Strona 367

4.15Accessing the Excel Client Query LogSystem Reporter 2.8 3PAR System Reporter User’s Guide4.6.1 Changing the Web ServerTo change the Web server use

Strona 368

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 t

Strona 369

4.16Deleting Excel Sheets3PAR System Reporter User’s Guide System Reporter 2.8You can hide, unhide, or delete the Query Log sheet as desired. If delet

Strona 370

4.17Saving and Exiting the Excel ClientSystem Reporter 2.8 3PAR System Reporter User’s GuideTo delete the query log:1 Make the Query Log tab visible b

Strona 371 - Revision History

4.18Saving and Exiting the Excel Client3PAR System Reporter User’s Guide System Reporter 2.8Figure 4-10. Security Alerts Multiple IssuesTo enable mac

Strona 372

System Reporter 2.8 3PAR System Reporter User’s Guide5.1Accessing and Creating Reports5Accessing and Creating ReportsThis chapter describes how to acc

Strona 373

5.2Accessing Quick Reports3PAR System Reporter User’s Guide System Reporter 2.85.1 Accessing Quick ReportsQuick reports provide predefined reports th

Strona 374

5.3Accessing Scheduled ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.2 Accessing Scheduled ReportsScheduled reports are generated usi

Strona 375

5.4Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3 Creating Custom ReportsYou can create customized reports by selecti

Strona 376

5.5Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s Guide5.3.1 Building the Report MenuThe first step in creating a report is to

Strona 377

5.6Creating Custom Reports3PAR System Reporter User’s Guide System Reporter 2.85.3.1.1 Sample ResolutionThe Sample resolution control enables you to s

Strona 378

5.7Creating Custom ReportsSystem Reporter 2.8 3PAR System Reporter User’s GuideLD Space Display logical disk space usage. See 6.2.2 LD Space Reports o

Komentarze do niniejszej Instrukcji

Brak uwag