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

Table 79 statpd__4 Table (continued)
Comment Type Column
The PCI slot in the node that the disk’s primary port is connected to (the
“s” part of n:s:p). INTEGER NOT NULL port_s
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). INTEGER NOT NULL port_p
The disk type. Currently, the disk types are VARCHAR(32) NOT
NULL disktype
•
FC - Fibre channel drive.
•
NL - Nearline drive.
The approximate disk speed in K RPM. INTEGER NOT NULL diskspeed
The rest of the columns are the common performance columns described
in
“Common Performance Table Columns” (page 203) ).
(common performance
columns)
The statpdinv Table
The statpdinv__2 table holds inventory for the statpd__3 table.
Table 80 statpdinv__2 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 system 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 node that the disk’s primary port is connected to (the “n” part of
n:s:p). INTEGER NOT NULL port_n
The PCI slot in the node that the disk’s primary port is connected to (the
“s” part of n:s:p). INTEGER NOT NULL port_s
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). INTEGER NOT NULL port_p
The disk type. Currently, the disk types are: VARCHAR(32) NOT
NULL disktype
•
FC - Fibre channel drive.
•
NL - Nearline drive.
The approximate disk speed in K RPM. INTEGER NOT NULL diskspeed
The statld Table
The statld__5 table holds logical disk (LD) performance data samples.
Table 81 statld__5 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 system instance refers to the uniq_id for the
system instance in the system_3 table. INTEGER NOT NULL sys_uid
The domain name that the LD belongs to. If the LD is not assigned to a
domain, this column contains the value “-”. VARCHAR(32) NOT
NULL dom_name
The logical disk ID. INTEGER NOT NULL ldid
The Sample Data and Inventory Tables 207