User Manual

The ldspace Table
The ldspace_<res>_3 table holds logical disk (LD) space data samples.
Table 71 ldspace_<res>_3 Table
CommentTypeColumn
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 NULLtsecs
A unique identifier for the system instance refers to the uniq_id for the
system instance in the system_3 table.
INTEGER NOT NULLsys_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 NULLldid
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 NULLowner
The node number of the backup owner of the LD.INTEGER NOT NULLbackup_flag
The RAID type of the LDINTEGER NOT NULLraid_type
The set size of the LD.INTEGER NOT NULLset_size
Step size of the LD.INTEGER NOT NULLstep_size
Row size of the LD.INTEGER NOT NULLrow_size
Raw size of the LD in MB.INTEGER NOT NULLrawsizemb
Size of the LD in MB.INTEGER NOT NULLsizemb
Used MB in the LD.INTEGER NOT NULLusedmb
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_<res>_2 table holds the inventory for the ldspace_<res>_2 table.
200 Database Schema