Software Owner's manual

Table 82 statld_<res>_5 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_4 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
This is to preserve the LD.VARCHAR(32) NULLLD_NAME
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 207)).
(common performance
columns)
The statldinv Table
The statldinv_<res>_4 table holds the inventory for the statld_<res>_5 table
.
Table 83 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_4 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 84 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
This is to store the port speed in Giga bits per second.INTEGER(11) NOT NULLGBITPS
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_4 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
212 Database Schema