The statldinv table, The statport table, The statldinv table the statport table – HP 3PAR System Reporter Software User Manual

Page 213

Advertising
background image

Table 84 statld_<res>_5 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 domain name that the LD belongs to. If the LD is not assigned to a
domain, this column contains the value “-”.

VARCHAR(32) NOT
NULL

dom_name

The logical disk ID.

INTEGER NOT NULL

ldid

This is to preserve the LD.

VARCHAR(32) NULL

ld_name

The node that owns the LD

INTEGER NOT NULL

node

The name of the CPG that the LD belongs to. If the LD is not in a CPG,
this column contains the value “----”.

VARCHAR(32) NOT
NULL

cpg_name

The rest of the columns are the common performance columns described
in

“Common Performance Table Columns” (page 208)

).

(common performance
columns)

The statldinv Table

The statldinv_<res>_4 table holds the inventory for the statld_<res>_4 table

.

Table 85 statldinv_<res>_4 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 domain name that the LD belongs to. If the LD is not assigned
to a domain, this column contains the value “-”.

VARCHAR(32) NOT
NULL

dom_name

The logical disk ID.

INTEGER NOT NULL

ldid

This is to preserve the LD.

VARCHAR(32) NULL

ld_name

The node that owns the LD.

INTEGER NOT NULL

node

The name of the CPG that the LD belongs to. If the LD is not in a
CPG, this column contains the value “----”.

VARCHAR(32) NOT
NULL

cpg_name

The statport Table

The statport_<res>_4 table holds port performance data samples.

Table 86 statport_<res>_4 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 that the port is connected to (the “n” part of n:s:p).

INTEGER NOT NULL

port_n

The PCI slot in the node that the port is connected to (the “s” part of
n:s:p).

INTEGER NOT NULL

port_s

The Sample Data and Inventory Tables

213

Advertising