The statpdinv table, The statld table, The statpdinv table the statld table – HP 3PAR System Reporter Software User Manual
Page 212
Table 82 statpd_<res>_4 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_4 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 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
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_4 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_<res>_5 table holds Logical Disk (LD) performance data samples.
212
Database Schema