6 the vvspaceinv table, The vvspaceinv table – HP 3PAR System Reporter Software User Manual

Page 317

Advertising
background image

10.25

The Sample Data and Inventory Tables

System Reporter 2.8

3PAR System Reporter User’s Guide

10.4.6 The vvspaceinv Table

The vvspaceinv_<res>_3 table holds the inventory for the vvspace_<res>_3 table.

usr_rawrsvd_mb

DOUBLE PRECISION NOT

NULL

Raw (physical space including RAID

overhead) user space reserved for the

VV in MB.

usr_used_mb

DOUBLE PRECISION NOT

NULL

User space used by the VV in MB.

usr_zn

DOUBLE PRECISION NOT

NULL

User zones in the VV.

usr_free_zn

DOUBLE PRECISION NOT

NULL

Free user zones in the VV.

Table 10-15. vvspace_<res>_3 Table

Column

Type

Comment

Table 10-16. vvspaceinv_<res>_3 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 VV belongs

to. If the VV is not assigned to a domain,

this column contains the value “-”.

vvid

INTEGER NOT NULL

The virtual volume ID.

Advertising