HP 3PAR StoreServ 7000 Storage - Manual (Page 198)

Table 68 recentsample_1 Table
Comment Type Column
The sample resolution, one of hires, hourly or daily. VARCHAR(32) NOT NULL resolution
Sample time in secs of the most recent complete sample of the
resolution. This is the Unix time and is the number of seconds since
0:00:00 Jan 1, 1970 GMT. INTEGER NOT NULL tsecs
The Sample Data and Inventory Tables
The sample data tables include the space and performance samples of various objects in the
systems. For each type of sample, there are three separate tables, one for each sampling resolution:
•
hires - High resolution samples
•
hourly - Hourly samples
•
daily - Daily sample.
The tables for the different resolutions are identical in their structure. In the table names, the substring
can be replaced by either hires, hourly or daily.
The database often needs to be queried to determine all the objects that are present in the table.
Often, this information is used to populate the menus in a web browser or Excel client. Since the
data tables can be very large, this type of query can take a long time in spite of indexes on the
data tables. To improve the efficiency of these queries, a separate set of inventory tables is
maintained, one for each sample data table. The inventory tables contain a row for each distinct
object in the corresponding sample data table. When the sampler inserts new samples into a table,
or removes older samples from a table, it also updates the corresponding inventory table.
The pdspace Table
The pdspace__3 table holds physical disk (PD) space data samples.
Table 69 pdspace__3 Table
Comment Type Column
Sample time in secs. This is the Unix time and is the number
of seconds since 0:00:00 Jan 1, 1970 GMT. INTEGER NOT NULL tsecs
A unique identifier for the HP 3PAR StoreServ Storage instance
refers to the uniq_id for the system instance in the system_3
table INTEGER NOT NULL sys_uid
The physical disk ID. INTEGER NOT NULL pdid
The cage ID that the PD is in INTEGER NOT NULL cageid
The side of the disk chassis that the cage is in. INTEGER NOT NULL cageside
The magazine number in the cage that the PD is in. INTEGER NOT NULL mag
The disk number in the magazine. INTEGER NOT NULL disk
The disk type. Currently, the disk types are FC - Fibre Channel
drive. NL - Nearline drive. VARCHAR(32) NOT NULL disktype
The approximate disk speed in K RPM INTEGER NOT NULL diskspeed
The state of the PD. VARCHAR(32) NOT NULL state
The WWN of the PD. CHAR(16) NOT NULL wwn
Number of normal chunklets that are used in LDs. INTEGER NOT NULL NRM_USED_OK
198 Database Schema