beautypg.com

The statcpuinv table, The statlink table, The statcpuinv table the statlink table – HP 3PAR StoreServ 7000 Storage User Manual

Page 214

background image

Table 89 statcpu__1 Table (continued)

Comment

Type

Column

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 90 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_3 table.

INTEGER NOT NULL

sys_uid

The node number.

INTEGER NOT NULL

node

The CPU number in the node.

INTEGER NOT NULL

cpu

The statlink Table

The statlink__2 table holds the inter-node link performance data samples.

214

Database Schema