HP 3PAR System Reporter Software - Manual (Page 216)

Table 90 statcpu__1 Table
Comment Type Column
Sample time in secs. This is the Unix time and is the number of
seconds since 0:00:00 Jan 1, 1970 GMT. INTEGER NOT NULL tsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_4 table. INTEGER NOT NULL sys_uid
The node number. INTEGER NOT NULL node
The CPU number in the node. INTEGER NOT NULL cpu
Jiffies (0.01 sec) in user mode. DOUBLE PRECISION NOT
NULL usert
Difference between usert value from last sample for same CPU. DOUBLE PRECISION NOT
NULL d_usert
Jiffies (0.01 sec) in system mode. DOUBLE PRECISION NOT
NULL syst
Difference between syst value from last sample for same CPU. DOUBLE PRECISION NOT
NULL d_syst
Jiffies (0.01 sec) in idle mode. DOUBLE PRECISION NOT
NULL idlet
Difference between idlet value from last sample for same CPU. DOUBLE PRECISION NOT
NULL d_idlet
The CPU tick count. A single count for all CPUs on a node is
maintained in CPU 0, all other CPUs on the node have 0 values for
this column. DOUBLE PRECISION NOT
NULL cputicks
Difference between cputicks value from last sample for same CPU. DOUBLE PRECISION NOT
NULL d_cputicks
The number of interrupts for the CPU. A single count for all CPUs on
a node is maintained in CPU 0, all other CPUs on the node have 0
values for this column. DOUBLE PRECISION NOT
NULL intr
Difference between intr value from last sample for same CPU. DOUBLE PRECISION NOT
NULL d_intr
The number of context switches for the CPU. A single count for all
CPUs on a node is maintained in CPU 0, all other CPUs on the node
have 0 values for this column. DOUBLE PRECISION NOT
NULL ctxt
Difference between ctxt value from last sample for same CPU. DOUBLE PRECISION NOT
NULL d_ctxt
The statcpuinv Table
The statcpuinv__1 table holds the inventory for the statcpu__1 table.
Table 91 statcpuinv__1 Table
Comment Type Column
Sample time in secs. This is the Unix time and is the number of
seconds since 0:00:00 Jan 1, 1970 GMT. INTEGER NOT NULL tsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_4 table. INTEGER NOT NULL sys_uid
The node number. INTEGER NOT NULL node
The CPU number in the node. INTEGER NOT NULL cpu
216 Database Schema