HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
Inherited from CIM_StorageExtent.Access; describes
whether the media is readable, writeable, or both
SMALLINTAccess
(An enumeration: 0 = Unknown, 1 = Readable, 2 =
Writeable, 3 = Read/Write Supported, 4 = Write
Once)
Computed by multiplying
HPUX_LogicalVolume.BlockSize by
HPUX_LogicalVolume.NumberOfBlocks
BIGINTLogicalExtentSize
Capacity of logical volume in number of logical
extent
BIGINTCapacity
Number of the mirrored Copy for the logical volumeINTMirrorCopyNumber
Consistency Recovery Method for the mirrored logical
volume. No value for NOT mirrored Logical Volume
(MWC, NOMWC, NONE)
NVARCHAR(64)ConsistencyRecovery
Access Scheduling Policy of the logical volume; might
have values such as (Striped, Sequential, Parallel)
NVARCHAR(64)SchedulePolicy
Number of stripes for the logical volumeINTNumberOfStripes
Size of stripes for logical volume; value in KBINTStripeSize
Switch of Bad Block Relocation feature; true if it is
on, false otherwise
BITBadBlockRelocation
Allocation Policy of the logical volume; might contain
values such as (Non-Strict, Non-Strict/Contiguous,
NVARCHAR(64)AllocationPolicy
Strict, Strict/Contiguous, PVG-Strict,
PVG-Strict/Contiguous, PVG-Strict/Distributed,
Unknown)
Counter of staled Logical Extent in the logical volume;
valid only the logical volume is mirrored
INTStaledLogicalExtent
Number of read accesses to the logical volumeINTNumberReadAccesses
Number of write accesses to the logical volumeINTNumberWriteAccesses
Availability status of Logical Volume; might contain
values such as (Available/State, Available/Syncd,
Available, Unavailable)
NVARCHAR(64)Status
HPUX_NISServerService table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTNISServerService_LUID
Node partly identifies HPUX_NISServerServiceBIGINTNodeID
Snapshot partly identifies HPUX_NISServerServiceBIGINTSnapshotID
Inherited from CIM_ManagedSystemElement.Name;
the Name property defines the label by which the
object is known
NVARCHAR(256)Name
Equates to CIM_ComputerSystemNVARCHAR(256)SystemCreationClassName
Equates to CIM_ComputerSystem.Name where
NodeID is equal
NVARCHAR(256)SystemName
Equates to HPUX_NISServerServiceNVARCHAR(256)CreationClassName
94 HP SIM database tables