System Reporter 2.8

3PAR System Reporter User’s Guide

10.4.7 The cpgspace Table

The cpgspace_<res>_1 table holds Common Provisioning Group (CPG) space data samples.

Table 10-17.cpgspace_<res>_1 Table

Column

Type

Comment

 

 

 

tsecs

INTEGER NOT NULL

Sample time in secs. This is the Unix

 

 

time and is the number of seconds

 

 

since 0:00:00 Jan 1, 1970 GMT.

 

 

 

sys_uid

INTEGER NOT NULL

A unique identifier for the InServ

 

 

system instance refers to the uniq_id

 

 

for the InServ system instance in the

 

 

system_3 table.

 

 

 

dom_name

VARCHAR(32) NOT NULL

The domain name that the CPG

 

 

belongs to. If the CPG is not assigned

 

 

to a domain, this column contains the

 

 

value “-”.

 

 

 

cpgid

INTEGER NOT NULL

The common provisioning group ID.

 

 

 

cpg_name

VARCHAR(32) NOT NULL

The common provisioning group

 

 

name.

 

 

 

adm_total_mb

DOUBLE PRECISION NOT

The total admin LD space in the CPG

 

NULL

in MB.

 

 

 

adm_rawtotal_mb

DOUBLE PRECISION NOT

The total raw (including RAID

 

NULL

overhead) admin space in the CPG in

 

 

MB.

 

 

 

adm_used_mb

DOUBLE PRECISION NOT

The used admin LD space in the CPG

 

NULL

in MB.

 

 

 

adm_rawused_mb

DOUBLE PRECISION NOT

The raw (including RAID overhead)

 

NULL

used admin LD space in the CPG in

 

 

MB.

 

 

 

The Sample Data and Inventory Tables 10.27