2 the pdspaceinv table, The pdspaceinv table – HP 3PAR System Reporter Software User Manual
Page 310

10.18
The Sample Data and Inventory Tables
3PAR System Reporter User’s Guide
System Reporter 2.8
10.4.2 The pdspaceinv Table
The pdspaceinv_<res>_2 table holds the inventory for the pdspace_<res>_3 table.
Table 10-12. pdspaceinv_<res>_21Table
Column
Type
Comment
tsecs
INTEGER NOT NULL
Sample time in secs of the most recent
sample for the PD in the corresponding data
table. 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.
cageid
INTEGER NOT NULL
The cage ID that the PD is in
cageside
INTEGER NOT NULL
The side of the disk chassis that the cage is in.
mag
INTEGER NOT NULL
The magazine number in the cage that the
PD is in.
disk
INTEGER NOT NULL
The disk number in the magazine.
disktype
VARCHAR(32) NOT NULL
The disk type. Currently, the disk types are
■
FC - Fibre channel drive.
■
NL - Nearline drive.
diskspeed
INTEGER NOT NULL
The approximate disk speed in K RPM.
wwn
CHAR(16) NOT NULL
The WWN of the PD.