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

Sample time in secs. This is the Unix time

 

NULL

and is the number of seconds since

 

 

0:00:00 Jan 1, 1970 GMT.

 

 

 

sys_uid

INTEGER NOT

A unique identifier for the InServ system

 

NULL

instance refers to the uniq_id for the

 

 

InServ system instance in the system_3

 

 

table.

 

 

 

pdid

INTEGER NOT

The physical disk ID.

 

NULL

 

 

 

 

port_n

INTEGER NOT

The node that the disk’s primary port is

 

NULL

connected to (the “n” part of n:s:p).

 

 

 

port_s

INTEGER NOT

The PCI slot in the node that the disk’s

 

NULL

primary port is connected to (the “s” part

 

 

of n:s:p).

 

 

 

port_p

INTEGER NOT

The port number in the PCI slot in the

 

NULL

node that the disk’s primary port is

 

 

connected to (the “p” part of n:s:p).

 

 

 

disktype

VARCHAR(32) NOT

The disk type. Currently, the disk types

 

NULL

are

 

 

■ FC - Fibre channel drive.

 

 

■ NL - Nearline drive.

 

 

 

The Sample Data and Inventory Tables 10.37