HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 198
The Sample Data and Inventory Tables, The pdspace Table
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 198 highlights
Table 68 recentsample_1 Table Column resolution tsecs Type Comment VARCHAR(32) NOT NULL The sample resolution, one of hires, hourly or daily. INTEGER NOT NULL 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. 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 Column tsecs sys_uid pdid cageid cageside mag disk disktype diskspeed state wwn NRM_USED_OK Type INTEGER NOT NULL INTEGER NOT NULL INTEGER NOT NULL INTEGER NOT NULL INTEGER NOT NULL INTEGER NOT NULL INTEGER NOT NULL VARCHAR(32) NOT NULL INTEGER NOT NULL VARCHAR(32) NOT NULL CHAR(16) NOT NULL INTEGER NOT NULL Comment Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. A unique identifier for the HP 3PAR StoreServ Storage instance refers to the uniq_id for the system instance in the system_3 table The physical disk ID. The cage ID that the PD is in The side of the disk chassis that the cage is in. The magazine number in the cage that the PD is in. The disk number in the magazine. The disk type. Currently, the disk types are FC - Fibre Channel drive. NL - Nearline drive. The approximate disk speed in K RPM The state of the PD. The WWN of the PD. Number of normal chunklets that are used in LDs. 198 Database Schema