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

Table 76 cpgspace__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
This is to store the type of disk VARCHAR(32) DISKTYPE
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 NULL cpgid
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
This is to store the raid level INTEGER(11) NOT
NULL RAID_TYPE
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
206 Database Schema