User Manual

Table 81 statld_<res>_5 Table (continued)
CommentTypeColumn
The node that owns the LDINTEGER NOT NULLnode
The name of the CPG that the LD belongs to. If the LD is not in a CPG,
this column contains the value “----”.
VARCHAR(32) NOT
NULL
cpg_name
The rest of the columns are the common performance columns described
in “Common Performance Table Columns” (page 205)).
(common performance
columns)
The statldinv Table
The statldinv_<res>_4 table holds the inventory for the statld_<res>_5 table
.
Table 82 statldinv_<res>_4 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 node that owns the LD.INTEGER NOT NULLnode
The name of the CPG that the LD belongs to. If the LD is not in a
CPG, this column contains the value “----”.
VARCHAR(32) NOT
NULL
cpg_name
The statport Table
The statport_<res>_4 table holds port performance data samples.
Table 83 statport_<res>_4 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 node that the port is connected to (the “n” part of n:s:p).INTEGER NOT NULLport_n
The PCI slot in the node that the port is connected to (the “s” part of
n:s:p).
INTEGER NOT NULLport_s
The port number in the PCI slot in the node that the port is connected
to (the “p” part of n:s:p).
INTEGER NOT NULLport_p
The port type. Currently, the port types are:VARCHAR(32) NOT
NULL
porttype
• disk - Fibre channel ports that disks are connected to.
• host -.Fibre channel ports that hosts are connected to (directly or
through a fabric).
• rcip - Remote Copy IP ports.
• rcfc - Remote Copy fibre channel ports.
210 Database Schema