HP 3PAR System Reporter 3.1 MU2 Software User Guide

Table 82 statpd_<res>_4 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 system instance refers to the uniq_id for the
system instance in the system_4 table.
INTEGER NOT NULLsys_uid
The physical disk ID.INTEGER NOT NULLpdid
The node that the disk’s primary port is connected to (the “n” part of
n:s:p).
INTEGER NOT NULLport_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 NULLport_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 NULLport_p
The disk type. Currently, the disk types areVARCHAR(32) NOT
NULL
disktype
• FC - Fibre channel drive.
• NL - Nearline drive.
The approximate disk speed in K RPM.INTEGER NOT NULLdiskspeed
The rest of the columns are the common performance columns described
in “Common Performance Table Columns” (page 208)).
(common performance
columns)
The statpdinv Table
The statpdinv_<res>_4 table holds inventory for the statpd_<res>_4 table.
Table 83 statpdinv_<res>_4 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 system instance refers to the uniq_id for the
system instance in the system_4 table.
INTEGER NOT NULLsys_uid
The physical disk ID.INTEGER NOT NULLpdid
The node that the disk’s primary port is connected to (the “n” part of
n:s:p).
INTEGER NOT NULLport_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 NULLport_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 NULLport_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 NULLdiskspeed
The statld Table
The statld_<res>_5 table holds Logical Disk (LD) performance data samples.
212 Database Schema