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

Page 310

Advertising
background image

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.

Advertising