10 the statpd table, The statpd table – HP 3PAR System Reporter Software User Manual
Page 329

10.37
The Sample Data and Inventory Tables
System Reporter 2.8
3PAR System Reporter User’s Guide
10.4.10 The statpd Table
The statpd_<res>_3 table holds physical disk (PD) performance data samples.
Table 10-21. statpd_<res>_3 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.