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

The statlink Table
The statlink__2 table holds the inter-node link performance data samples.
Table 94 statlink__2 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 node number of the destination of the link. INTEGER NOT NULL node_to
The name of the Queue. VARCHAR (32) NOT
NULL queue
Timestamp value indicating when the counting started (typically when
the system was rebooted or the device was created). Two count DOUBLE PRECISION NOT
NULL begin_msec
samples should only be compared if the begin value is the same for
the two samples.
Difference between begin value from last sample for the same object. DOUBLE PRECISION NOT
NULL d_begin_msec
Timestamp value in microseconds. The difference in the now values
of two samples should be used in calculating the time interval
between two samples. DOUBLE PRECISION NOT
NULL now_msec
Difference between now value from last sample for the same object. DOUBLE PRECISION NOT
NULL d_now_msec
Total number of transfers on the queue since the node was started. DOUBLE PRECISION NOT
NULL xfers
Difference between xfers value from last sample for the same object. DOUBLE PRECISION NOT
NULL d_xfers
Total number of bytes transferred on the queue since the node was
started. DOUBLE PRECISION NOT
NULL bytes
Difference between bytes value from last sample for the same object. DOUBLE PRECISION NOT
NULL d_bytes
The statlinkinv Table
The statlinkinv__2 table holds the inventory for the statlink__2 table.
Table 95 statlinkinv__2 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 node number of the destination of the link. INTEGER NOT NULL node_to
The name of the Queue. VARCHAR (32) NOT NULL queue
The statldrg Table
The statldrg_hourly_2 table holds the LD region performance data. Only hourly samples are kept.
218 Database Schema