HP Systems Insight Manager - Manual (Page 621)

NOTE: An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields
in the same table show an asterisk, the primary key connects to each.
HP_Cluster table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT HPCluster _LUID
Node partly identifies HP_NParCell BIGINT NodeID
Snapshot partly identifies HP_NParCell BIGINT SnapshotID
An integer value used to uniquely identify the cluster
membership (A change in the membership of the cluster
results in an increase in the MembershipIncarnation. Thus,
a higher value of this property indicates a more recent set
of cluster members (found by following the
HP_ParticipatingCS associations.) BIGINT MembershipIncarnation
A label by which the object is known NVARCHAR(256) Name
A free-form string that describes the interconnection
mechanism for the cluster NVARCHAR(256) Interconnect
The cluster types (This specifies whether the cluster is for
failover (value=2), performance (3), and so on. The values
which can be specified are not mutually exclusive.
ValueMap { "0", "1", "2", "3", "4", "5", "6" } Values {
"Unknown", "Other", "Failover", "Performance",
"Distributed OS", "Node Grouping", "SysPlex" }) NVARCHAR(256) dc_Types
HP_Node table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT HPNode _LUID
Node partly identifies HP_Node BIGINT NodeID
Snapshot partly identifies HP_Node BIGINT SnapshotID
A label by which the object is known NVARCHAR(256) Name
Describes the name for this member in the generic HP cluster
(The inherited Name value must be fully qualified and
unique within the enterprise, while the MemberName value
can be an abbreviated version unique within the cluster.) NVARCHAR(256) Membername
An integer value uniquely identifying this cluster member
in the generic HP Cluster; assigned when the system is first
added to the cluster and remains unchanged until the system
is removed from the cluster (when this instance is deleted)
(If the member is re-added later to the cluster, a new
instance is created, with a different MemberID value.) INT MemberID
HP_NParCabinet table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT NParCabinet _LUID
Node partly identifies HP_NParCell BIGINT NodeID
Snapshot partly identifies HP_NParCell BIGINT SnapshotID
Values are: Unknown(0), Other(1), 8-cell full height
cabinet(2), 4-cell full height cabinet(3), 4-cell half-height
cabinet(4), 2-cell cabinet(5), I/O expansion cabinet(6).
Examples of these cabinet types: 8-cell full height cabinet
(SD-32000), 4-cell full-height cabinet (SD-16000), 4-cell
half-height cabinet (rp8620), 2-cell cabinet (rx7620) INT CabinetType
Database tables 621