beautypg.com

The vvspace table – HP 3PAR System Reporter Software User Manual

Page 203

background image

Table 73 ldspaceinv__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 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

The LD name.

VARCHAR(32) NOT
NULL

ld_name

The disk type. Currently, the disk types are

VARCHAR(32) NOT
NULL

disktype

FC - Fibre channel drive.

NL - Nearline drive.

The node number of the owner of the LD.

INTEGER NOT NULL

owner

The node number of the backup owner of the LD.

INTEGER NOT NULL

backup_flag

The RAID type of the LD.

INTEGER NOT NULL

raid_type

The name of the CPG that the LD belongs to. If the LD does not belong
to a CPG the name is “-”.

VARCHAR(32) NOT
NULL

cpg_name

Describes what the LD is used for. The possible values are described
in

Table 27 (page 89)

.

VARCHAR(32) NOT
NULL

ld_use

The vvspace Table

The vvspace__3 table holds virtual volume (VV) space data samples.

Table 74 vvspace__3 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 VV belongs to. If the VV is not assigned to a
domain, this column contains the value “-”.

VARCHAR(32)
NOT NULL

dom_name

The virtual volume ID.

INTEGER NOT
NULL

vvid

The ID of the base VV for the VV.

INTEGER NOT
NULL

bsid

The VV name.

VARCHAR(32)
NOT NULL

vv_name

The WWN of the VV.

CHAR(32) NOT
NULL

wwn

The name of the CPG, if any, that is associated with the VV’s snapshot space.
If the VV snapshot space is not associated with a CPG, this column is “-”.

VARCHAR(32)
NOT NULL

snp_cpg_name

The name of the CPG, if any, that is associated with the VV’s user space. If
the VV user space is not associated with a CPG, this column is “-”.

VARCHAR(32)
NOT NULL

usr_cpg_name

The Sample Data and Inventory Tables 203