The statpdinv table, The statld table, The statpdinv table the statld table – HP 3PAR StoreServ 7000 Storage User Manual
Page 209
Table 79 statpd_<res>_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 205)
).
(common performance
columns)
The statpdinv Table
The statpdinv_<res>_2 table holds inventory for the statpd_<res>_3 table.
Table 80 statpdinv_<res>_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_<res>_5 table holds logical disk (LD) performance data samples.
Table 81 statld_<res>_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 209