10.40, Statld Table | HP System Reporter E-Media Kit specification

3PAR System Reporter User’s Guide

System Reporter 2.8

10.4.12 The statld Table

The statld_<res>_4 table holds logical disk (LD) performance data samples.

Table 10-23.statld_<res>_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.

dom_name	VARCHAR(32) NOT	The domain name that the LD belongs
	NULL	to. If the LD is not assigned to a domain,
		this column contains the value “-”.

ldid	INTEGER NOT	The logical disk ID.
	NULL

node	INTEGER NOT	The node that owns the LD
	NULL

cpg_name	VARCHAR(32) NOT	The name of the CPG that the LD belongs
	NULL	to. If the LD is not in a CPG, this column
		contains the value “----”.

(common		The rest of the columns are the common
performance		performance columns described in
columns)		Common Performance Table Columns on
		page 10.30).

10.40

The Sample Data and Inventory Tables

Image 332

HP System Reporter E-Media Kit, System Reporter Media Kit manual 10.40, Statld Table

Contents

3PAR System Reporter 2.8 User’s Guide Revision Notice Oractcl Copyright and License Page Page Page Preamble Page Page No Warranty Table of Contents Installation, Configuration, Update, and Removal Xii Xiii Removing the System Reporter Components Xiv Creating Custom Reports Working with Excel Charts Xvi Interpreting Report Metrics Xvii Web Queries Xviii Xix Performance Reports Using Adaptive Optimization Database Schema Xxi Troubleshooting Xxii Xxiii Xxiv Audience User Interfaces Related Documentation For information about… Read the… Organization Typeface Meaning Example ABCDabcd Typographical ConventionsAdvisories Overview and Features About 3PAR System Reporter Configuring System Reporter Policy Settings Choosing a Method for Accessing Reports Creating Customized Reports Report Name Description Report Metrics Cross Reference Node Cache Performance Formatting Reports for Presentation Generating Email Alerts Accessing Report Data using Web QueriesCustomizing the Reporting Format Using the Database Schema to Build Custom Reports Analyzing and Optimizing Storage Utilization Installation, Configuration, Update, and Removal Before You Begin System Reporter CD Contents Installer.exe Setup.exeApache2.2.14 Win32-x86-openssl System Requirements System Component Minimum Requirement InServ Storage Server System Requirements Using the System Reporter Sizing Spreadsheet System Reporter Sizing Spreadsheet Using the System Reporter Sizing Spreadsheet System Reporter Components InServ Storage Server and User Interface Components System Reporter Components Installing the System Reporter Components Installing the System Reporter Components Section Installing the Web Server SQLite Installing the Database ServerChoosing the Appropriate Database MySQL Oracle Installing and Setting Up the MySQL Database Optional Comment SQLite MySQL Oracle Installing MySQL Server Configuring the MySQL Database Select Multifunctional Database then click Next Setting the maxallowedpacket parameter Maxallowedpacket=32M Creating MySQL Users and Schema Mysql -u root -p Creating an Oracle database Setting Up the Oracle Database OptionalStart the Oracle Database Configuration Assistant Creating the Oracle Users for System Reporter Creating the Oracle Net Service 3PAR System Reporter Installer window opens Installing or Upgrading the System Reporter ToolsInstalling or Upgrading System Reporter Tools on Windows Installing or Upgrading the System Reporter Tools Installing or Upgrading the System Reporter Tools Installing or Upgrading the System Reporter Tools Installing System Reporter Tools on Linux Rpm --install sampleloop-2.8-1.i386.rpm Etc/init.d/sampleloop start Adding InServ Systems 3PAR System Reporter window appears Click Submit Query Setting File Permissions OptionalVerifying Installation Installing the Excel Client Optional About Apache Http Server Authorization and Access Control Directory cgi-bin/3par-rpts AuthType Basic Removing the System Reporter Components Removing the System Reporter Tools on Windows Removing the System Reporter Tools on Linux Removing the MySQL Database Optional Drop user cliuser drop user webuser Accessing the Main System Reporter Interface Getting Started Connection Dialog Box System Reporter Main Menu Window System Reporter Main Window Getting Help Filtered Multi-Selection Control Using the Object Selection ControlsSimple Selection List Accessing the Optional Excel Client Starting the System Reporter Excel Client Setting the Security Level for Excel Setting the Security for Excel Security Warning for Enabling Macros in Excell Setting the Security Level Setting the Security Level for Excel Macro Security Alert for Excel Click Trust Center Click Trust Center Settings Trust Center Screen Connecting to the Web Server from the Excel Client Connection Parameters dialog box appears Figure Changing the Excel Client Server and Resetting the Workbook Changing the Web Server Accessing the Excel Client Query LogResetting the Workbook Deleting Data Sheets Deleting Excel SheetsDeleting Menu Sheets Deleting the Query Log Saving and Exiting the Excel Client 10.Security Alerts Multiple Issues Accessing and Creating Reports Accessing Quick Reports Quick Reports Window Accessing Scheduled Reports Scheduled Reports Window Creating Custom Reports Building the Report Menu Custom Reports Window Sample Resolution Report Common Performance Metrics on page 6.11 for Select Systems Option Purpose Select Domains Generating the Report Report Menu for Daily Vlun Performance Creating Custom Reports Creating Custom Reports Query Results Controls Available by Report Report Selection Object Selection ReportTime Selection 3PAR System Reporter User’s Guide Report Selection Format Selection At Time Standard Report TypesReport Type Purpose Versus Time Time Report Type Purpose HistogramHistogram At Versus Time Report Example Versus Time with Compare=System Report Example Group By SystemHost At Time Report Example Histogram Versus Time Report Example Select Summary Columns 10.Histogram At Time Report Example Group By CompareSelect Peak Pdid System Reporter Order By Order by the CPG that the LD belongs to Sum End Buckets Low BucketHigh Bucket Time Selection Reload After minsBegin/At Time End Time Count Include Chunklets Object SelectionSelect PDIDs Select Cage IDs Select Disk Types Select Disk Speed Include PDs in States Select Usr CPGs Select Snp CPGs Select CPGs Select LDs Select RAID Types Select LD Usage Select VVs Select Prov Types CTRL+CLICK Select VV Types Select Ports nsp Select Port Types Select Hosts Select Nodes Select To Nodes Report Information Format Selection Web interface onlySelect Queues Chart Types 11.Example of a Table Stacked Bars Stacked Vert Bars Stacked Area Lines Bars Vert Bars Time Labels Chart X PixelsChart Y Pixels Time Format Select Space Unit Choose Change Chart Type Working with Excel ChartsChoosing a Chart Type Refreshing Charts 18.Change Chart Type Menu for the Excel Client External Data Range Properties dialog box appears 19.Data Range Properties Shortcut Menu Retaining Charts 20.External Data Range Properties Dialog Box Exporting Executable Reports Adding Custom Columns to a Data Sheet Customizing Excel Reports =IFN530,H53/N53*100,0 Creating a Custom Chart=H53+J53+K53 Working with Excel Charts Saving Customized Settings Chart Interpreting Report Metrics Summary Report Metric Description Summary Report Metrics 3PAR System Reporter User’s Guide Metric Description Space Reports PD Space Reports Totals LD Space ReportsUsage Type Description Spare, Unused, Failed VV Space Reports VV Space Report Metrics 3PAR System Reporter User’s Guide Performance Reports Common Performance Metrics 3PAR System Reporter User’s Guide VV Cache Performance Reports Node Cache Performance Reports CPU Performance Reports Adaptive Optimization Reports Link Performance Reports Configuring the System Reporter Policy Settings Accessing the System Reporter Policies Configuring Sampling Policies Policy Default Full path to directory containing InFormCLI password files Etc/clipwdir on Linux Compacting Databases See Compacting Databases on Editing Sampling Policies Connection Dialog Box Adding, Removing and Re-Configuring InServ Storage Systems Adding a Storage Server Verifying Addition of a Storage ServerRemoving a Storage Server Click Remove InServ Re-Configuring a Storage Server Sampling Configuring Rules for Email Alerts Adding an Alert Rule3PAR System Reporter Policies window appears Click Add Alert Changing an Alert Rule Removing an Alert Rule Alert Rule Parameters Data TableClick Remove Alert Data Table Description Resolution Metric Resolution DescriptionSystem Metrics Description Data Tables Averaged over the sample Direction Limit Value Example of an Alert Rule Limit CountCondition Condition Value Scheduling Reports Scheduledreports/report directory/report name/YYYYMMDDHH Click Add Scheduled Report Adding a Scheduled ReportChoose the Scheduled Reports tab Changing a Scheduled Report Removing a Scheduled Report Configuring Adaptive Optimization About File Permissions Modifying the Apache Http Server Configuration Files Modifying the Apache Http Server Configuration Files Web Queries About Web Queries Data Format Version Report System Reporter Version Report About Reports and Options Report OptionsCategory Option=value Compare ExampleDaily Hourly Values Host VVTypeProvType LDUsage Comparesel Interrupts CtxtswsTotalspace Rawspace Pdspace VvspaceStatpd Statld Charttab ChartRefresh Both Charttype StackedbarsStackedvbars Stackedarea Value GraphxGraphy Bottom Right GraphlegposTableformat Alllabels Excel Timeform Begintsecs Endtsecs Tsecs Groupby PortNode Groupby=System Orderby Order results by Virtual Volume VV Type Service Time IOPsBandwidth IO Size TotalAccesses IdleIntr Ctxt Histbegin Ldspaceunit Pdspaceunit ExamplesMiB 220 bytes GB 109 bytes Vvspaceunit Chunklets Selcageid All cage IDs Selchunks Nrmavaildrty Selchunkls=NRMAVAILCLEAN Selchunkls=NRMAVAILCLEAN&selchunks=SPRAVAILCLEAN Selcpg SelusrcpgSelsnpcpg Seldisktype All Disk Speeds SeldiskspeedAll Disk Types Domainname SeldomainALL Domains Selhost Domain2ALL Hosts Hostname Selld SellduseAll LDs Ldname Selnode Log All Ports SelnspAll Nodes Selpdid ALL PDIDs Selpdstate SelporttypeAll PD States Valid Selraidtype Selsys Selraidtype=Selraidtype=1&selraidtype=5 All Systems Selvv Selvvtype Selprovtype Report Types Pdspacegroup SummaryPdspacetime Ldspacetime Ldspacegroup Pdperftime VvspacetimeVvspacegroup Pdperfgroup Pdsvthist Portperfgroup PdsvthistvstimePortperftime Portsvthist PortsvthistvstimeLdperftime Compare=System Ldsvthistvstime LdperfgroupLdsvthist Vlunsvthist VlunperftimeVlunperfgroup Vvcmpgroup VlunsvthistvstimeVvcmptime Cpuperftime Cpuperfgroup Regiodensity RegmovesVvtier Regiondensity example Report Option Options Available by ReportVvtier example M M Report Option Histsvtpd M M M M M M Objects Present Reports Http//localhost/cgi-bin/3par-rpts Using tableformat=excel Without using tableformat=excel Objectspresent&objectpres= ldname on Report Table values Objectpres= cageid Sampletimes on Objectspresent&objectpres=cageid Objectpres= cpgnameOutput Objectpres= diskspeed Objectspresent&objectpres=cpgname Objectspresent&objectpres=disktype Objectpres= disktypeObjectspresent&objectpres=diskspeed Objectspresent&objectpres=domainname Objectpres= domainnameObjectpres= hostname Objectpres= ldname Objectspresent&objectpres=hostname Objectpres=node Objectspresent&objectpres=ldname Objectpres=pdid Objectspresent&objectpres=node Objectpres=port Objectspresent&objectpres=pdid Objectpres= system Objectspresent&objectpres=port Objectspresent&objectpres=vvname Objectspresent&objectpres=system usingObjectpres= vvname Objectpres= vvnamenosnap Objectspresent&objectpres=vvnamenosnap Objecctpres= porttype Objectspresent&objectpres=porttype Sampletimes Time string with format yyyy-mm-dd hhmmss Objects Present Reports Objects Present Reports Using Adaptive Optimization Overview Overview Selecting an InServ for Adaptive Optimization Configuring Adaptive Optimization Adaptive Optimization Configuration Main Window Tier Definition CPG Name and GiB Configuring Adaptive Optimization Configuring Adaptive Optimization Schedule Measurement Hours Adaptive Optimization Mode Adding an Adaptive Optimization ConfigurationAdd Adaptive Optimization Configuration window appears Adaptive Optimization Active Changing an Adaptive Optimization Configuration Change Adaptive Optimization Configuration window appears Removing an Adaptive Optimization Configuration Region IO Density Report Region IO Density with Adaptive Optimization Region IO Density without Adaptive Optimization VV Tiers Report Adaptive Optimization Space Moved Report Space Moved Report Showvvcpg CLI extension Cli% source showvvcpg.tcl CPG Showvvcpg CLI extension Using The Database Schema 10.1 Administrative Tables Table Versions and Naming Conventions10.2 Policy Table 10.3 Sampleinserv Table 10.4 System Table Alertconfig Table 10.5 10.6 Datatable value 10.7 Scheduledreport Table 10.8 Scheduledreportlog Table Adprovconfig Table10.9 10.10 10.11 Adprovlog Table 10.12 Ldrgmoves Table 10.13 Recentsample Table Sample Data and Inventory Tables10.14 10.15 Pdspace Table 10.16 10.17 10.18 Pdspaceinv Table 10.19 Ldspace Table 10.20 10.21 Ldspaceinv Table 10.22 Vvspace Table 10.23 10.24 10.25 Vvspaceinv Table 10.26 10.27 Cpgspace Table 10.28 10.29 Cpgspaceinv Table 10.30 Common Performance Table Columns 10.31 10.32 10.33 10.34 Metric SQL Expression 10.35Calculating Common Performance Metrics IO Size Histogram Buckets Service Time Histogram Buckets10.36 10.37 Statpd Table 10.38 10.39 Statpdinv Table 10.40 Statld Table 10.41 Statldinv Table 10.42 Statport Table 10.43 Statportinv Table 10.44 10.45 Statvlun Table 10.46 Statvluninv Table 10.47 Statvvcmp Table 10.48 Sysuid 10.49Statvvcmpinv Table 10.50 Statcpu Table 10.51 Null CPU Statlink Table 10.52Statcpuinv Table 10.53 10.54 Statlinkinv Table 10.55 Statldrg Table 10.56 Statldrgtimeinv Table Spacetimeinv Table 10.57Perftimeinv Table 10.58 Troubleshooting Overview 11.1 Sampling Component Log Files Troubleshooting the Sampling Components11.2 11.3 Installation ConfigurationInServ Sampling Errors Troubleshooting Adaptive Optimization Components Sampler Service/Daemon ErrorsErrors incurred by the inservsample process Errors incurred by the CLI sampler process 11.5 Troubleshooting the Web Server ComponentsTroubleshooting the Excel Client Extracting Data from the Database with sysbck 11.6 11.7 Examples of Using sysbck for Various Databases 11.8 11.9 From MySQL to Oracle 11.10 11.11 Dumping the Entire SQLite Database Dumping the Entire Database11.12 11.13 Dumping the Entire MySQL Database 11.14 Index IX.1 IX.2 IX.3 IX.4 IX.5 IX.6 RH.1 Release level Revision summary Configuration, Update, and Removal RH.2 RH.3 RH.4 RH.5 RH.6 RH.7 RH.8