HP 3PAR System Reporter 3.1.0 Software User's Guide (QL226-96645, December 2012)

Table 75 cpgspace_<res>_1 Table
CommentTypeColumn
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 NULLtsecs
A unique identifier for the system instance refers to the uniq_id for the
system instance in the system_3 table.
INTEGER NOT NULLsys_uid
The domain name that the CPG belongs to. If the CPG is not assigned
to a domain, this column contains the value “-”.
VARCHAR(32) NOT
NULL
dom_name
The common provisioning group ID.INTEGER NOT NULLcpgid
The common provisioning group name.VARCHAR(32) NOT
NULL
cpg_name
The total admin LD space in the CPG in MB.DOUBLE PRECISION
NOT NULL
adm_total_mb
The total raw (including RAID overhead) admin space in the CPG in
MB.
DOUBLE PRECISION
NOT NULL
adm_rawtotal_mb
The used admin LD space in the CPG in MB.DOUBLE PRECISION
NOT NULL
adm_used_mb
The raw (including RAID overhead) used admin LD space in the CPG
in MB.
DOUBLE PRECISION
NOT NULL
adm_rawused_mb
The total snapshot LD space in the CPG in MB.DOUBLE PRECISION
NOT NULL
snp_total_mb
The total raw (including RAID overhead) snapshot space in the CPG
in MB.
DOUBLE PRECISION
NOT NULL
snp_rawtotal_mb
The used snapshot LD space in the CPG in MB.DOUBLE PRECISION
NOT NULL
snp_used_mb
The raw (including RAID overhead) used snapshot LD space in the
CPG in MB.
DOUBLE PRECISION
NOT NULL
snp_rawused_mb
The total user LD space in the CPG in MB.DOUBLE PRECISION
NOT NULL
usr_total_mb
The total raw (including RAID overhead) user space in the CPG in
MB.
DOUBLE PRECISION
NOT NULL
usr_rawtotal_mb
The used user LD space in the CPG in MB.DOUBLE PRECISION
NOT NULL
usr_used_mb
The raw (including RAID overhead) used user LD space in the CPG
in MB.
DOUBLE PRECISION
NOT NULL
usr_rawused_mb
The warning limit of the CPG in MB.DOUBLE PRECISION
NOT NULL
warn_mb
The allocation (hard) limit of the CPG in MB.DOUBLE PRECISION
NOT NULL
limit_mb
The growth size of the CPG in MB.DOUBLE PRECISION
NOT NULL
gsize_mb
The raw free space available for the CPG.DOUBLE PRECISION
NOT NULL
rawfree_mb
The usable free space available for the CPG.DOUBLE PRECISION
NOT NULL
usablefree_mb
204 Database Schema