HP 3PAR StoreServ 7000 Storage - Manual (Page 200)

The ldspace Table
The ldspace__3 table holds logical disk (LD) space data samples.
Table 71 ldspace__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
Table 28 (page 88) .
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__2 table holds the inventory for the ldspace__2 table.
200 Database Schema