7 the cpgspace table, The cpgspace table – HP 3PAR System Reporter Software User Manual

Page 319

Advertising
background image

10.27

The Sample Data and Inventory Tables

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

NULL

The total admin LD space in the CPG

in MB.

adm_rawtotal_mb

DOUBLE PRECISION NOT

NULL

The total raw (including RAID

overhead) admin space in the CPG in

MB.

adm_used_mb

DOUBLE PRECISION NOT

NULL

The used admin LD space in the CPG

in MB.

adm_rawused_mb

DOUBLE PRECISION NOT

NULL

The raw (including RAID overhead)

used admin LD space in the CPG in

MB.

Advertising