The ldspace table, The ldspaceinv table, The ldspace table the ldspaceinv table – HP 3PAR StoreServ 7000 Storage User Manual
Page 200
The ldspace Table
The ldspace_<res>_3 table holds logical disk (LD) space data samples.
Table 71 ldspace_<res>_3 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_3 table.
INTEGER NOT NULL
sys_uid
The domain name that the LD belongs to. If the LD is not assigned to
a domain, this column contains the value “-”.
VARCHAR(32) NOT
NULL
dom_name
The logical disk ID.
INTEGER NOT NULL
ldid
The LD name.
VARCHAR(32) NOT
NULL
ld_name
The disk type. Currently, the disk types are:
VARCHAR(32) NOT
NULL
disktype
•
FC - Fibre channel drive.
•
NL - Nearline drive.
The node number of the owner of the LD.
INTEGER NOT NULL
owner
The node number of the backup owner of the LD.
INTEGER NOT NULL
backup_flag
The RAID type of the LD
INTEGER NOT NULL
raid_type
The set size of the LD.
INTEGER NOT NULL
set_size
Step size of the LD.
INTEGER NOT NULL
step_size
Row size of the LD.
INTEGER NOT NULL
row_size
Raw size of the LD in MB.
INTEGER NOT NULL
rawsizemb
Size of the LD in MB.
INTEGER NOT NULL
sizemb
Used MB in the LD.
INTEGER NOT NULL
usedmb
The name of the CPG that the LD belongs to. If the LD does not belong
to a CPG the name is “-”.
VARCHAR(32) NOT
NULL
cpg_name
Describes what the LD is used for. The possible values are described
in
.
VARCHAR(32) NOT
NULL
ld_use
The state of the LD.
VARCHAR(32) NOT
NULL
ld_state
The intended availability of the LD.
VARCHAR(32) NOT
NULL
avail
The current (actual) availability of the LD.
VARCHAR(32) NOT
NULL
cavail
The ldspaceinv Table
The ldspaceinv_<res>_2 table holds the inventory for the ldspace_<res>_2 table.
200 Database Schema