OVNPM 1.5.2 - Performance Monitor User and Installation Guide

HP Performance Monitor Database Schema 35
6-2 Tables of Database Schema
The Database schema consists of the following tables:
• Configuration Tables
• Metric Data Tables
• Stat Data Tables
6-2-1 Configuration Tables
PM Logger collects the HP NonStop configuration information using the Configuration files. These configuration
parameters are used to connect to the database. The NonStop Server consists of certain predefined active entities
like domains, metrices, and instances. The Information in these entities is termed as static information and the
tables being used to maintain static information inside InsightCollectDB are called Configuration Tables.
Table: NodeConfig
Column Name
Data Type
Description
NodeID
Integer
Specifies the Node ID
NSKConfigId
Integer
Specifies the NSK Configuration ID
NodeName
Varchar(30)
Specifies the Node Name
ConfigName
Varchar(30)
Specifies the Configuration Name
LastCollectTS
Datetime
Specifies the Last Collected Performance data time stamp
LastTix
Integer
Specifies the last collected Tix Number
GMTCollection
Integer
Specifies whether the data logged to the database is logged
with a UTC timestamp or not. This is entirely dependent on the
entries in the HOSTTIMEINFO table for the corresponding
configuration.
RetentionPeriod Integer Specifies the time period in days for which data needs to be
retained in the performance data tables.
Table: Domain Map
Column Name
Data Type
Description
NodeID
Integer
Specifies the Node ID
DomainId
Integer
Specifies the Domain ID
NSKDomainId
Integer
Specifies the NSK Domain ID
InsightFlag
Bit
Specifies whether the Insight Performance data will be collected
or not
TrendFlag Bit Specifies whether the Trend Performance data will be collected
or not
ReportFlag
Bit
Specifies whether the Report Performance data will be collected
or not
Table: Domain
Column Name
Data Type
Description
DomainName
Varchar(30)
Specifies the Domain Name
DomainID
Integer
Specifies the Domain ID
HP Performance Monitor
Database Schema