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

Page 329

Advertising
background image

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.

Advertising