The system table – HP 3PAR System Reporter Software User Manual
Page 196
Table 63 sampleinserv_5 Table
Comment
Type
Column
IP address of the system to sample.
VARCHAR(64) NOT
NULL
name
Determines whether CLI connections to the HP 3PAR StoreServ
Storage will use SSL.
0 - Do not use SSL
INTEGER NOT NULL
usessl
1 - Use SSL
Currently unused. In future this will be used to explicitly specify
the port number to use for the CLI connection to the system.
INTEGER NOT NULL
cliport
0 - Collect LD performance data
INTEGER NOT NULL
noldperf
1 - Do not collect LD performance data.
0 - Data collection for the system is enabled
INTEGER NOT NULL
disable
1 - Data collection for the system is disabled
0 - Do not collect region level data for Adaptive Optimization
INTEGER NOT NULL
sample_chrg
1 - Collect region level data for Adaptive Optimization
Number of hours the hires sample should be retained for a
particular system.
INTEGER NOT NULL
HIGHRESHRS
Number of days the hourly sample should be retained for a
particular system.
INTEGER NOT NULL
HOURLYDAYS
Number of days the daily sample should be retained for a
particular system.
INTEGER NOT NULL
DAILYDAYS
Number of days the hourly sample for region stats should be
retained for a particular system.
INTEGER NOT NULL
RGCHHOURLYDAYS
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 64 system_4 Table
Comment
Type
Column
A unique identifier for the system instance. All samples in the data
tables have this uniq_id in the sys_uid column.
INTEGER PRIMARY KEY
(AUTO_INCREMENT)
uniq_id
Serial number of the system.
INTEGER NOT NULL
serial
HP 3PAR StoreServ Storage name. This is what gets used in most
reports to identify the system.
VARCHAR(32) NOT
NULL
name
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.
INTEGER NOT NULL
mhz
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”
.
IP Address of the system.
VARCHAR(32) NOT
NULL
ip_name
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.
VARCHAR(32) NOT
NULL
os_rev
196
Database Schema