User Manual

Table 68 recentsample_1 Table
CommentTypeColumn
The sample resolution, one of hires, hourly or daily.VARCHAR(32) NOT NULLresolution
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 NULLtsecs
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
<res> 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_<res>_3 table holds physical disk (PD) space data samples.
Table 69 pdspace_<res>_3 Table
CommentTypeColumn
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 NULLtsecs
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 NULLsys_uid
The physical disk ID.INTEGER NOT NULLpdid
The cage ID that the PD is inINTEGER NOT NULLcageid
The side of the disk chassis that the cage is in.INTEGER NOT NULLcageside
The magazine number in the cage that the PD is in.INTEGER NOT NULLmag
The disk number in the magazine.INTEGER NOT NULLdisk
The disk type. Currently, the disk types are FC - Fibre Channel
drive. NL - Nearline drive.
VARCHAR(32) NOT NULLdisktype
The approximate disk speed in K RPMINTEGER NOT NULLdiskspeed
The state of the PD.VARCHAR(32) NOT NULLstate
The WWN of the PD.CHAR(16) NOT NULLwwn
Number of normal chunklets that are used in LDs.INTEGER NOT NULLNRM_USED_OK
198 Database Schema