User Manual

Table 60 sampleinserv_5 Table
CommentTypeColumn
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 NULLusessl
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 NULLcliport
0 - Collect LD performance dataINTEGER NOT NULLnoldperf
1 - Do not collect LD performance data.
0 - Data collection for the system is enabledINTEGER NOT NULLdisable
1 - Data collection for the system is disabled
0 - Do not collect region level data for Adaptive OptimizationINTEGER NOT NULLsample_chrg
1 - Collect region level data for Adaptive Optimization
Number of hours the hires sample should be retained for a
particular system.
INTEGER NOT NULLHIGHRESHRS
Number of days the hourly sample should be retained for a
particular system.
INTEGER NOT NULLHOURLYDAYS
Number of days the daily sample should be retained for a
particular system.
INTEGER NOT NULLDAILYDAYS
Number of days the hourly sample for region stats should be
retained for a particular system.
INTEGER NOT NULLRGCHHOURLYDAYS
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
CommentTypeColumn
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 NULLserial
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 NULLmhz
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).
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
Administrative Tables 193