![](/images/backgrounds/286310/hp-3par-system-reporter-e-media-kit-users-manual-156017331x1.png)
System Reporter 2.8 | 3PAR System Reporter User’s Guide |
10.4.11 The statpdinv Table
The statpdinv_<res>_2 table holds inventory for the statpd_<res>_3 table.
Table
Column | Type | Comment |
|
|
|
tsecs | INTEGER NOT | Sample time in secs. This is the Unix time |
| NULL | and is the number of seconds since |
|
| 0:00:00 Jan 1, 1970 GMT. |
|
|
|
sys_uid | INTEGER NOT | A unique identifier for the InServ system |
| NULL | instance refers to the uniq_id for the |
|
| InServ system instance in the system_3 |
|
| table. |
|
|
|
pdid | INTEGER NOT | The physical disk ID. |
| NULL |
|
|
|
|
port_n | INTEGER NOT | The node that the disk’s primary port is |
| NULL | connected to (the “n” part of n:s:p). |
|
|
|
port_s | INTEGER NOT | The PCI slot in the node that the disk’s |
| NULL | primary port is connected to (the “s” part |
|
| of n:s:p). |
|
|
|
port_p | INTEGER NOT | The port number in the PCI slot in the |
| NULL | node that the disk’s primary port is |
|
| connected to (the “p” part of n:s:p). |
|
|
|
disktype | VARCHAR(32) NOT | The disk type. Currently, the disk types |
| NULL | are: |
|
| ■ FC - Fibre channel drive. |
|
| ■ NL - Nearline drive. |
|
|
|
diskspeed | INTEGER NOT | The approximate disk speed in K RPM. |
| NULL |
|
|
|
|
The Sample Data and Inventory Tables 10.39