HP 3PAR System Reporter Software - Manual (Page 331)

10.39 The Sample Data and Inventory Tables
System Reporter 2.8 3PAR System Reporter User’s Guide
10.4.11 The statpdinv Table
The statpdinv__2 table holds inventory for the statpd__3 table.
Table 10-22. statpdinv__2 Table
Column Type Comment
tsecs INTEGER NOT
NULL
Sample time in secs. This is the Unix time
and is the number of seconds since
0:00:00 Jan 1, 1970 GMT.
sys_uid INTEGER NOT
NULL
A unique identifier for the InServ system
instance refers to the uniq_id for the
InServ system instance in the system_3
table.
pdid INTEGER NOT
NULL
The physical disk ID.
port_n INTEGER NOT
NULL
The node that the disk’s primary port is
connected to (the “n” part of n:s:p).
port_s INTEGER NOT
NULL
The PCI slot in the node that the disk’s
primary port is connected to (the “s” part
of n:s:p).
port_p INTEGER NOT
NULL
The port number in the PCI slot in the
node that the disk’s primary port is
connected to (the “p” part of n:s:p).
disktype VARCHAR(32) NOT
NULL
The disk type. Currently, the disk types
are:
■ FC - Fibre channel drive.
■ NL - Nearline drive.
diskspeed INTEGER NOT
NULL
The approximate disk speed in K RPM.