HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 193
The system Table, Table 60 sampleinserv_5 Table, Table 61 system_4 Table
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 193 highlights
Table 60 sampleinserv_5 Table Column name usessl Type VARCHAR(64) NOT NULL INTEGER NOT NULL Comment IP address of the system to sample. Determines whether CLI connections to the HP 3PAR StoreServ Storage will use SSL. 0 - Do not use SSL 1 - Use SSL cliport noldperf INTEGER NOT NULL INTEGER NOT NULL Currently unused. In future this will be used to explicitly specify the port number to use for the CLI connection to the system. 0 - Collect LD performance data 1 - Do not collect LD performance data. disable INTEGER NOT NULL 0 - Data collection for the system is enabled 1 - Data collection for the system is disabled sample_chrg INTEGER NOT NULL 0 - Do not collect region level data for Adaptive Optimization 1 - Collect region level data for Adaptive Optimization HIGHRESHRS HOURLYDAYS DAILYDAYS RGCHHOURLYDAYS INTEGER NOT NULL INTEGER NOT NULL INTEGER NOT NULL INTEGER NOT NULL Number of hours the hires sample should be retained for a particular system. Number of days the hourly sample should be retained for a particular system. Number of days the daily sample should be retained for a particular system. Number of days the hourly sample for region stats should be retained for a particular system. The system Table The system_4 table contains a row for each system that has been sampled. A single physical system 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 61 system_4 Table Column uniq_id serial name mhz ip_name os_rev Type Comment INTEGER PRIMARY KEY A unique identifier for the system instance. All samples in the data (AUTO_INCREMENT) tables have this uniq_id in the sys_uid column. INTEGER NOT NULL Serial number of the system. VARCHAR(32) NOT NULL HP 3PAR StoreServ Storage name. This is what gets used in most reports to identify the system. INTEGER NOT NULL The CPU frequency in MHz. For os_rev prior to 2.2.2, the MHz is used to calculate the times for the service time histogram buckets. For os_rev of 2.2.2 or later, the service time histogram buckets are in terms of absolute time in milliseconds rather than relative to CPU frequency. See "Service Time Histogram Buckets" (page 208). VARCHAR(32) NOT NULL IP Address of the system. VARCHAR(32) NOT NULL HP 3PAR OS revision. This is needed in some cases to determine how to interpret some data. For example, see the mhz column description above. Administrative Tables 193