3PAR System Reporter User’s Guide

System Reporter 2.8

10.4.20 The statcpu Table

The statcpu_<res>_1 table holds CPU performance data samples.

Table 10-31.statcpu_<res>_1 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.

 

 

 

node

INTEGER NOT NULL

The node number.

 

 

 

cpu

INTEGER NOT NULL

The CPU number in the node.

 

 

 

usert

DOUBLE PRECISION NOT

Jiffies (0.01 sec) in user mode.

 

NULL

 

 

 

 

d_usert

DOUBLE PRECISION NOT

Difference between usert value from last

 

NULL

sample for same CPU.

 

 

 

syst

DOUBLE PRECISION NOT

Jiffies (0.01 sec) in system mode.

 

NULL

 

 

 

 

d_syst

DOUBLE PRECISION NOT

Difference between syst value from last

 

NULL

sample for same CPU.

 

 

 

idlet

DOUBLE PRECISION NOT

Jiffies (0.01 sec) in idle mode.

 

NULL

 

 

 

 

d_idlet

DOUBLE PRECISION NOT

Difference between idlet value from last

 

NULL

sample for same CPU.

 

 

 

10.50 The Sample Data and Inventory Tables