Page tree
Skip to end of metadata
Go to start of metadata

The full text of this page is only available to our customers.

Please login or sign up. You may also need to provide your support ID if you have not already done so.

Product Name
Publisher Page
Nonrelational Database Management Systems
TKU 2019-04-1
More Information
Publisher Link

Product Description

The cluster-based, column-oriented Vertica Analytics Platform is designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications.


Known Versions

  • 3.0
  • 3.5
  • 4.1
  • 5.0
  • 5.1
  • 6.0
  • 6.1
  • 7.0
  • 7.1
  • 7.2

Software Pattern Summary

Product Component

OS Type


Pattern Depth

VerticaDBNodeUnixActive, PackageInstance based
Vertica_ClusterRelated SISecond-order SI


Platforms Supported by the Pattern

The patterns discover HP Vertica deployed on UNIX platforms only.


Software Instance Triggers


Trigger Node




VerticaDBNodeDiscovered Processcmdmatchesvertica
Vertica_ClusterSoftware Instancetype=HP Vertica Database Node


Simple Identification Mappings

The trigger process is given a simple identification mapping:




'HP Vertica Agent'

unix_cmd 'bash'

regex "vertica/agent"

'HP Vertica Management Console'

unix_cmd 'java'

regex "vconsole/lib"



'HP Vertica Database'

unix_cmd 'vertica'

'HP Vertica Database Spread'

unix_cmd 'spread'

Obtaining install root

The VerticaDBNode pattern obtains install root from process using regex:

  • "(?i)(/\S+)/bin/vertica"

Obtaining the version information

Active Versioning

The VerticaDBNode pattern executes the following command :

  • "process.cmd --version"

From the output full version is extracted using regex :

  • '(?i)vertica\(v(\d+(?:\.\d+)*)'

Package Versioning

The VerticaDBNode pattern looks for packages installed that would match regex "(?i)^vertica"

Obtaining database details

The VerticaDBNode pattern obtains db details from process arguments using the following regexes:

  • "-C\s+(\S+)" - for db node type
  • "-D\s+(\S+)" - for db home
  • "-n\s+(\S+)" - for db node id

Application Model Produced by Software Pattern


BMC Atrium Discovery uses the following approach for modeling HP Vertica components.

Software Pattern Model

Pattern Trigger

The VerticaDBNode pattern triggers on a discovered process with command line that matches specific regular expression.

The Vertica_Cluster pattern triggers on a created and confirmed HP Vertica Database Node SI that would have cluster_hosts attribute.

SI Depth

TheVerticaDBNode pattern creates an instance-based Software Instance with the key based on the SI type, and the host key.

The Vertica_Cluster pattern creates a second-order Software Instance with the key based on the cluster_hosts attribute and the SI type.

Software Context view

The image below is an example of software context view of the HP Vertica and related software:


Relationship creation

The pattern creates the following relationships:

model.setContainment :

  • Containment relationships where HP Vertica Database contains the trigger HP Vertica Database Node SIs that belongs to the same cluster hosts group.

Subject Matter Expertise

Subject Matter Expert input will be welcome on any other potential approaches not discussed to improving product versioning coverage and depth of
HP Vertica model.

Information Sources

Open Issues

There are no known open issues with this pattern.

The full text of this page is only available to our customers.

Please login or sign up. You may also need to provide your support ID if you have not already done so.